How to upgrade mysql version through cpanel ?
For expample upgrade mysql 4.0 to 4.1
To upgrade the mysql server from 4.0 to 4.1, we need to follow the following procedure.
First take complete backup of the current databases that are there in the /var/lib/mysql using the “cp -varf” command.
cp -aprf /var/lib/mysql /var/lib/mysql.backup
Also take backup of the /var/lib/mysql/mysql database into the sql file using the command mysqldump and keep it safely as it is required to revert back from 4.1 to 4.0 incase.
mysqldump mysql > mysql.sql
Next open the WHM and go to MySQL section under the Tweak Settings page. Click on the 4.1 option and also make sure to select the check box “Use old style (4.0) passwords with mySQL 4.1″ and then scroll down and click on the save box.
With the above steps we are ready to upgrade from 4.0 to 4.1.
Next open the shell and then run the command
/scripts/mysqlup –force
and wait for it to finish. Once it is finished, run easyapache and make sure to take backup of httpd.conf and php.ini files before running easyapache.
You should not get any problem regarding the databses. If you see any high load being generated and php is taking more resources it should the php.ini file issue but not the mysql upgrade issue.