MySQL Upgrade

For WHM version 11.40

(Home >> Software >> MySQL Upgrade)

Overview

This interface allows you to manage MySQL version upgrades (e.g., upgrading MySQL 4.0 to 4.1 or MySQL 4.1 to 5.1). Once you have selected your MySQL version, cPanel will automatically keep your MySQL installation up-to-date. This means that when a new patch is released for your version of MySQL, cPanel will automatically apply the patch to your installation.

ALERT! Warning: This feature does not support downgrading MySQL versions. Downgrades are not recommended.

Possible PHPMyAdmin Version Incompatibility

cPanel 11.25 added support for PHPMyAdmin 3. When upgrading to MySQL 5.0 and higher, PHPMyAdmin 3 is automatically installed. cPanel uses its own PHP binary (in /usr/local/cpanel/3rdparty/bin) to serve internal PHP applications, such as PHPMyAdmin. This is important because PHPMyAdmin 3 is not compatible with PHP 4. If you have not changed cPanel's internal PHP, you will not experience any problems with your MySQL upgrade. However, if you have overwritten cPanel's internal PHP binary (found in /usr/local/cpanel/3rdparty/bin) with PHP 4, upgrading to MySQL 5.0 or higher will result in a broken PHPMyAdmin installation.

Unattended Upgrade

  1. Select the version of MySQL you wish to use from the first page.
  2. On the second page, confirm that you want to continue with the upgrade by clicking every available checkbox.
    • note Note: This page of the MySQL Upgrade feature displays warning messages. Make sure to read these messages before continuing with the upgrade.
  3. Select whether you would like to rebuild Apache and PHP automatically or manually under Unattended upgrade.
    • If you select to rebuild Apache and PHP with new settings, select the appropriate options from the EasyApache Interface.
    • If you select to rebuild Apache and PHP using saved settings, the process will run automatically.
  4. To finish the process, click Continue.

Interactive Upgrade

  1. Select the version of MySQL you wish to use from the first page.
  2. On the second page, confirm that you want to continue with the upgrade by clicking every available checkbox.
    • note Note: This page of the MySQL Upgrade feature displays warning messages. Make sure to read these messages before continuing with the upgrade.
  3. Select Interactive upgrade and click Continue.
  4. Once the upgrade has completed, click Continue.
  5. Your Ruby MySQL gem may need to be recompiled. If necessary, the Ruby MySQL gem will recompile on its own. When it is finished, click Continue.
  6. PHP for cPanel and WHM may need to be recompiled. If necessary, PHP for cPanel and WHM will recompile automatically. When it is finished, click Continue.
  7. Select whether you wish to rebuild Apache and PHP with the saved settings or with new settings:
    • If you select to rebuild Apache and PHP with new settings, select the appropriate options from the EasyApache Interface.
    • If you select to rebuild Apache and PHP using saved settings, the process will run automatically.
  8. To finish the process, click Back.

MySQL Upgrade Log

The log file for MySQL is located in /var/cpanel/logs

The log file in relation to upgrades is labeled as mysql_upgrade_log.YYYYMMDD-HHMMSS where:

Designator Description
YYYY Four-digit year
MM Two-digit month
DD Two-digit day
HH Two-digit hour
MM Two-digit minute
SS Two-digit second

Topic revision: r13 - 18 Dec 2013 - 20:40:06 - Main.StacyWyatt
AllDocumentation/WHMDocs.MySQLUpgrade moved from Sandbox.MySQLUpgrade on 15 Dec 2009 - 23:38 by Main.JustinSchaefer - put it back