Aug 102017
 

How To Upgrade MySQL in cPanel post provides instructions on how to upgrade your Apache mySQL database in cPanel via WHM.

To upgrade MySQL, you will need to login to WHM. This tutorial will show step by step what options to select and the final results.

Note: It is important to always create a backup of your databases. You can also create a backup of your server if you want. Nowadays server backups are done on a daily basis.

How To Upgrade MySQL in cPanel

Step 1 ) Login to your WHM Panel.

Step 2 ) Go to WHM -> Software -> MySQL/MariaDB Upgrade to begin upgrading MySQL.

apache-mysql-upgrade1

7 Steps To Upgrade MySQL

Step 3 ) The following image displays the version MySQL 5.6 (Stable) chosen for this tutorial. Click the Next button once you have select your option.

apache-mysql-upgrade2

Step 4 ) The following page with present you with a list of “Upgrade Warnings”. Select the check box for each warning after reading and understanding it. Click on the Continue button when you are ready for the next step.

Note: You will almost always see an advisory suggesting to perform a full MySQL database backup. This is highly recommended.

apache-mysql-upgrade3

Step 6 ) The third step allows you to choose from one of the following options. Read each option carefully and choose the correct one for your upgrade.

Upgrade Type

  • Unattended Upgrade (This option was chosen for this tutorial)
  • Partially-Interactive Upgrade
  • Interactive Upgrade. The latter two options should only be chosen if you have special configurations in place.
  • Click on Continue button when you are ready to proceed.

apache-mysql-upgrade4

Step 7 ) The following image displays the progress bar letting you know that MySQL is being upgraded.

apache-mysql-upgrade5

Step 8 ) The following image display the upgrade process completed without any errors or warnings. This is what you want to see when you upgrade your version. Click on Back button to go back to the beginning.

apache-mysql-upgrade6

Step 9 ) Once the process is completed and you return to the beginning you should see your upgraded version. In this example MySQL was upgraded from version 5.5 to version 5.6.35.

Note: If you are upgrading from a version earlier than MySQL 5.5, I recommend that you consult your host before going ahead.

apache-mysql-upgrade7

If everything went well then your MySQL is updated. If your run into issues then you will have to contact your host or WHM forums.

I hope the above helps you.

If you have any questions please let me know.

Enjoy

Manuel Ballesta Ruiz is a web developer, Blogger and WordPress Enthusiast.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)

The following GDPR rules must be read and accepted:
This form collects your name, email and content so that we can keep track of the comments placed on the website. For more info check our privacy policy where you will get more info on where, how and why we store your data.