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

A similar request came to us 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/

SupportSages rocks!!

Related posts:

  1. Internal server errors while accessing Fantastico and phpmyadmin in cPanel & WHM
  2. Howto move horde specific settings especially calendar, address box, notepad settings etc when moved from one cPanel server to another
  3. Applying wildcards in GRANT option of MySQL
  4. Howto enable access to whm, cpanel subdomains (proxy subdomains) in cPanel
  5. Resize /tmp loopback partition on a cPanel server which doesn’t have a separate /tmp in the partitioning scheme

2 Comments

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.

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

Comment Form

About this blog

This blog, acts as a knowledge repository for the world and is unofficial! Anything we find interesting in the cyber world will go here. Most cases, this blog will reflect the happiness of our staff in reaching successful solution to an issue (s)he worked on. A reference for other fellow SAGEs who come across similar issues later