(WHM >> Home >> Software >> MySQL/MariaDB Upgrade)
This interface allows you to manage MySQL® or MariaDB® version upgrades (for example, when you upgrade from MySQL 5.5 to 5.6). After you select your MySQL or MariaDB version, WHM automatically keeps your database engine up-to-date. This means, for example, that whenever the vendor releases a new patch for your version of MySQL or MariaDB, WHM automatically applies the patch to your installation.
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 or later.
The following versions of MySQL are available:
The following versions of MariaDB are available:
To upgrade your server's version of MySQL or MariaDB, perform the following steps:
Select the version of MySQL or MariaDB that you wish to upgrade.
To reinstall your database, select your current version of MySQL or MariaDB.
Click Next. A new interface will appear with warning messages about the upgrade process.
The system validates the
Unattended Upgrade — This option automatically rebuilds Apache and PHP with the last saved defaults. It also automatically updates Ruby Gems and rebuilds Apache and PHP.
Partially-Interactive Upgrade — This option automatically updates Ruby Gems, but it does 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 Ruby Gems update, the MySQL or MariaDB upgrade, and the Apache and PHP rebuild.
Select or deselect the Autoscroll output checkbox to change whether the output display scrolls as the upgrade runs.
When the upgrade finishes, the interface displays the following message:
Upgrade finished successfully.
You must now recompile any software on your system that depended on the old version of MySQL or MariaDB so that it is compatible with the new version.
The system stores the MySQL and MariaDB log files in the
The log files use the
mysql_upgrade_log.YYYYMMDD-hhmmss naming convention with the following designators: