MySQL - Upgrading

What is the general procedure for upgrading?

  1. You must check the implication and possible difficulties before upgrading.
    1. Check the MySQL Reference Manual
    2. Always consult the section on upgrading to see whether there are any notes pertaining to the type of upgrade you are performing. If so, follow the recommended procedures describe there.
    3. Check the change note sections for version more recent than your current version to make sure that you are aware of what has changed since your current version. Note particularly any changes that are not backward compatible with your current version because they may require modifications to your existing applications.
    4. Despite those cautionary remarks, upgrading MySQL usually is straightforward and can be done using the following procedure:
  2. Back up your databases.
  3. Stop the server.
  4. Install the new version of MySQL on top of existing version.
  5. Start the new server.

If you install a new version 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 these types of installations tend to use the same installation directory regardless of version. However, if you upgrade using a tar file, the new distribution will likely 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 symbollic 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.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License