Friday, June 18, 2010

Downgrade MySQL from MySQL 5

Here we are discussing how to downgrade mysql version 5 to version 4.1
First we can take a full back of our existing MySQL database

1. ]$ mysqldump --compatible=mysql40 --all-databases > databases.sql

]$ rpm -qa | grep -i mysql-
2. Then remove /var/lib/mysql:]$ rm -Rfv /var/lib/mysql
3. Then edit /var/cpanel/cpanel.config and set as -> mysql-version=4.1
4. Make sure that the skip file isn't there:
rm -fv /etc/mysqlupdisable
5. Then install MySQL ----> /scripts/mysqlup --force
6. Then update the perl module --> /scripts/perlinstaller --force Bundle::DBD::mysql
7. Then recompile apache/php --> /scripts/easyapche
8. /scripts/upcp --force

Last restore the old MySQL database
]# mysql database < databases.sql

No comments:

Post a Comment