Date: Sun, 25 Jun 2006 10:16:09 +0100 From: Matthew Seaman <m.seaman@infracaninophile.co.uk> To: dick hoogendijk <dick@nagual.st> Cc: freebsd-questions <freebsd-questions@freebsd.org> Subject: Re: MySQL5 default Message-ID: <449E5459.4010203@infracaninophile.co.uk> In-Reply-To: <20060625073718.GA25108@arwen.nagual.st> References: <20060625073718.GA25108@arwen.nagual.st>
next in thread | previous in thread | raw e-mail | index | archive | help
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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?449E5459.4010203>