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
Related Posts
shell script to delete /tmp files linux leaving eacclarator folder
script to notify high server load | linux script for monitoring server
shell script to find linux memory process usage
MySQL root password reset linux
echo 0 proc sys kernel hung_task_timeout_secs disables this message
the ip address of a physical server cannot be used with its parallels power panel port number
??????????????N??
???????????????????????N?? ??????????????????
????????????N???? ?????????,????!
????????????? ??????????????.
?????????(N??)???????
?????????????????????????????????
??????????????????????
??????????????????????????????????????????????????????????????
?????????????????????,??????????????????,????????????,IWC?????,
?????????????,??????????,??&???????,????????,??????????,????????,
??????????????,??????????????????,???????????,???????????????????
???????????????????????????????
?? ???????????(????
???????????????? (*^-^*)
??????????????24???????????
??????????????????????????????????????
?????????????
??????????????????????????????????????
?????????????
???????????????????????????????????????
??????????????
????????????????????????????????????????????????
?????? ????????? N? ??????
???? ??????????????????
?????????????N????????? ?
?????-????!-????.??????
??????? ???????????????
?????????
????????????????????????????????????????
??????????????????????????????
????????????????????
?????????????, ???????????
?N??????????????????
?????????????????????????
??????????????(????
???????????????? (*^-^*)
??????????????24???????????
???????????N?????
?????????????????-?? ???,100%???
??????????????3?????????5 ??????????
????????????????!???????????
???????????? ????????( ????)?????????2????????
?????????:
?????????????????
????????????????????|??????????|???????????????|??????????????????????|???????????????|??????????????????|(D?G)??????????????
???D&G ???????????D&G??????????????????? ?
D&G????D&G????
D&G??????D&G????D&G????? ?????
2019????????????(N??)???!
?????????????????????????????
?????????????????????
?????????????? ??????
?? ???????????
?????????!
????? ????? ???? ?????
100%???? 100????? ????
?????????????????????????????????????
??????????????
???? 365???????
???????????1? ?????
????????????????????????????????
???????????????????????????????
??????????????????
?????????????? ??????
?? ???????????
?????????!
????? ????? ???? ?????
100%???? 100????? ????
??????????????????????????????????????????
??????????????
??????,?????????????
????????????????!??(??)
???? ?????????N??1?
?????????????24???????????
???????????????????????????????????????????????????????????????
?????!!????????????????????????????????????????????M30392?
???????????????????????????????????????????????????????????????????????????