How to upgrade MySQL 5.0 to MySQL 5.1 in a cPanel server

Published on: April 15, 2009 by Faheem P.

How to upgrade MySQL 5.0 to MySQL 5.1 in a cPanel server

Scenario:

Our database management service team got a similar request two years back when we had to upgrade MySQL version 4.0 to MySQL 5.0. We are listing here the same approach for the current needs of upgrading MySQL 5.0 to 5.1

File responsible for the MySQL version is /var/cpanel/cpanel.config

Open it, find the variable mysql-version and edit the value to read mysql-version=5.1

And finally run

/scripts/mysqlup

This should upgrade your MySQL version to MySQL 5.1. For better understanding of the process behind, /scripts/mysqlup, go through the code and browse the URL http://httpupdate.cpanel.net/mysqlinstall/

NB : Chances are that, upgrading MySQL may break the php and in such cases, do recompile php, using easyapache or your custom compilation methods.

Category : cPanel, Howtos, Linux, MySQL

Faheem P.

Faheem enjoys learning new technologies and loves to implement cutting edge solutions. He is one of the most active member in various technical forums and is a familiar face in various brain storming sessions. He takes great pride in being an explorer and the best thing you can be sure about in his room is the backpack!!

Blog