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/MariaDB Upgrade

Discussion in 'Database Discussion' started by whipworks, Jun 23, 2015.

  1. whipworks

    whipworks Well-Known Member

    Joined:
    Aug 19, 2014
    Messages:
    123
    Likes Received:
    3
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    I have WHM 11.50.0 (build 19): MySQL (5.1). The server has alerted me to upgrade to MySQL/MariaDB Upgrade. I'm a bit hesitant on doing this because I don't know what kind of changes it will make to our customers on the server? Are there any backwards compatibility issues? Would our customers current databases get affected in a way that it will be a problem for us?

    Thanks!
     
    #1 whipworks, Jun 23, 2015
    Last edited by a moderator: Jun 24, 2015
  2. dalem

    dalem Well-Known Member
    PartnerNOC

    Joined:
    Oct 24, 2003
    Messages:
    2,741
    Likes Received:
    76
    Trophy Points:
    203
    Location:
    SLC
    cPanel Access Level:
    DataCenter Provider
    Old Passwords
    if I'm not mistaken cpanel will alert you to it

    you should go to 5.5> 5.6>

    and backup your databases
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. 24x7ss

    24x7ss Well-Known Member

    Joined:
    Sep 30, 2014
    Messages:
    271
    Likes Received:
    16
    Trophy Points:
    18
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    First of all take the backup of your all the databases in .sql format and keep it in safe place then from WHM try upgrading Mysql from 5.1 to 5.5. Mostly in upgrade process there is no downtime or nothing happens it will run smoothly.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. rishivispute

    rishivispute Member

    Joined:
    May 23, 2010
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    51
    Location:
    pune
    cPanel Access Level:
    Root Administrator
    Twitter:
    If the database uses "innodb" tables then upgrade of Mysql from 5.1 to 5.5 is complicated.
    So my suggestion is take all database backup in .sql format and choose any method to upgrade the mysql.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. whipworks

    whipworks Well-Known Member

    Joined:
    Aug 19, 2014
    Messages:
    123
    Likes Received:
    3
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Thanks guys! Appreciate the input(s)! :)
     
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

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.
    Dismiss Notice