The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL/MariaDB Upgrade

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

  1. whipworks

    whipworks Well-Known Member

    Joined:
    Aug 19, 2014
    Messages:
    105
    Likes Received:
    1
    Trophy Points:
    16
    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,577
    Likes Received:
    40
    Trophy Points:
    48
    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
     
  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.
     
  4. rishivispute

    rishivispute Member

    Joined:
    May 23, 2010
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    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.
     
  5. whipworks

    whipworks Well-Known Member

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

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,762
    Likes Received:
    662
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page