Webhosting-live.com

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
????: NamePros.com http://www.namepros.com/web-hosting-discussion/233286-cpanel-downgrade-mysql-4-1-x.html
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 .

If you find some bug ,please connect with me, EMAIL:webmaster@webhosting-live.com

Webhosting-live.com is a Web Hosting Directory.The free source of web hosting,Unix Hosting,Windows Hosting,Dedicated Hosting,Ecommerce Hosting,Virtual Private Servers,Domain Registration in a searchable web host directory.

Barrucadu

Why would you want to downgrade anyway? The vast majority of scripts work - the only script i've had issues with was an SMF forum - and that took about 5 mins to fix.

__________________
Website | Blog

Arch Hurd developer; GNU Webmaster; FSF member #8385

Virgil

I remember a similar thread at cpanel's forums; it had a step by step procedure to downgrade your MySQL, if memory serves right. On the other hand, I agree with Mikor. I'd rather fix the faulty scripts or, if they're your client's, explain to them that they must get them fixed.

BeZazz

i have found ticking
" Use old style (4.0) passwords with mySQL 4.1+ (required if you have problems with php apps authenticating)"
helps with most problems when going from 4 to 4.1