cPanel upgrade MySQL 5.1 to 5.5

Advertisement

In this tutorial I will explain you how you can upgrade MySQL 5.1 to 5.5 through cPanel. If you can using the cPanel and not updated your MySQL 5.1 to latest version of MySQL you will find the error message "The last attempt to update to cPanel & WHM was blocked". After updating to MySQL 5.5 or above the error message will go away.

Learn how to update MySQL 5.1 to latest version MySQL Server (e.g. MySQL
5.5.23) through cPanel and make changes to the my.cnf file. In this tutorial I
will provide you step by step tutorial for upgrading the MySQL 5.1 to 5.5.

The latest build of cPanel now supports MySQL 5.5 and use can use the cPanel
wizard to upgrade your MySQL server 5.1 to 5.5. The MySQL 5.5 provides many
features such as better performance, support for multi-core CPUs, fast service
and so on. This feature of cPanel will benefits the end users as the MySQL
server will be updated by the cPanel.

Make sure that you should back up your database before proceeding with the
process. As data is very important and you should take the complete backup of
your data using mysqldump tool. There is no option of downgrading the MySQL 5.5
to lower version of MySQL. So, you should take backup for for
proceeding.

Step 1: Backup your MySQL data using mysqldump

The mysqldump tool is very handy tool for taking the backup of database. Here
is the command for taking the full backup of database:

mysqldump --all-databases > all_databases.sql

Step 2: Upgrade MySQL 5.1 to 5.5 through cPanel

Here are steps to upgrade MySQL Server 5.1 to MySQL Server 5.5 through cPanel
as root.

a) Login to cPanel as root. You will find the following
link:

b) Click on the "Details" Link, It will show a popup as shown below:

c) To start the upgrade process click on the "MySQL Upgrade" link. Installer
will show the following screen:

d) Scroll down and select the MySQL version 5.5 as shown below:

and click on the "Next" button.

e) Installer show the following warning screen:

Check all the checkboxes and click on the "Continue" button.

f) Opt for the "Unattended upgrade" and click "Continue" button as shown
below:

g) Installer will start the upgrade process as shown below:

h) After completion installer will show the success message as shown below:

After the upgrade we will login to server as root and then restart the MySQL
Sever.

Step 3: Copy my.cnf and restart MySQL

Login to your MySQL server box and try to restart MySQL using following
command:

Now use the following command to create my.cnf file from any of the above
file. In my case I am using my-small.cnf file. Use the following command to copy
the file:

cp /usr/share/mysql/my-small.cnf /etc/my.cnf

After this restart the server using following command:

service mysql restart

The MySQL server should start.

Step 4: Restore the data if there is some issue with your data

If you there is no error encountered during the process the cPanel upgrade
process should modify the database make it compatible with MySQL 5.5 version. If
some error is encountered and you don't have the data then you should restore
from backup mysqldump tool.

Step 5: Verify the applications

Now you should verify the application.

In this tutorial you have learned how to upgrade MySQL 5.1 to 5.5 using MySQL
installer.