Cpanel downgrade MYSQL 4.1.X to MySQL 4.0.xx

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.

Digg del.icio.us Blink Stumble Spurl Reddit Netscape Furl

Article keywords: cpanel, linux, mysql

Article Source: http://www.articles2k.com

Top Web Hosting Articles
1). Four Critical Factors to Business Web Hosting Success By : David Dunlap There are a number of business web hosting services over the internet. It is important when choosing a business web hosting service that you find one that caters to your specific business needs.
2). Factors by choosing the right web hosting company By : Bedrich Omacka There are many important factors by choosing web hosting company. Let's take a look at some of them. First time you must answer the question which type of web hosting are you looking for. If you want to run a single web site shared hosting will be the right for your needs. For those who own multiple domains it will be better to buy reseller account or look around the web hosting industry and find some hosting plan which allows more domains under single account.
3). Ecommerce Business Website Hosting By : Fame Ahmed The initiation of the Internet and the start of E-Commerce business website hosting and solutions, has changed the way people do business a great deal. Business website hosting has brought a greater sales field with no boundaries and worldwide access to many businesses.
4). Choosing A Web Hosting Company By : Rick Hendershot It used to be that choosing a web hosting company for your small business web site was a difficult and confusing exercise. Thankfully, those days are long gone. Today you can do an online search for web hosting companies and be presented with a fantastic selection of cheap hosting packages, all of them offering a wide range of features. Choosing among all the alternatives still takes a bit of research.
5). Choosing The Best Web Hosting Service By : Fame Ahmed Before choosing the best web hosting service, we should understand what web hosting means.
6). Finding The Best Host For Your Company’s Needs By : Andy MacDonald So your business has decided that it is time to make its presence felt on the internet. You have your all your information ready, and you may even have created your website which it is ready to go live on the internet. The next step is to find a web hosting provider, but how do you evaluate web hosting, and then make a choice on which provider to pay your hard earned money too? Choosing the correct host for your company’s needs is a very important step, if not the most important step when taking your business online.
7). 3 Differences between Shared and Dedicated Hosting By : John C. Purfield When it comes to making the all-important choice of what web hosting method to use the choices come down to shared hosting and dedicated hosting. There are so many arguments arguing for both shared hosting and dedicated hosting. Perhaps it is time to shed a little light on this web hosting dilemma. First of all, let's deal with the all-important question of server access.
8). Virtual vs. Dedicated vs. CoLo: Which Web Hosting Do I Need? By : John Hasson You know you need a web host, but you don’t know where to start. So you do a web search to research potential solutions and get a bit overwhelmed with all the jargon: UNIX, dedicated servers, POP3, CoLo... the list goes on. Step back a bit. You don’t need to learn everything about web sites to choose a host. You do however need to know what a web host is, and the basic types of web hosting.
9). Web Hosting - The Internet Marketing Tool By : Bjorn Hakans An important part of doing any kind marketing today is definitely an effective Internet marketing strategy, and for that the first thing you need is reliable web hosting. I know some people say that you can market this and that without having your own website, but I definitely disagree. Many affiliate programs and various business opportunities offer you "personalized web sites" that you can use without owning you own server space.
10). Discovering The Personal And Professional Benefits Of Myspace By : Madison Lockwood If you have been thinking of creating a website for your company, then you are already aware of the amazing benefits of having a corporate presence online. Tapping into the internet community is a proven way to increase your company's visibility, improve sales, attract new clients, and more. But have you ever wondered: if a website can do wonders for my profession, can it work magic in my personal life, too? Most importantly, is there a service that can benefit me both personally and professionally? Chances are you have heard of MySpace.

New Web Hosting Articles
1). Reasons to Go For India Reseller Web Hosting By : Trevor Mulholland What exactly makes India reseller web hosting more attractive?
2). Why Get UK Reseller Web Hosting By : Trevor Mulholland Here are just a few of the many good reasons why you should consider UK reseller web hosting, above hosting offered in other countries.
3). Multiple Domain Name Penalty By : Ben Kemp If you own a web site AND you have multiple domain names registered, you might want to read this with your full attention.
4). UK Reseller Web Hosting: Trust Matters By : Trevor Mulholland There is one thing that makes a UK reseller web hosting outfit ideal for UK-based customers, and that is trust.
5). UK Reseller Web Hosting: Friendly Services at Friendly Rates By : Trevor Mulholland If you wish to address a UK clientele, it would be beneficial to be a UK reseller web hosting outfit, yourself.
6). Unmetered Web Hosting By : Natalie Wilkins The World Wide Web is perhaps one of the most dynamic business environments today. In such an environment, you can never be 100% certain as to what your requirements are when it comes to your websites web-hosting needs.
7). How To Decide On A Domain Name For Your Website And Register With Your Web Host By : Gregg Hall One of the first and most important parts of developing a web site is to do a bit of research on the subject. By researching you will be better informed and prepared when you are ready to get a web host.
8). Web site monitoring. Can you afford downtime? By : Andy Allen Supposing that you’ve gone that long way through from choosing the right hosting provider to final files uploading to your brand new server you proceed with setting up million other things like permissions, nameservers, email and ftp accounts but some people forget about just one thing which is also one of the most important things after they launched their websites or online business.
9). BlueHost and Fantastico By : Sage Kalmus BlueHost and Fantastico go so well together that they lend themselves to all sorts of timeless comparisons: Burns and Allen, Astaire and Rogers, Peanut Butter and Jelly or, more relevantly, MySQL and PHP. BlueHost is the web host, Fantastico is the feature; together, they can help you make your website do all sorts of incredible things. Fantastico (full name: Fantastico DeLuxe) is the leading auto-installer for servers using the cPanel control panel.
10). Arizona Web Hosting Company By : Rory Wood There are so many companies out there that offer hosting that finding an Arizona web hosting company may be difficult to find. Some claim to be an Arizona web hosting company but may actually be located in Europe or Canada. It may be hard to find out which Arizona web hosting company out there really is from Arizona. While you can certainly choose to work with any web hosting company around the globe, some people choose to work with a company closer to home.