Webmaster Widget

By: 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

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.