Question MySQL Upgrade 5.1 to 5.6 or 5.7?

[Ryan van Brunschot]

Hi Folks,

For a long time im struggling now to upgrade MySQL on my Plesk Server. It runs on CentOS 6.8 and Plesk 17.0.17. For now MySQL 5.1 is installed, and i would like to upgrade to 5.6 or 5.7.

Without any loses and close all of the danger out.

Im a total noob in upgrading databases and with MySQL.

Thanks,
Ryan

 

[IgorG]

I used this method on my Plesk CentOS6 server https://support.plesk.com/hc/en-us/articles/213403429

 

[WebHostingAce]

I can confirm that I have successfully upgraded to MySQL 5.6 from 5.1 without any issue on a CentOS 6.8 VPS.

Stop MySQL
Get the repo & install then DISABLE 5.7 and enable 5.6
Yum update mysql
Service mysqld start

Run mysql_upgrade command once the upgrade is completed.