• Article for your preferred language does not exist. Below is international version of the article.

Article ID: 9365, created on Nov 25, 2010, last review on May 11, 2014

  • Applies to:
  • Plesk 9.x for Windows

The recommended instruction

1. First, read the MySQL upgrade manual.

2. Back up your old MySQL data to the folder %plesk_dir%\databases\mysql.

3. 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'

4. Check the client's MySQL version:
"%plesk_dir%\Databases\MySQL\bin\mysql" -uadmin -pMYSQL_ADMIN_PASSWORD -V
Note: If the version is older than 5.0.0, then you can't upgrade MySQL.

5. Uninstall the old MySQL server:
Go to Add/Remove programs (Programs and Features in Windows 2008) and modify Plesk installation to remove the "Database Management\MySQL Database Server" component.

6. Install a new MySQL server:
mysql-essential-5.x.xx-win32.msi ADDLOCAL=ALL PORT=3306 INSTALLDIR="%plesk_dir%\Databases\MySQL\" DATADIR="%plesk_dir%\Databases\MySQL\Data" ALLUSERS=1 ARPSYSTEMCOMPONENT=1 REBOOT=R /qb

7. Create and run MySQL service:
sc create MySQL binPath= "\"%plesk_dir%\Databases\MySQL\bin\mysqld.exe\" MySQL"  obj= "LocalSystem"  password= "1q2w3eQWE"

Note: 1q2w3eQWE is a sample password.
sc config MySQL start= auto
net start MySQL /Y
Note that sometimes server cannot be started due to old my.ini file or old ib_logfile* ibdata* files in DATADIR MySQL.

8. Run the mysql_upgrade utility:
"%plesk_dir%\Databases\MySQL\bin\mysql_upgrade.exe" --user --password=MYSQL_ADMIN_PASSWORD

 

Note: %plesk_dir% is an environment variable which points to the Plesk installation folder. By default, it is C:\Program Files\Parallels\Plesk.

aac4a8fcd879de03758354e15495d69a a914db3fdc7a53ddcfd1b2db8f5a1b9c 85a92ca67f2200d36506862eaa6ed6b8 56797cefb1efc9130f7c48a7d1db0f0c 0efe2234e2ce513f2186f26c68447702

Email subscription for changes to this article
Save as PDF