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 Upgrade

Discussion in 'Database Discussions' started by joomla, Jun 20, 2015.

  1. joomla

    joomla Well-Known Member

    Joined:
    Jul 23, 2014
    Messages:
    48
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Hello,

    I need to upgrade MySQL form 5.5 to 5.6. I see that it is a process of 7 steps.

    Is it hard to make upgrade via cPanel interface, do I need to prepare something and does websites that are fully functional under MySQL 5.5 will work with MySQL 5.6.

    Do I need to update something else before MySQL Upgrade?

    Is there some official tutorial or video that shows those 7 steps.

    Many, many, thanks to all in advance! I do please for help! :)

    We use the latest cPanel version.

    Best regards!
     
  2. 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:
    I will suggest you to backup your all mysql databases before proceeding with Mysql upgrade. Take backup in .sql format and keep it in one safe place. Once done then you can upgrade mysql from WHM >> Mysql upgrade option.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    The "WHM Home » Software » MySQL/MariaDB Upgrade" option will take you through all of the steps required to upgrade MySQL. I suggest backing up your databases beforehand, but beyond that, no additional steps are required.

    As far as compatibility, most scripts that function on MySQL 5.5 should function on MySQL 5.6. MySQL offers an upgrade document that lists the changes at:

    https://dev.mysql.com/doc/refman/5.6/en/upgrading-from-previous-series.html

    Thank you.
     
Loading...

Share This Page