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!
MySQL :: MySQL 3.23, 4.0, 4.1 Reference Manual :: 2.11.1 Upgrading from MySQL 4.0 to 4.1
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
http://www.webhostgear.com/images/ar.../whm_mysql.gif
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..
