For cPanel & WHM 11.46
(Home >> Software >> MySQL Upgrade)
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.
- 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.
If your server uses a version of MySQL that is older than MySQL version 5.5, you must upgrade to MySQL version 5.5 before you can upgrade to MySQL version 5.6.
Available MySQL versions
The following versions of MySQL are available:
- MySQL 5.5
- MySQL 5.6
To upgrade your server's version of MySQL, perform the following steps:
- Select the version of MySQL to which you wish to upgrade.
- Click Next. A new interface will appear with warning messages that are related to the upgrade process.
- Select the checkbox next to each warning to acknowledge that you are aware of the potential consequences of the upgrade.
- Click Continue.
- 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.
- 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:
- Click Continue.
- Your server will check whether you need to recompile any Ruby Gems. Follow the displayed instructions, and then click Continue.
- 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
The log file in relation to an upgrade is labeled as
mysql_upgrade_log.YYYYMMDD-HHMMSS where the following designators are used: