Upgrading MySQL to 5.5.19

[ChrisCross]

Sorry if this gets asked a lot; but need to upgrade MySQL to latest version. Can i Just upgrade or will it break Plesk??
Has anyone done this yet and it's worked? i am on Centos5 running on a 1and1 VPS. Just trying to upgrade to 10.3.1 at the moment and it's taking some time :|

 

[EdwardDekker]

MySQL 5.5.19 will function normal at Plesk 10.3.
It is safe to upgrade if you want too.

Commands:
1. Use mysqldump to dump your database

mysqldump -h localhost –all-databases -uadmin -p > /root/dump.sql

2. Backup whole server
3. Check all databases and fix errors

mysqlcheck –all-databases -af -uadmin -p

4. Upgrade MySQL

$ yum upgrade mysql

5. Execute upgrade command for database

mysql_upgrade -h localhost -uadmin -p

6. Check after upgrade the databases

mysqlcheck –check-upgrade –all-databases -uadmin -p

For a daily maintenance you could use "crontab -e" as ROOT and insert

[B]0    1    *    *    *    mysqlcheck –all-databases -ao -uadmin -p`cat /etc/psa/.psa.shadow` > /dev/null 2>&1[/B]

 

[ChrisCross]

Thanks, i will give it a try and report back