Page tree
Skip to end of metadata
Go to start of metadata

This document is for a previous release of cPanel & WHM. To view our latest documentation, visit our Home page.

For cPanel & WHM 11.46

 

(Home >> Software >> MySQL Upgrade)

Overview

This interface allows you to manage MySQL® version upgrades (for example, when you upgrade from MySQL 5.5 to 5.6). After you select your MySQL version, WHM will automatically keep your MySQL installation up-to-date. This means that when a new patch is released for your version of MySQL, WHM will automatically apply the patch to your installation.

Warning

  • This feature does not support downgrades of MySQL versions. We strongly recommend that you do not attempt to downgrade MySQL.
  • If CloudLinux's™ MySQL governor is installed on your server, MySQL upgrades will not work via the MySQL Upgrade interface. If you wish to remove MySQL Governor, read CloudLinux's MySQL Governor documentation and research how this will affect you.

Note:

$body

Available MySQL versions

The following versions of MySQL are available:

  • MySQL 5.5
  • MySQL 5.6

Upgrade MySQL

To upgrade your server's version of MySQL, perform the following steps:

  1. Select the version of MySQL to which you wish to upgrade.
  2. Click Next. A new interface will appear with warning messages that are related to the upgrade process.
  3. Select the checkbox next to each warning to acknowledge that you are aware of the potential consequences of the upgrade.
  4. Click Continue.
  5. Select the type of upgrade that you wish to perform:
    • Unattended Upgrade — This option automatically rebuilds Apache and PHP with the last saved defaults. It will also automatically update Ruby Gems, and rebuild Apache and PHP.

    • Partially-Interactive Upgrade — This option automatically updates Ruby Gems, but it will not rebuild Apache and PHP until you choose to do so.

    • Interactive Upgrade — This option steps you through the upgrade process. This process includes the update of Ruby Gems, the update of MySQL, and the rebuild of Apache and PHP.

  6. Your server will upgrade to the selected version of MySQL.
    • Select or deselect the Autoscroll output checkbox to change whether the output display scrolls as the upgrade runs.
    • When the upgrade is complete, the following message will display:

      Upgrade finished successfully. You must now recompile any other software on your system that was compiled to use the previous version of MySQL.
  7. Click Continue.
  8. Your server will check whether you need to recompile any Ruby Gems. Follow the displayed instructions, and then click Continue.
  9. Select one of the following options to rebuild Apache and PHP:
    • Rebuild Apache and PHP using saved settings — Choose this option to rebuild Apache and PHP with the last settings you used. If you choose this option, the Apache and PHP rebuild process will take place within the MySQL Upgrade interface.
    • Rebuild Apache and PHP with new settings — Choose this option to rebuild Apache and PHP with new settings. If you choose this option, the EasyApache (Apache Update) interface (Home >> Software >> EasyApache (Apache Update)) will appear so you may complete the rebuild process.

MySQL upgrade log

The log files for MySQL are located in the /var/cpanel/logs directory.

The log file in relation to an upgrade is labeled as mysql_upgrade_log.YYYYMMDD-HHMMSS where the following designators are used:

DesignatorDescription
YYYYFour-digit year
MMTwo-digit month
DDTwo-digit day
HHTwo-digit hour
MMTwo-digit minute
SSTwo-digit second