Cpanel Downgrade Mysql 4.1.x to Mysql 4.0.xx

<h1>Cpanel Downgrade Mysql 4.1.x to Mysql 4.0.xx</h1>Author: <a title="Webhosting-live.com" href="http://www.articlesbase.com/authors/webhosting-live.com/8584.htm">Webhosting-live.com</a> 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
<a href="http://www.Webhosting-live.com">Webhosting-live.com</a> 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.
 About the Author:

Article Source: <a href="http://www.articlesbase.com/">ArticlesBase.com</a> - <a href="http://www.articlesbase.com/web-hosting-articles/cpanel-downgrade-mysql-41x-to-mysql-40xx-52192.html" title="Cpanel Downgrade Mysql 4.1.x to Mysql 4.0.xx">Cpanel Downgrade Mysql 4.1.x to Mysql 4.0.xx</a>

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.

Rate this Article:

0 / 5 stars - 0 vote(s)

Re-Publish

Article Source: http://www.articlesbase.com/web-hosting-articles/cpanel-downgrade-mysql-41x-to-mysql-40xx-52192.html

Article Tags: Mysql, Linux, Cpanel, Whm, Centos

Related Videos
Related Articles
Ask / Related Q&A

Play

How to use Image Manager - Converter in cPanel

Play

How to create a POP mail account in cPanel

Play

How to upgrade an account in WHM

Play

How to monitor your server in WHM

Play

How to create a MySql database

Latest Web Hosting Articles
More from Webhosting-live.com

How does web hosting work?

By: Matt Kline | 06/01/2010
In order to put your website on the internet, it needs to be put on a web server. A web server can be very costly to own and requires maintenance and certain knowledge and skills to keep running smoothly. This is the reason why choosing to have your website hosted by another company is the smart way to get your website on the internet.

Water Saving Toilet Technology

By: Guillermo Nielsen | 06/01/2010
There are lots of options on saving water like a Water Saving Toilet. It's a twin flush toilet with grey water recycling. Using Twin Flush Toilets with Gray Water Recycling Kits are going to be sold to recycle the grey water from kitchen sinks, rest room sinks and washing machines. Grey water is water that's exploited in the home, but not in the disposal system,eg the can systems, of the home. Grey water is picked up in tanks and reused for f...

Leaky Flapper - The Best Solution

By: Adolfo Booker | 06/01/2010
I assume the most vital query would be "How To Save Water From Leaky Flapper". A twin flush toilet with gray water recycling might be employed together. Using Twin Flush Toilets with Gray Water Recycling Kits are going to be sold to reuse the grey water from kitchen sinks, rest room sinks and washing machines. Gray water is water that's utilized in the home, but not in the disposal system,eg the john systems, of the home. Gray water is picked...

Leaky Flapper - The Best Solution

Leather Lingerie Reveal Your Erotic Side

By: April Chudej | 06/01/2010
You don't have to be wearing bondage leather lingerie from a extraordinary appealing lingerie clothe in request to put a slightly bang in your act either.

The Importance of Using Hosting Coupons

By: Andrey Fidrya | 06/01/2010
Searching for a hosting package people usually pay special attention to the product price. It should be pointed out that cheap web hosting companies don’t always provide their customers with high quality of service. To avoid various problems and downtimes in the future it is better to deal with reliable providers only.

Best free hosting sites - which blog host

By: Rafael Ramirez | 06/01/2010
which blog host Web Hosting by Emerald is devoted to providing essential information on the best website hosting services they provide. Our main purpose has always been to help our readers to find low cost web hosting plans. Shared SSL should almost never be used, if you value the security of your server and that of your online customers. Web hosting is the service that allows your website to be viewed on the World Wide Web. This is the ...

Free cPanel Hosting

By: John Triggerman | 05/01/2010
cPanel hosting is a great and easy way to control all the aspects of your website via an easy to use interface. cPanel is without a doubt the most advanced hosting platform in the industry. It is an award-winning control panel with an extensive range of powerful features that allow you to manage your web hosting with ease.