cPanel upgrade MySQL 5.1 to 5.5

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.

cPanel upgrade MySQL 5.1 to 5.5

cPanel upgrade MySQL 5.1 to 5.5 - Upgrade MySQL 5.1 to MySQL 5.5 through cPanel wizard and configure the server after update

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.

Here is the video tutorial of: "How to upgrade MySQL through 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.

cPanel upgrade MySQL 5.1 to 5.5

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:

cPanel upgrade MySQL 5.1 to 5.5

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

cPanel upgrade MySQL 5.1 to 5.5

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

cPanel upgrade MySQL 5.1 to 5.5

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

cPanel upgrade MySQL 5.1 to 5.5

and click on the "Next" button.

e) Installer show the following warning screen:

cPanel upgrade MySQL 5.1 to 5.5

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

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

cPanel upgrade MySQL 5.1 to 5.5

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

cPanel upgrade MySQL 5.1 to 5.5

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

cPanel upgrade MySQL 5.1 to 5.5

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

Step 3: Copy my.cnf and restart MySQL

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

service mysql restart 1

If everything is fine mysql will start with this command.

But in some cases it will may give following errors:

MySQL server PID file could not be found! [FAILED] 2

or

service mysql restart
MySQL server PID file could not be found! [FAILED]
Starting MySQL.The server quit without updating PID file (/
var/lib/mysql/xxxxxx.pid).

If such error comes it means there is issue with the my.cnf file. 3

You should locate the new configuration file using following command:

locate *.cnf

You will get the following output: 4

/usr/share/mysql/my-huge.cnf
/usr/share/mysql/my-innodb-heavy-4G.cnf
/usr/share/mysql/my-large.cnf
/usr/share/mysql/my-medium.cnf
/usr/share/mysql/my-small.cnf

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 5

After this restart the server using following command:

service mysql restart

The MySQL server should start. 6

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 7

Now you should verify the application.

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

Check more MySQL tutorials at our MySQL tutorials home page. 8