Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Upgrading Mysql from 5.5 to 5.6

Discussion in 'Database Discussion' 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:
    830
    Likes Received:
    26
    Trophy Points:
    178
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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:
    44,367
    Likes Received:
    1,855
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #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,480
    Likes Received:
    30
    Trophy Points:
    158
    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. keat63

    Upgrading MySQL 5.6 to MariaDB 10.2 Question

    keat63, May 17, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    383
    cPanelMichael
    May 18, 2018
  2. Sayem

    Activate MySQL 5.7 after upgrading to v70.0.12

    Sayem, Feb 16, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    616
    cPanelMichael
    Feb 19, 2018
  3. Venomous21

    Upgrading to MySQL 5.7

    Venomous21, Jan 30, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    1,905
    cPanelMichael
    Jan 31, 2018
  4. willrijo

    Error upgrading mysql 5.5 to MariaDB 10.1

    willrijo, May 15, 2017, in forum: Database Discussion
    Replies:
    4
    Views:
    1,062
    rpvw
    May 16, 2017
  5. anseme

    SOLVED Upgrade EasyApache first before upgrading Mysql?

    anseme, Jan 6, 2017, in forum: EasyApache
    Replies:
    2
    Views:
    870
    anseme
    Jan 7, 2017

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice