24.9. Upgrading MySQL


MySQL development is ongoing, and MySQL AB releases new versions frequently. New versions add new features and correct problems found in older versions. Nevertheless, you should not upgrade to a newer version of MySQL without checking the implications and possible difficulties of doing so. Check the MySQL Reference Manual before performing any upgrade:

  • Always consult the section on upgrading to see whether there are any notes pertaining to the type of upgrade you're performing. If so, follow the recommended procedures described there.

  • Check the change note sections for versions more recent than your current version to make sure that you're aware of what has changed since your original install. Note particularly any changes that are not backward compatible with your current version because they may require modifications to your existing applications if you upgrade.

Despite those cautionary remarks, upgrading MySQL usually is straightforward and can be done using the following procedure:

  • Back up your databases.

  • Stop the server.

  • Install the new version of MySQL on top of the existing version.

  • Start the new server.

If you install a new version of MySQL on top of an existing one, you might not need to do much reconfiguring. This is common for Windows installations, RPM installations, and installations from source because those types of distributions each tend to use the same installation directory location regardless of MySQL version. However, if you upgrade MySQL using a tar file, the new distribution likely will create a new version-specific base installation directory that differs from your existing installation directory. In this case, some reconfiguration might be necessary. If you have a symbolic link set up that points to the old installation directory, you can delete the link and re-create it to point to the new installation directory. Subsequent references to the new symbolic link will access the new installation.

Upgrading MySQL sometimes gives you access to new security features. See Chapter 36, "Upgrade-Related Security Issues," for information about taking advantage of them.



MySQL 5 Certification Study Guide
MySQL 5.0 Certification Study Guide
ISBN: 0672328127
EAN: 2147483647
Year: 2006
Pages: 312

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net