Cpanel Downgrade Mysql 4.1.x to Mysql 4.0.xx

| Posted: 31-08-2006 | Comments: 0 | Views: 263 | Rating: (56)

(?)

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:

Current: 0 / 5 stars - 0 vote(s).

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

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

Print article

Send to friend

Publish this Article

Author feedback

About the Author:

Submitting articles has become one of the most popular means of generating quality backlinks and targeted traffic to your website. Join us today - It's Free!

Article Comments

Add new Comment

Effective and Reliable E-commerce Hosting Services. How to Create E-store That Will Sell?
By: Anna Berk | 19/09/2007 | Web Hosting
Nowadays the World Wide Web represents not only the place used to store information and objective search instrument, but also plays a role of additional sales organization instrument. More and more companies places their websites in the Internet aiming to increase brand loyalty and popularize the business, get more new clients and partners. Internet regenerates and becomes one of the popular distribution channel of goods. In the 21st century, the era of technology and fast-growing markets, web site becomes instrument of vital importance for small trading company as well as for large one.

Affordable Php Mysql Hosting Is Within Your Reach
By: Anil Khatri | 13/06/2007 | Internet
Gone are the days of expensive web hosting. There was a time, just a few years ago, when hosting was not as cheap as it is now. Lets see why. Hosting is all about storage on a hard disk (which resides on the web server) and bandwidth for your data. Till...

Way's To Sky-Rocket Your Profits
By: Ed Dunham | 06/05/2006 | Business
Ten way's to increase your profits.

Ignite Your Sales Now
By: Ed Dunham | 08/05/2006 | Sales
Ten way's to increase your profits.

Anchor Down More Sales
By: Ed Dunham | 16/05/2006 | Sales
10 Boundless Ways To Anchor Down More Sales

Attract Customers To Your Web Site
By: Ed Dunham | 05/07/2006 | Online Promotion
Attract People To Your Web Site

What Is Linux Hosting?
By: WebGuru | 29/04/2007 | Internet
Linux hosting is an alternative to using Microsoft Windows-based technology for operating a website. Linux is an open-source operating system, which means the code that makes it run is publicly available. This means computer experts all over the world can share ways of improving how the system works. Although it...

How To Set Up The Backend Of Your Web Hosting Business
By: Eric Holmlund | 21/09/2005 | Web Hosting
People and "scholars" have much better definitions of this than me, but I like to think of it as the guts of the business that make things run behind the scenes. When.

Got a Question? Ask.

Ask the community a question about this article:

Frequently Asked Questions

Downloading the Linux operaitng system
By: Michaeluber | 12-11-2007
Where can I download the linux operating system from?

Linux NAS server with web UI
By: mcduck2002 | 12-11-2007
Linux light server.I want to build fast and quickly a simple linux NAS server.it should have these features:Samba with web UItorrent client with web UICUPS server with web UIHP printer/scanner server with web UIaccess with open ssl(ssh?) no X at all!secure ftp accessability to add NTFS devices as hot plug. (USB NTFS harddisk)reasonable securtiyIs there any way to build that server considering I have little knowledge in linux?

Is Ubuntu 7.10 better than Windows Vista?
By: Felipe | 21-10-2007
Is Ubuntu 7.10 better than Windows Vista?

What's New in Compiz-Fusion 0.6?
By: OrenB | 03-10-2007
I'm using the beta version of the soon-to-be-released Ubuntu 7.10 (Gutsy Gibbon). I updated my system yesterday and saw that version 0.6 of compiz-fusion was installed. I was curious to see what's new in this version but I couldn't find anything new in how it works or in the settings application. I found the release notes and now I'm even more confused: it says, for example, that transparency support for the cube plugin is new, but it's been there for months.Anyone knows what's really new in version 0.6?

For what purpose is the Linux system better than ...
By: HenryChill | 23-09-2007
For what purpose is the Linux system better than windows?

I need a good yet simple Python IDE, any ...
By: Idan Cohen | 14-08-2007
I need a good yet simple Python IDE, any recommendations? (preferably for Linux)

Q&A Powered by:

Latest Web Hosting Articles

Why Choose (asp) Application Service Providers
By: Joseph Nyamache | 07/09/2008
Did you know that if you are looking for mainframe hosting, taking a look at ASP service providers can change the way you do business!

Review of 1and1's Web Hosting Deals
By: James Betchley | 06/09/2008
Great customer service, very good graphical user interface.

Linux Web Hosting: a Comparative View of the Web Hosting Server With Others
By: Smit Mathur | 06/09/2008
As you browse through the web, does it ever occur to you that the websites might be utilizing an absolutely different kind of server than your system supports? Websites use web host services to suit their specific technical and magnitude needs.

An Introduction Into the World of Web Development
By: Ron Mark | 05/09/2008
One of the greatest things ever achieved by mankind is the development of the internet. Unlimited information, endless possibilities of entertainment, business opportunities and many other things are available to anyone around the world with just a few clicks of a button.

Four Reasons Why Windows Vps Hosting is Great for Game Developers
By: Blaise Breton | 05/09/2008
Windows VPS Hosting plans are perfect for game developers aiming to make it big. With a Windows VPS Hosting account, game developers are able to use guaranteed resources to power their applications. No longer a secret, Windows VPS Hosting has been the source of web hosting for many game developers. Price, the ease of installing programs, and included tools make Windows VPS Hosting plans the best alternative to make.

Cheap Web Hosting Packages for You
By: Anand Maheshwari | 05/09/2008
Web hosting offers you the opportunity to put your web site online, it's the only way you can do it. Websites that offer free web site hosting usually aren't really free when you consider the benefits you must give up. No matter how large or small in content your web site happens to be it has to go onto a web server.

Find the Best Web Hosting Provider Easily for Your Website
By: Adam Jan | 04/09/2008
There are many things that make up a top web hosting provider. a number of of these consist of first-class support, first-rate uptime, high-quality backup system in place, excellent hardware, offers loads of web hosting features including email features, scripting features, domain features, marketing features and more.

VPS Hosting for Webite Owners
By: Anand Maheshwari | 04/09/2008
Expanding businesses can happily settle into a virtual private server, and keep going for many years. If you're a webmaster who has grown your website or network of web sites to a point where you are attracting thousands of visitors per day you will probably need to start thinking about using a more powerful web hosting solution like an VPS.

Article Categories

Article Marketing

Article Notepad

Stop Duplicate Content

Term Papers

Follow ArticlesBase at http://twitter.com

Need Help?

Sign up for our email newsletter

Receive updates, enter your email below

Use of this web site constitutes acceptance of the Terms Of Use and Privacy Policy | User published content is licensed under a Creative Commons License.
Copyright © 2005-2008 Free Articles by ArticlesBase.com, All rights reserved. (0.55, 17)

Cpanel Downgrade Mysql 4.1.x to Mysql 4.0.xx

Article Comments

Related Articles

Got a Question? Ask.

Latest Web Hosting Articles

Need Help?

Site Links

Webmasters

Business Info

Sign up for our email newsletter