How to upgrade client MySQL from 5.1 to 5.6 on Windows


2016-11-16 12:39:33 UTC


2017-04-24 19:22:20 UTC


Was this article helpful?

Have more questions?

Submit a request

How to upgrade client MySQL from 5.1 to 5.6 on Windows

Applicable to:

  • Plesk 10.4 for Windows
  • Plesk 11.0 for Windows
  • Plesk 11.5 for Windows
  • Plesk 12.0 for Windows
  • Plesk 12.5 for Windows

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.

plesk installer

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:

  1. 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
  2. Download

  3. For the backup purpose create copy of the following folders, here client databases are saved:

  4. Stop mysql service:

  5. Rename old MySQL51 folder, extract folder from downloaded archive to %plesk_dir%\\Databases\\ and rename to MySQL51 .

  6. Start MySQL server

  7. Upgrade MySQL:

    "%plesk_dir%\\Databases\\MySQL51\\bin\\mysql_upgrade" -uadmin -p<PASSWORD>  -P3306

    or starting from Plesk 12.0

    "%plesk_bin%\\mysqlmng.exe" --upgrade-local-service

Note : If admin password for mysql is not known, it should be reseted using KB #213947045 - How to reset the MySQL administrator's password

KB #213367429 - How to upgrade Plesk MySQL from 5.1 to 5.5 on Linux

Have more questions? Submit a request
Please sign in to leave a comment.