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.

Upgrading Mysql from 5.5 to 5.6

Discussion in 'Database Discussions' started by AdamDresch, Mar 5, 2014.

  1. AdamDresch

    AdamDresch Well-Known Member

    Joined:
    Jun 22, 2006
    Messages:
    80
    Likes Received:
    0
    Trophy Points:
    6
    Has anyone successfully upgraded from 5.5 to 5.6?

    When I try to run the upgrade, it says:

    The next step says:

    I go through the easyapache process, but afterwards, it says

    Any ideas? heh
     
    #1 AdamDresch, Mar 5, 2014
    Last edited: Mar 5, 2014
  2. vanessa

    vanessa Well-Known Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    817
    Likes Received:
    22
    Trophy Points:
    18
    Location:
    Virginia Beach, VA
    cPanel Access Level:
    DataCenter Provider
    Try running this manually and see what happens:

    /usr/local/cpanel/scripts/check_cpanel_rpms --fix
     
  3. AdamDresch

    AdamDresch Well-Known Member

    Joined:
    Jun 22, 2006
    Messages:
    80
    Likes Received:
    0
    Trophy Points:
    6
    Thanks Vanessa, yes that's the first thing I Tried :( Sadly it had no effect heh.
    It just sits there for about 10 seconds, then goes back to the ssh prompt
    Re running mysql upgrade comes up with the same messages again.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Feel free to open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
  5. morissette

    morissette Well-Known Member

    Joined:
    May 24, 2009
    Messages:
    119
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Austin, TX
    cPanel Access Level:
    Root Administrator
    Did we find a fix for this?
     
  6. AdamDresch

    AdamDresch Well-Known Member

    Joined:
    Jun 22, 2006
    Messages:
    80
    Likes Received:
    0
    Trophy Points:
    6
    Submitting a support ticket today, I'll post an update when I have one
    Sorry been busy with other stuff. :(
     
  7. morissette

    morissette Well-Known Member

    Joined:
    May 24, 2009
    Messages:
    119
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Austin, TX
    cPanel Access Level:
    Root Administrator
    I actually fixed it about 30 mins ago. Forced through:

    /var/cpanel/rpm.versions.d/local.versions
     
  8. AdamDresch

    AdamDresch Well-Known Member

    Joined:
    Jun 22, 2006
    Messages:
    80
    Likes Received:
    0
    Trophy Points:
    6
    Yea, apparently I had 3 different mysql versions listed in that very file.

    Issue was fixed VERY quickly by Ken Folse

    Thanks Ken!
    Request Id 4649291
     
  9. martyf

    martyf Member

    Joined:
    Oct 17, 2010
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I've just experienced the same thing, but have not been able to resolve it through the suggestions made here.

    Logged a support ticket to see what the outcome is, but had to resort to a full server restore in the meantime to get sites back up and running as MySQL failed to start when the upgrade failed.
     
  10. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,426
    Likes Received:
    2
    Trophy Points:
    38
    cPanel Access Level:
    DataCenter Provider
    Would you please post the ticket number so we can followup.
     
Loading...

Share This Page