MySQL5 default

[Matthew Seaman]

dick hoogendijk wrote:

> MySQL is now the default. OK. But what happens if I run the command
> "portupgrade -rfo databases/mysql50-client mysql-client"
> 
> Nothing's is said about database compatibilities.
> 
> Q: is it needed to change (advantages?)
> Q: is it safe to change? ;-)
> Q: how do I use my existing databases after the upgrade?
> 
> 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
 


-- 
Dr Matthew J Seaman MA, D.Phil.                       7 Priory Courtyard
                                                      Flat 3
PGP: http://www.infracaninophile.co.uk/pgpkey         Ramsgate
                                                      Kent, CT11 9PW

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 250 bytes
Desc: OpenPGP digital signature
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20060625/9e4219c3/signature.pgp