Home » Articles » Cpanel Downgrade MYSQL 4.1.X to MySQL 4.0.xx

Cpanel Downgrade MYSQL 4.1.X to MySQL 4.0.xx

by Wang Junzhao

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

/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").

..........................................................

when I was checking mysql logs, I found the problem was /etc/my.cnf. which needed to edit /etc/my.cnf with the edition of mysql 4.0.xx, such as

...................................................................................

[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

skip-locking

skip-bdb

skip-innodb

back_log = 200

query_cache_limit=1M

query_cache_type=1

query_cache_size = 16M

interactive_timeout=10

connect_timeout=2

max_connections=500

wait_timeout=10

long_query_time=5

thread_cache = 8

thread_concurrency = 4

key_buffer = 16M

max_allowed_packet = 1M

table_cache = 64

sort_buffer_size = 1M

net_buffer_length = 8K

myisam_sort_buffer_size = 64M

[mysql.server]

user=mysql

basedir=/var/lib

[safe_mysqld]

err-log=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

......................................................................................................

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

If you install mysql finished, Cpanel downgrade MYSQL 4.1.X to MySQL 4.0.xx .

Friday, Sep 1st, 2006