MySQL/MariaDB Upgrade

whipworks

• June 23, 2015 16:24

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!

• 

  dalem

  • June 24, 2015 01:04

  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

  0
• 

  24x7ss

  • June 24, 2015 04:00

  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.

  0
• 

  rishivispute

  • June 24, 2015 12:11

  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.

  0
• 

  whipworks

  • June 24, 2015 12:40

  Thanks guys! Appreciate the input(s)! :)

  0
• 

  cPanelMichael

  • July 01, 2015 17:24

  Are there any backwards compatibility issues?

  
  Hello :) You may experience some issues with scripts that are outdated. There's an informative document on the changes at:

  0

Please sign in to leave a comment.