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!

MySQL Upgrade (those 7 steps)

Discussion in 'Database Discussion' started by MyDreamscape, Sep 17, 2014.

  1. MyDreamscape

    MyDreamscape Member

    Joined:
    Apr 27, 2010
    Messages:
    6
    Likes Received:
    1
    Trophy Points:
    53
    Location:
    Netherlands
    Hit there,

    I am absolutely unfamiliar with servers but WHM "forces" me to upgrade MySQL and PHP else no WHM and cPanel updates posible it says.

    Is it possible to do both (MySQL/PHP) through WHM without any hassle?

    What I would like to know: what will be asked/what I have to do, during those famous 7 steps. Which info do I need to "feed" the server with? Is there a list with those (7)steps? Also reading everywhere that php won't work afterwards and therefore also has to be upgraded.

    Looking forward finding help/information.
     
    #1 MyDreamscape, Sep 17, 2014
  2. MyDreamscape

    MyDreamscape Member

    Joined:
    Apr 27, 2010
    Messages:
    6
    Likes Received:
    1
    Trophy Points:
    53
    Location:
    Netherlands
    Additonal information (sorry can't edit own thread?):

    MySQL Currently installed: 5.0.96 / CENTOS 5.10 x86_64 / WHM 11.44.1 (build 18) / cPanel Version 11.44.1 (build 18).
     
    #2 MyDreamscape, Sep 17, 2014
  3. server9host

    server9host Well-Known Member

    Joined:
    Sep 18, 2013
    Messages:
    160
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hello,

    For updating mysql you need to perform easyapache.

    Let me know which PHP version you are currently use. Because for new cPanel update need to perform easyapache on server and in easyapache above 5.3
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 server9host, Sep 17, 2014
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,672
    Likes Received:
    1,788
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    Yes, it's possible to upgrade both MySQL and Apache/PHP through Web Host Manager. In fact, the MySQL Upgrade interface will take you through all of the steps to complete this. The MySQL upgrade process is documented here:

    MySQL Upgrade

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelMichael, Sep 17, 2014
  5. MyDreamscape

    MyDreamscape Member

    Joined:
    Apr 27, 2010
    Messages:
    6
    Likes Received:
    1
    Trophy Points:
    53
    Location:
    Netherlands
    Hi there,

    Specs shown in cPanel:

    cPanel Version 11.44.1 (build 18)
    Apache version 2.0.63
    PHP version 5.2.9
    MySQL version 5.0.96-community
    Architecture x86_64
    Perl version 5.8.8
    Kernel version 2.6.32.60xls-domU
    cPanel Pro 1.0 (RC1)

    (all is on a production server, we have no dev server to test else it would been done probably)

    What do you mean by "perform easyapache" ?
     
    #5 MyDreamscape, Sep 17, 2014
  6. storminternet

    storminternet Well-Known Member

    Joined:
    Nov 2, 2011
    Messages:
    460
    Likes Received:
    0
    Trophy Points:
    66
    cPanel Access Level:
    Root Administrator
    Easyapache is cPanel's script developed to compile/update Apache, PHP. For more details refer to EasyApache
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 storminternet, Sep 17, 2014
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,672
    Likes Received:
    1,788
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Please keep in mind that your PHP version will upgrade to 5.3 by default because version 5.2 is no longer offered in EasyApache.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #7 cPanelMichael, Sep 17, 2014
  8. server9host

    server9host Well-Known Member

    Joined:
    Sep 18, 2013
    Messages:
    160
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hello,

    Please confirm with your developer regarding your site will work on PHP version 5.3 and above. Because after upgrade the PHP version it's very difficult task to downgrade the PHP version on server.

    Or one more option you can use cloud link feature to use multiple PHP version in same server. Using this feature you can upgrade php version with latest version and use php 5.2 to for your all websites.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #8 server9host, Sep 17, 2014
  9. cPanelNick

    cPanelNick Administrator
    Staff Member

    Joined:
    Mar 9, 2015
    Messages:
    3,480
    Likes Received:
    29
    Trophy Points:
    158
    cPanel Access Level:
    DataCenter Provider

    cPanel & WHM version 11.44.1.15 and later contains significant improvements to the MySQL Upgrade tool. The new version of the MySQL Upgrade tool also allows you to defer the rebuild of Apache and PHP. We strongly recommend that you update cPanel & WHM to version 11.44.1.15 before you update MySQL®.
     
    #9 cPanelNick, Sep 18, 2014
(You must log in or sign up to post here.)
Loading...
Similar Threads - MySQL Upgrade (those
  1. cosmin

    New Thread MySQL InnoDB errors after upgrade to 5.7

    cosmin, Jun 20, 2018 at 11:46 PM, in forum: Database Discussion
    Replies:
    1
    Views:
    16
    sktest123
    Jun 21, 2018 at 12:50 AM
  2. Edwin Tjallings

    In Progress [CloudLinux ALTPHP-524] Alt-php not working after mysql 5.7 upgrade

    Edwin Tjallings, Jun 13, 2018, in forum: CloudLinux
    Replies:
    5
    Views:
    146
    cPanelMichael
    Jun 19, 2018 at 8:11 AM
  3. Nirjonadda

    MySQL 5.7 upgrade process failed

    Nirjonadda, Feb 6, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    550
    cPanelMichael
    Feb 14, 2018
  4. psytanium

    SOLVED MySQL upgrade recommendation

    psytanium, Jan 17, 2018, in forum: Database Discussion
    Replies:
    7
    Views:
    704
    PeteS
    Feb 7, 2018
  5. aolbrechts

    SOLVED Can't upgrade from MySQL 5.6 to MariaDB 10.1

    aolbrechts, Jan 10, 2018, in forum: Database Discussion
    Replies:
    16
    Views:
    836
    aolbrechts
    Jan 19, 2018

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