I have ordered a new server Centos 4.3 with Cpanel WHM 10.8.0 cPanel 10.8.2-R119.
When I have transfered old server all accounts to this new server, Some sites mysql database had a few problems. I found the new server is MySQL 4.1.xx and my old server is MySQL 4.0.xx. So i decide to downgrade MYSQL 4.1.X to MySQL 4.0.xx.
cPanel Tweak Settings only have MYSQL 4.1 or MYSQL 5.0 , so I vi /var/cpanel/cpanel.config,change mysql-version=4.1 into mysql-version=4.
then, you have to do the following:
cp -fr /var/lib/mysql /var/lib/mysql.old
rm -fr /var/lib/mysql
rm -f /usr/sbin/mysqld
/scripts/mysqlup—force
when installed mysql ,I found a problem.
……………………………………………………
Attempting to restart mysql
Waiting for mysql to restart…. . . . . . . . . . . finished.
mysql status