Updating from MySQL 5.0 to 5.5?

deviantlinux

Member
Feb 26, 2008
7
0
51
Hello,

Our Cpanel box is currently on MySQL 5.0. Should I update to 5.1 first, then 5.5, or can I simply select 5.5 and update safely via WHM?

Ryan
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,904
2,218
463
Hello :)

I suggest upgrading via Web Host Manager:

"WHM >> Software >> MySQL Upgrade"

When the selected MySQL version is more that one generation newer than the currently installed version, the upgrade process will automatically iterate over each intervening version to ensure tables are upgraded appropriately.

In basic terms, you do not have to upgrade to MySQL 5.1 first because it automatically does this for you.

Thank you.
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
Prior to running the upgrade in WHM, please ensure to create a full MySQL-based backkup of the databases (as it suggested in the MySQL Upgrade wizard).

Code:
mysqldump --add-drop-table --all-databases | gzip > /home/alldatabases.sql.gz
This will create an SQL-based backup of everything in MySQL and gzip it into your /home directory. You are welcome to change the path or file name.
 

CarolLee

Registered
Mar 14, 2012
1
0
51
cPanel Access Level
Root Administrator
Prior to running the upgrade in WHM, please ensure to create a full MySQL-based backkup of the databases (as it suggested in the MySQL Upgrade wizard).

Code:
mysqldump --add-drop-table --all-databases | gzip > /home/alldatabases.sql.gz
This will create an SQL-based backup of everything in MySQL and gzip it into your /home directory. You are welcome to change the path or file name.
Hi all,

Does anyone know how to manually perform upgrade from MySQL 5.1 to 5.5 since the WHM in greengeeks currently do not support MySQL 5.5?

Thanks,
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
Only 11.32 supports MySQL 5.5 and 11.32 should be released to RELEASE tier soon. It would be better to wait for the 11.32 update to have the ability to upgrade to MySQL 5.5. There's no supported method to update to MySQL 5.5 until the server's tier has 11.32 on it, which means you would have to do it manually.

You can see the existing version for each tier at Downloads - cPanel Inc.
 

rligg

Well-Known Member
Sep 16, 2003
275
0
166
Have people experienced any significant problems with client websites going from 5.0 to 5.5? The last time I did this a while back, there were definitely some issues.
 

albatroz

Well-Known Member
Mar 6, 2003
401
6
168
Virtual Orbis / Peru
cPanel Access Level
Root Administrator
Twitter
I started a MySQL upgrade procedure from WHM web interface, but it got stuck somewhere.
Now everytime I check this option I get a screen that says the following:

WARNING: A running easyapache process was detected. Please wait for easyapache to finish before attempting to upgrade MySQL.
If you are certain that the easyapache is no longer running, you may restart the MySQL upgrade by clicking the following button.
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
Check if EasyApache is still running:

Code:
ps aux | grep easyapache
If it isn't, then run in command line:

Code:
/usr/local/cpanel/scripts/mysqlup --force
After that, run EasyApache

Code:
/usr/local/cpanel/scripts/easyapache
 

rebornishard

Member
Oct 30, 2012
12
0
1
cPanel Access Level
Root Administrator
Question:
What are the benefits of upgrading from 5.1 to 5.5?
How high is the risk of breaking something from this upgrade?
see changelog here :
https://dev.mysql.com/doc/refman/5.5/en/news-5-5-x.html

and this :
MyISAM is the default storage engine
Improved scalability on multi-core CPUs
Enhancements to XML functionality
Semisynchronous replication
Support for performance schema

and support until December 2015
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
I want to bring up this thread due to the fact that I've seen more people run into the open files limit on upgrading to MySQL 5.5

http://forums.cpanel.net/f354/upgra...rror-23-out-resources-286172.html#post1197671

This is the biggest risk I've seen on the update. Well, other than not making a backup of your databases, which you should always do. If anything goes wrong at all, you can restore from the backup if it exists.