How to upgrade Plesk MySQL from 5.1 to 5.5 on Windows

Ref. Link: https://kb.plesk.com/en/124139 Applies to: Plesk 12.0 for Windows Plesk 11.5 for Windows Plesk 10.4 for Windows Please note this instruction for client database server only. You cannot upgrade mysql server…

All Articles
Ref. Link: https://kb.plesk.com/en/124139 Applies to:
  • Plesk 12.0 for Windows
  • Plesk 11.5 for Windows
  • Plesk 10.4 for Windows

Please note this instruction for client database server only. You cannot upgrade mysql server with Plesk database.

You can use Mysql upgrade manual from vendor: http://dev.mysql.com/doc/refman/5.5/en/upgrading.html Please do not forget to backup data before upgrade. In general instruction is the following:
  • Create dump of database:
C:\Program Files\Parallels\Plesk\Databases\MySQL51\bin>mysqldump -uadmin -p**** -P3306 --all-databases >all.dump
  • Download zip archive
  • Create copy of the following folders, here client databases are saved:
C:\Program Files\Parallels\Plesk\Databases\MySQL C:\Program Files\Parallels\Plesk\Databases\MySQL51
  • stop mysql service:
NET STOP MySQL
  • extract downloaded archive to C:\Program Files\Parallels\Plesk\Databases\MySQL51 overwriting the existing installation.
  • start Mysql server
NET START MySQL
  • upgrade mysql:
C:\Program Files\Parallels\Plesk\Databases\MySQL51\bin>mysql_upgrade -uadmin -p**** -P3306
Published by

anup

Technical content from the 24x7ServerSupport infrastructure, server management and cloud operations team.