23 Nov

Upgrading MySQL from 5.1 to 5.5 in a cPanel server

MySQL is an open source RDBMS (Relational Database Management System) and its using the SQL Language(Structured Query Language). A database is a structured collection of data. SQL is the most commonly using language for database operations. By using SQL the database operations like adding, accessing and managing the database is very simple.

The MySQL upgrading steps is quite difficult normally. Like all software, the first steps for MySQL upgrade is taking the backup. Yes! it’s a very important step. In a cPanel installed server you can upgrade the MySQL verion from the command line itself by using the script “/scripts/check_cpanel_rpms”.

Here is short look for upgrading your MySql from 5.1 to 5.5 in a cPanel server.

1. Take the backup of all the databases on the server.

2. Replace the MySQL version from 5.1 with 5.5 in /var/cpanel/cpanel.config file

#vi /var/cpanel/cpanel.config
and then, change 
-------
"mysql-version=5.1" to "mysql-version=5.5".
-------

3. Then, run

#/scripts/check_cpanel_rpms --fix
 4. After executing this command, try

#mysql -V

MySQL will be upgraded to 5.5. Then try, php -v. You will get the following error:

-------------------
root@server [~]# php -v
php: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory
--------------------

Do an easyapache to fix this.

#/scripts/easyapache

Done!

Share this

Leave a reply