MySQL version downgrade in linux cPanel servers

SOP for MySQL version downgrade from 5.1 to 4.0 in cPanel servers
================================================
Pre-installation steps
==============

Before you downgrade the MySQL version you need to do the following steps so as to avoid data loss or file corruption

Check the MySQL version by using the following command

#rpm -qa |grep MySQL

O/P
MySQL-server-5.0.91-0.glibc23
MySQL-client-5.0.91-0.glibc23
MySQL-devel-5.0.91-0.glibc23
MySQL-shared-5.0.91-0.glibc23
MySQL-bench-5.0.91-0.glibc23

check the server OS as below

# cat /etc/issue
or
# cat /etc/redhat-release

O/P
CentOS release 5.5 (Final)

Server architecture check

# arch

O/P
x86_64

Before downgrading we need to backup MySQL databases so as to avoid data corruption so we are copying the mysql database folder by using the following command

#cp -arp /var/lib/mysql /var/lib/mysql.bak

then dump the mysql databases using the following command

#mysqldump -u root -p(password) –all-databases > dumpfilename.sql

You can also take version compatible downgrade dump to check for any missing file restoring by using the following command

#mysqldump -u root -p(password) –all-databases –compatible=mysql40 > versioncompatibledumpfilename.sql

Actual MySQL down-gradation
===================

Then now we can start the down-gradation process

First you need to open the cpanel.conf file and make changes to the MySQL-version line from 5.1 to 4.0 by following the using the command

#vi /var/cpanel/cpanel.config

After changing the MySQL version line from 5.1 to 4.0 in the configuration file we need to run the following command to force the MySQL up-gradation/Down-gradation.

#/scripts/mysqlup –force

Now the MySQL version down-gradation will take place, once the process is completed you can check the version of MySQL which will be

# rpm -qa | grep -i mysql-
O/P

MySQL-shared-4.0.27-0
MySQL-devel-4.0.27-0
MySQL-bench-4.0.27-0
MySQL-client-4.0.27-0
MySQL-embedded-4.0.27-0
MySQL-server-4.0.27-0

Restart MySQL services by using the following command
#/etc/init.d/mysql restart

That’s all the MySQL version has been downgraded successfully.

Thank you for viewing helpinlinux.com

Leave a Reply

Protected by WP Anti Spam