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:
    46,390
    Likes Received:
    2,046
    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:
    46,390
    Likes Received:
    2,046
    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,486
    Likes Received:
    31
    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. ca2236

    MySQL to Mariadb upgrade path?

    ca2236, Mar 19, 2019 at 6:08 PM, in forum: Database Discussion
    Replies:
    2
    Views:
    81
    cPanelLauren
    Mar 21, 2019 at 1:40 PM
  2. f1alan

    MySQL Upgrade Safety

    f1alan, Mar 19, 2019 at 7:27 AM, in forum: Database Discussion
    Replies:
    2
    Views:
    84
    f1alan
    Mar 21, 2019 at 5:16 AM
  3. kelsheikh

    Upgraded to MySql 5.7 and EasyApache 4 now altered RPMs for missing MySQL56-server-5.6.41-1.cp1162

    kelsheikh, Mar 7, 2019, in forum: General Discussion
    Replies:
    1
    Views:
    139
    cPanelMichael
    Mar 7, 2019
  4. SamSpade

    Upgrade MySQL 5.6 to MariaDB 10.3 fails due to repo problem

    SamSpade, Mar 3, 2019, in forum: Database Discussion
    Replies:
    6
    Views:
    576
    cPanelMichael
    Mar 11, 2019
  5. aries

    Error in MySQL upgrade from 5.6 to 5.7

    aries, Feb 22, 2019, in forum: Database Discussion
    Replies:
    1
    Views:
    197
    cPanelMichael
    Feb 25, 2019

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