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.44

 

(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:
    • For cPanel & WHM version 11.44.1.9 and later:
      • 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.

    • For earlier versions of cPanel & WHM:
      • Unattended Upgrade — This option requires no additional input from you. If you select this type of upgrade, you must also choose one of the following options:

        • Rebuild Apache and PHP automatically with last saved defaults. — Choose this option if you wish your server to rebuild Apache and PHP automatically after the MySQL upgrade is complete.
        • I will manually rebuild Apache and PHP when the MySQL upgrade is complete. — Choose this option if you wish to rebuild Apache and PHP manually after the upgrade is complete.
      • Interactive Upgrade — This option requires you to step through the remainder of the upgrade in the MySQL Upgrade interface.

        Remember:

        The remaining steps below only apply if you chose the Interactive Upgrade option.

  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