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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,895
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,895
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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:
    30
    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. strensnik

    Unable to Complete MySQL/MariaDB Upgrade

    strensnik, Oct 6, 2018, in forum: Database Discussion
    Replies:
    8
    Views:
    162
    cPanelLauren
    Oct 12, 2018 at 7:10 AM
  2. maestroc

    sqlite and pdo_mysql errors after Apache 4 upgrade

    maestroc, Oct 3, 2018, in forum: EasyApache
    Replies:
    1
    Views:
    54
    cPanelLauren
    Oct 8, 2018
  3. Duncan Eagles

    Upgrade MySQL 5.5 to 5.6

    Duncan Eagles, Sep 19, 2018, in forum: Database Discussion
    Replies:
    6
    Views:
    158
    rpvw
    Oct 12, 2018 at 4:42 PM
  4. PatrickVeenstra

    MySQL upgrade degrades performance

    PatrickVeenstra, Sep 2, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    106
    cPanelMichael
    Sep 4, 2018
  5. ejde

    Error in MySQL upgrade from 5.6 to 5.7

    ejde, Aug 27, 2018, in forum: Database Discussion
    Replies:
    3
    Views:
    187
    cPanelMichael
    Aug 28, 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