{"id":4371,"date":"2019-04-24T15:37:46","date_gmt":"2019-04-24T19:37:46","guid":{"rendered":"https:\/\/www.globo.tech\/learning-center\/?p=4371"},"modified":"2019-04-24T21:16:37","modified_gmt":"2019-04-25T01:16:37","slug":"upgrading-from-mysql-5-5-using-whm-cpanel","status":"publish","type":"post","link":"https:\/\/www.globo.tech\/learning-center\/upgrading-from-mysql-5-5-using-whm-cpanel\/","title":{"rendered":"Upgrading from MySQL 5.5 using WHM\/cPanel"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

Still running MySQL 5.5 on your cPanel & WHM server? It’s important to know that this version of MySQL has been in its end-of-life (EOL) status since December, 2018. As a result, no more security, bug fixes, or updates will be available for servers that are still running MySQL 5.5. Major control panel providers already started to drop the support for MySQL 5.5 as well. That said, time has come to upgrade to a newer version of MySQL or MariaDB.<\/p>\n\n\n\n

cPanel & WHM also announced that they will block any panel updates for servers running MySQL 5.5 from version 80. So, that is another good reason not to stick to the old version of MySQL.<\/p>\n\n\n\n

To Which Version Should MySQL 5.5 be Upgraded?<\/h2>\n\n\n\n

Considering that MySQL 5.6 will be in its EOL status by February, 2021, it may be better to upgrade to MySQL 5.7 or MariaDB 10.3. MySQL 5.6 will only last for a few years; hence, upgrading to MySQL 5.7 is strongly recommended. This will ensure that you can enjoy the new and improved features that come with version 5.7, even before its predecessor reaches its end of life. <\/p>\n\n\n\n

How to Upgrade Your MySQL<\/h2>\n\n\n\n

Migrating from MySQL 5.5 to a newer version is a major upgrade that must be done with some consideration in mind. Returning to MySQL 5.5, in case anything goes wrong, is not possible, so a solid backup is essential before you can proceed with the upgrade. For better stability, we recommend a systematic upgrading approach. Here is the step-by-step procedure for upgrading your MySQL: <\/p>\n\n\n\n
\n\n\n\n

1 – Log into WHM, go to “SQL Services<\/strong>“, and click on “MySQL\/MariaDB Upgrade<\/strong>“. <\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n
\n\n\n\n

2 – Confirm <\/strong>your current MySQL<\/strong> version, select <\/strong>the new version<\/strong> you want to upgrade to, and then click “Next<\/strong>“. Upgrade one version at a time.<\/strong><\/em><\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n
\n\n\n\n

3 – On the next interface, check the boxes<\/strong> for each warning<\/strong> to acknowledge that you are aware of the potential consequences of the upgrade, then click “Continue<\/strong>“. It’s important to know that downgrading from MariaDB is not supported by cPanel & WHM<\/strong> or switching back to MySQL. It’s also not recommended to try doing so. This must be considered when upgrading from MySQL to MariaDB.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n
\n\n\n\n

4 – Choose the upgrade type you wish to use:<\/p>\n\n\n\n

Unattended Upgrade: <\/strong>(Recommended) \u2014 Automatically rebuilds Apache and PHP with the last saved defaults. It also automatically updates Ruby Gems and rebuilds Apache and PHP.
<\/p>\n\n\n\n

Partially-Interactive Upgrade:<\/strong> (On some cPanel & WHM versions only) \u2014 This option automatically updates Ruby Gems, but it does not automatically rebuild Apache and PHP, until you choose to do so.<\/p>\n\n\n\n

Interactive Upgrade:<\/strong> (Advanced users only) \u2014 This option takes you through the upgrade process step by step. The process includes the Ruby Gems update, the MySQL or MariaDB upgrade, and the Apache and PHP rebuild.<\/p>\n\n\n\n

Once you have selected the upgrade type, click “Continue<\/strong>” to start the upgrade process.
<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n