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:
    156
    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:
    824
    Likes Received:
    22
    Trophy Points:
    168
    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
     
    #2 vanessa, Mar 5, 2014
  3. AdamDresch

    AdamDresch Well-Known Member

    Joined:
    Jun 22, 2006
    Messages:
    80
    Likes Received:
    0
    Trophy Points:
    156
    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.
     
    #3 AdamDresch, Mar 5, 2014
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,086
    Likes Received:
    1,288
    Trophy Points:
    363
    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.
     
    #4 cPanelMichael, Mar 5, 2014
  5. morissette

    morissette Well-Known Member

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

    AdamDresch Well-Known Member

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

    morissette Well-Known Member

    Joined:
    May 24, 2009
    Messages:
    119
    Likes Received:
    0
    Trophy Points:
    66
    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
     
    #7 morissette, Mar 11, 2014
  8. AdamDresch

    AdamDresch Well-Known Member

    Joined:
    Jun 22, 2006
    Messages:
    80
    Likes Received:
    0
    Trophy Points:
    156
    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
     
    #8 AdamDresch, Mar 11, 2014
  9. martyf

    martyf Member

    Joined:
    Oct 17, 2010
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    51
    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.
     
    #9 martyf, Jun 19, 2014
  10. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,451
    Likes Received:
    12
    Trophy Points:
    148
    cPanel Access Level:
    DataCenter Provider
    Would you please post the ticket number so we can followup.
     
    #10 cPanelNick, Jun 20, 2014
(You must log in or sign up to post here.)
Loading...
Similar Threads - Upgrading Mysql
  1. willrijo

    Error upgrading mysql 5.5 to MariaDB 10.1

    willrijo, May 15, 2017, in forum: Database Discussions
    Replies:
    4
    Views:
    391
    rpvw
    May 16, 2017
  2. anseme

    SOLVED Upgrade EasyApache first before upgrading Mysql?

    anseme, Jan 6, 2017, in forum: EasyApache
    Replies:
    2
    Views:
    418
    anseme
    Jan 7, 2017
  3. luigidelgado

    Replication after upgrading MySQL 5.6 to MariaDB

    luigidelgado, Mar 7, 2016, in forum: Database Discussions
    Replies:
    1
    Views:
    632
    cPanelMichael
    Mar 8, 2016
  4. cristis

    Error upgrading MySQL 5.6 to MariaDB 10.1

    cristis, Jan 31, 2016, in forum: Database Discussions
    Replies:
    6
    Views:
    1,432
    cPanelMichael
    Feb 6, 2017
  5. IRZQ88

    Out of RAM after upgrading to Easyapache4

    IRZQ88, May 5, 2017, in forum: EasyApache
    Replies:
    1
    Views:
    227
    Infopro
    May 5, 2017

Share This Page