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. Please refer How to create MySQL dump/backup of all the databases
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
4. After executing this command, try
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.