web analytics

Blog

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

Tags: cPanelMySQLmysql version 5.1

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 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!!

You may also read:

Comments

Add new commentSIGN IN

  • G

    Internal Server Error

    Premature end of script headers: php: Please check / usr / local / cpanel / logs / error_log for the exact error.

    Still trying to figure out what goes wrong to cause this.

  • admin

    Did you check that log file ? You can do a /scripts/makecpphp and see whether it fixes that error. Or if you are on a VPS, make sure that you have enough memory

  • You would need to run easyapache after you upgrade mysql using the above method, else you will end up with internal server errors. Please make sure you update this on the post.

  • Pingback: Cpanel Upgrade Mysql 5.0 To 5.1 – System Toy()

Let's Connect

Get new updates

Categories

$0.000 items