Important: MySQL version 5.7 is not supported by Plesk 12.5
How to upgrade MySQL server from 5.1 to 5.6?
Please note this instruction for CLIENT database server only. You cannot upgrade mysql server with Plesk database.
The easiest upgrade method is to use Plesk autoinstaller. Just type the following command in command line.
MySQL upgrade manual from the vendor can be used also.
Important: Please do not forget to back up data before the upgrade. In general, instructions are the following:
Create dump of all databases, this dump could be helpful in case if something would go wrong:
"%plesk_dir%\Databases\MySQL51\bin\mysqldump" -uadmin -p<PASSWORD> -P3306 --all-databases --routines > all.dump
- Download mysql-5.6.33-win32.zip
For the backup purpose create copy of the following folders, here client databases are saved:
Stop mysql service:
NET STOP MySQL
MySQL51folder, extract folder from downloaded archive to
%plesk_dir%\Databases\and rename to
Start MySQL server
NET START MySQL
"%plesk_dir%\Databases\MySQL51\bin\mysql_upgrade" -uadmin -p<PASSWORD> -P3306
or starting from Plesk 12.0
Note: If admin password for mysql is not known, it should be reseted using KB #116050 - How to reset the MySQL administrator's password