Cpanel Gone 64 to Fast - Time to Retire Published: Dec 15, 2005
  • Rating

    5/5

MySQL 4.1 has been available for quite some time but many server admins still haven’t gotten around to getting their MySQL 4.0 upgraded to 4.1 We offer a quick and easy method to get this accomplished through your Cpanel/WHM server.

MySQL 4.1

Upgrading MySQL 4.0 to 4.1 in Cpanel

Overview:
MySQL 4.1 has been available for quite some time but many server admins still haven’t gotten around to getting their MySQL 4.0 upgraded to 4.1 We offer a quick and easy method to get this accomplished through your Cpanel/WHM server.

You’ll need about 30-45 minutes to complete this, maybe a bit longer. We have to update Cpanel, update MySQL and rebuild Apache/PHP.

Check what version of MySQL you currently have installed. It’s probably 4.0x but you can check through shell by doing the following:

# mysql -V


Upgrading MySQL 4.0 to 4.1
There are some excellent documentation and notes you should read before proceeding with this upgrade tutorial. We aren’t going to cover everything so I suggest you take a minute to read this, upgrading MySQL is a major upgrade and is irreversible!

http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-4-0.html


Installing MySQL 4.1 - the upgrade begins

The first thing we need to do is make sure Cpanel is updated to the latest version. You can do the update through WHM Upgrade to Latest Version or through shell

# /scripts/upcp

Once the update completes you want to go into WHM.

Server Configuration, Tweak Settings section

WHM MySQL

Select MySQL 4.1 option, do no check use old authentication.

Scroll to the bottom and hit Save.


You’ll then see the next screen such as this:
Your changes have been saved
If you made changes to the mysql version, please Click Here  after waiting 30 seconds  to have them take effect.
Restarting....Done

So we’ll wait 30 seconds and then click the link =)

Cpanel will then go through a bit process of grabbing the latest MySQL version 4.1.13 at the time of this tutorial and install it automatically through RPMs.
Once this page completes you need to do a few more steps to complete the update.

You should see a Complete message that’s bolded when its done.

Updating PHP to support MySQL 4.1
Now you need to recompile Apache/PHP to support the changes as quick as possible because PHP will currently not work with MySQL. You might see something like this in console:

# php -v
php: error while loading shared libraries: libmysqlclient.so.12: cannot open shared object file: No such file or directory

This is normal and fine, lets proceed with the Apache update. See our detailed /scripts/easyapache tutorial here.

# /scripts/easyapache

Don’t change any of the default MySQL options here, select the other settings you want. Save the changes and let it rebuild. This usually takes 20 minutes or so to complete:

 

Now that Apache has finished recompiling we want to make sure it works properly! In shell again do the following command. It should produce your PHP version information without any errors:

# php –v
PHP 4.4.1 (cli) (built: Dec  8 2005 20:57:56)
Copyright (c) 1997-2004 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2004 Zend Technologies

You can also check the MySQL version with the following:

# mysql –V
mysql  Ver 14.7 Distrib 4.1.13, for pc-linux-gnu (i686) using readline 4.3

Upgrade is complete! Give yourself a pat on the back for some hard work and take a deep breath because you got through this haha =)

MySQL 4.1 upgrade Problems?

Make sure you follow all the steps, especially rebuilding Apache/PHP if you don’t the libraries will be out of sync and no websites will be able to connect to databases.

Notes:
The 4.0 to 4.1 MySQL upgrade changes many aspects of databases. For example, when you’re trying to restore a 4.0 database to a 4.1 database it will not work. The opposite is also true. This is because it ads new fields, etc to tables that each version doesn’t support. So if you have many machines, upgrade them all or none because if you’re moving databases around you’re going to hit a brick wall.

Having trouble getting this tutorial to work? We can do this update for you on your server, simply contact us for a quote.

About the Author:
Steven Leggett is the editor of the server resource and hosting tutorial site, www.webhostgear.com and specializes in system administration and web development.

  • Rating

    5/5

Related Articles

Comments (5)

  • Gravatar - N32
    N32 11:00, December 26, 2005
    I agree with rampage here. We've run into problems with cpanel 64 with CentOS 4.2 - I do not know of the stability of the rest of the releases, but that is the one we got. We ended up paying for a server reformat. So before ordering - make sure to consider the extra cost this might be. <br />
    <br />
    Biggest beneficieries of this 64bit system is mySQL. However, you will find that performance is only about 1 -5 % better than the 32bit version. In 99% of the cases, this translates into almost no change. Sometimes 64bit applications are actually slower in running. So consider this too when you order.<br />
    <br />
    If someone is looking for a 64bit option, get Directadmin for 64bit OS - it's marked as alpha. It will install itself and we've worked with it on production servers, and compiled it many times without issues. If worse come to worse, there are guides on how to uninstall it too. <br />
    <br />
  • Gravatar - Cory
    Cory 15:11, February 1, 2006
    That's not all true,<br />
    <br />
    I got 3 servers on Fedora Core 4 - running AMD Athlon 64+, and everything works great, even compiling, but their's 1 thing that I came across that's not supported "apf" rfxnetworks firewall.<br />
    <br />
    You install, reboot server it don't load and the datacenter tells "Theirs a problem with iptables" like blah, Removed apf - rebooted works fine.
  • Gravatar - Ryan
    Ryan 21:23, February 14, 2006
    Cory just because your running a AMD Athlon 64+ doesn't mean your running Fedora Core 4 64bit edition. Unless you are, your actually not using the 64bit part of your chip which means everything is running fine :-P
  • Gravatar - Marcel
    Marcel 00:07, March 9, 2006
    We have found many problems with DirectAdmin and Centos 4.2 64-bit.<br />
    <br />
    the biggest problem is that the frontpage extensions dit not work.<br />
    <br />
    we will reinstall all server with the 32bit version.<br />
    <br />
  • Gravatar - nhat truong
    nhat truong 06:48, August 17, 2009
    I got 3 servers on Fedora Core 4 - running AMD Athlon 64+, and everything works great, even compiling, but their's 1 thing that I came across that's not supported "apf" rfxnetworks firewall.<br />
    <br />
    OK. You install, reboot server it don't load and the datacenter tells "Theirs a problem with iptables" like blah, Removed apf - rebooted works fine<br />
    ----------------------------------------<br />
    <a href="http://ungvien.com.vn/employer/main.html">tuyen dung</a> | <a href = http://ungvien.com.vn>viec lam</a> | <a href=http://ungvien.com.vn>tim viec </a>

Add Your Thoughts

WebHostGear.com is a hosting directory, not a web host.

Copyright © 1998-2017 WebHostGear.com