From owner-freebsd-questions@FreeBSD.ORG Sun Jun 25 09:16:33 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 90CF116A40A for ; Sun, 25 Jun 2006 09:16:33 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from smtp.infracaninophile.co.uk (ns0.infracaninophile.co.uk [81.187.76.162]) by mx1.FreeBSD.org (Postfix) with ESMTP id 5DBCF43D45 for ; Sun, 25 Jun 2006 09:16:31 +0000 (GMT) (envelope-from m.seaman@infracaninophile.co.uk) Received: from [IPv6:::1] (localhost [IPv6:::1]) by smtp.infracaninophile.co.uk (8.13.6/8.13.6) with ESMTP id k5P9GGlD021953; Sun, 25 Jun 2006 10:16:16 +0100 (BST) (envelope-from m.seaman@infracaninophile.co.uk) Message-ID: <449E5459.4010203@infracaninophile.co.uk> Date: Sun, 25 Jun 2006 10:16:09 +0100 From: Matthew Seaman Organization: Infracaninophile User-Agent: Thunderbird 1.5.0.4 (X11/20060610) MIME-Version: 1.0 To: dick hoogendijk References: <20060625073718.GA25108@arwen.nagual.st> In-Reply-To: <20060625073718.GA25108@arwen.nagual.st> X-Enigmail-Version: 0.94.0.0 Content-Type: multipart/signed; micalg=pgp-ripemd160; protocol="application/pgp-signature"; boundary="------------enigDF2CF58AFB187156D7C4ADE2" X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-2.0.2 (smtp.infracaninophile.co.uk [IPv6:::1]); Sun, 25 Jun 2006 10:16:16 +0100 (BST) X-Virus-Scanned: ClamAV 0.88.2/1562/Fri Jun 23 08:50:07 2006 on happy-idiot-talk.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-1.9 required=5.0 tests=AWL,BAYES_00,NO_RELAYS autolearn=ham version=3.1.3 X-Spam-Checker-Version: SpamAssassin 3.1.3 (2006-06-01) on happy-idiot-talk.infracaninophile.co.uk Cc: freebsd-questions Subject: Re: MySQL5 default X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 25 Jun 2006 09:16:33 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigDF2CF58AFB187156D7C4ADE2 Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: quoted-printable dick hoogendijk wrote: > MySQL is now the default. OK. But what happens if I run the command > "portupgrade -rfo databases/mysql50-client mysql-client" >=20 > Nothing's is said about database compatibilities. >=20 > Q: is it needed to change (advantages?) > Q: is it safe to change? ;-) > Q: how do I use my existing databases after the upgrade? >=20 > Thanks for the help / advice. In general, MySQL 5.0 is fully backward compatible with MySQL 4.1. The advantages of updating are improved performance, longer support lifetime,= bug fixes and new functionality like stored procedures. Updating is generally safe, but make sure to have good backups just in case. Data files etc. are compatible between the two versions, but you should run the 'mysql_upgrade' script (part of mysql-server-5.0.22) which will fix up anything that needs to be fixed as a consequence of the= upgrade -- there tend to be regular changes to what Grants are available which means altering various of the mysql.* tables. All your existing databases will be immediately usable after that, and in= exactly the same way as you used them before. There's not even any need = to dump and reload databases. Cheers, Matthew =20 --=20 Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate Kent, CT11 9PW --------------enigDF2CF58AFB187156D7C4ADE2 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (FreeBSD) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEnlRf8Mjk52CukIwRA8tPAJ9tr92D/KYxHU7xo282hcR06bEEPACdHerg 7pZRabF9MvSkvdzcWavXXtA= =laNv -----END PGP SIGNATURE----- --------------enigDF2CF58AFB187156D7C4ADE2--