Article ID: 114723, created on Sep 7, 2012, last review on Aug 12, 2014

  • Applies to:
  • Plesk 11.0 for Windows
  • Plesk 10.4 for Windows
  • Plesk 10.3 for Windows


For Parallels Plesk Panel (PP) version 10.3 and later versions, the required MySQL 5.1 version must be installed. It will be installed to the PLESK_DIR\Databases\MySQL51 folder and registered as the default MySQL service, even if the custom local MySQL server or MySQL server was installed to a custom location (non-PLESK_DIR\Databases\MySQL folder) before the PP upgrade procedure. This custom MySQL server will not be affected, but it will be unavailable, as will all of the databases.

Therefore, the custom local MySQL server with all of the databases will be unavailable after the PP upgrade.


1. If you have a custom local MySQL server with a version number of 5.0 or higher: Use KB article to upgrade your MySQL server to version 5.1. After that, you can start the PP upgrade procedure.

2. If you have a custom local MySQL server with a version number of 5.0 or lower: Upgrade it to version 5.0 according to this documentation: After that, return to Solution 1.

3. The post-upgrade solution is complex; therefore, we recommend a pre-upgrade solution (Solution 1 or 2).

The post-upgrade solution can be performed with the following steps:

Get the client's MySQL admin password, e.g., MYSQL_ADMIN_PASSWORD:
%plesk_bin%\dbclient" --direct-sql --sql="select admin_login, admin_password from databaseservers where type='mysql'

- Stop MySQL service:
net stop MySQL

- Remove current MySQL service:
sc delete MySQL

- Add custom local MySQL service. For example:
sc create MySQL binPath= "\"C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin\mysql.exe\" \"--defaults-file=C:\Program Files (x86)\MySQL\MySQL Server 5.0\my.ini\" MySQL" obj= "LocalSystem" password= "1q2w3eQWE"

- Start custom local MySQL service:
net start MySQL /Y

- Create dumps of all databases with the mysqldump.exe utility.

- Stop and remove MySQL service:

net stop MySQL
sc delete MySQL

- Add the MySQL server that was installed by PP as the default MySQL service:
sc create MySQL binPath= "\"%plesk_dir%\Databases\MySQL51\bin\mysqld.exe\" \"%plesk_dir%\Databases\MySQL\Data\my.ini" MySQL" obj= "LocalSystem" password= "1q2w3eQWE"
(Note: 1q2w3eQWE is a sample password.)
sc config MySQL start= auto
net start MySQL /Y

- Create dumps of all databases of this new MySQL server with the mysqldump.exe utility.
- Restore dumps from the custom local MySQL server.
- Merge "users" tables from both dumps (from custom local and PP MySQL servers).
- Run upgrade of databases with the following:

"%plesk_dir%\Databases\MySQL51\bin\mysql_upgrade.exe" --user --password=MYSQL_ADMIN_PASSWORD

514af229ae32522202a910a2649c80fb 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 85a92ca67f2200d36506862eaa6ed6b8 bd7fc88cf1b01f097749ae6f87272128 ff5a00b8ead2e480367b019417a04207 c796c01d6951fa24ed54c7f1111667c6 f2d85fccc955a226f0b30e58456170cb

Email subscription for changes to this article
Save as PDF