The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Updating from MySQL 5.0 to 5.5?

Discussion in 'Database Discussions' started by deviantlinux, Mar 6, 2012.

  1. deviantlinux

    deviantlinux Member

    Joined:
    Feb 26, 2008
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    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
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  3. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    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.
     
  4. CarolLee

    CarolLee Registered

    Joined:
    Mar 14, 2012
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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,
     
  5. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    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.
     
  6. rligg

    rligg Well-Known Member

    Joined:
    Sep 16, 2003
    Messages:
    277
    Likes Received:
    0
    Trophy Points:
    16
    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.
     
  7. fetchdesigns

    fetchdesigns Registered

    Joined:
    May 24, 2012
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    I am also curious about this. We currently have 5.0.45 and would like to upgrade to the current version. Any major known issues?
     
  8. albatroz

    albatroz Well-Known Member

    Joined:
    Mar 6, 2003
    Messages:
    258
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Virtual Orbis / Peru
    cPanel Access Level:
    Root Administrator
    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.
     
  9. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    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
     
  10. luigidelgado

    luigidelgado Well-Known Member

    Joined:
    Nov 6, 2010
    Messages:
    109
    Likes Received:
    2
    Trophy Points:
    16
    Location:
    Mexico
    cPanel Access Level:
    Root Administrator
    Twitter:
    Question:
    What are the benefits of upgrading from 5.1 to 5.5?
    How high is the risk of breaking something from this upgrade?
     
  11. rebornishard

    rebornishard Member

    Joined:
    Oct 30, 2012
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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
     
  12. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    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.
     
  13. savanna96

    savanna96 Member

    Joined:
    Feb 13, 2013
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    If you haven't already I don't recommend it I have so many issues with it
     
Loading...

Share This Page