Article ID: 125843, created on Jun 11, 2015, last review on Jun 17, 2016

  • Applies to:
  • Plesk 12.0 for Linux
  • Plesk 11.0 for Linux
  • Plesk 12.0 for Windows
  • Plesk 11.5 for Windows


An attempt to open a database via PhpMyadmin fails with the following error:

error mysql

The following error can be observed in %plesk_dir%\Databases\MySQL\data\**.err log file upon MySQL service startup:

131029  9:27:49  InnoDB: MySQL and InnoDB data dictionaries are out of sync.
131029  9:28:52 [Note] C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL51\bin\mysqld.exe: ready for connections.


The database is corrupted.


I. Use a database backup to restore.

II. If there is no any backup, follow the steps below:

  1. Add the string below to MySQL configuration file %plesk_dir%\Databases\MySQL\data\my.ini

    innodb_force_recovery = 4
  2. Restart MySQL service. Plesk Services Monitor can be used to do that.

  3. Create a backup of the corrupted database:

    "%plesk_dir%\MySQL\bin\mysqldump.exe" -u<username> -p<password> -P3306 corrupted_database_name > path_to_backup_of_database 

    (replace the username, password, corrupted_database_name, path_to_backup_of_database with the corresponding valid names/path and check the backup file content to ensure that the database was successfully backup).

  4. Remove the corrupted database:

    mysql> drop database corrupted_database_name;
    Query OK, 7 rows affected (0.35 sec)
  5. Delete innodb_force_recovery = 4 string from the MySQL configuration file %plesk_dir%\Databases\MySQL\data\my.ini.

  6. Restart MySQL service.

  7. Create an empty database with the same name as the corrupted_database_name:

    mysql> create database corrupted_database_name;
  8. Restore the corrupted database:

    "%plesk_dir%\MySQL\bin\mysql.exe" -u<username> -p<password> -P3306 corrupted_database_name < path_to_backup_of_database

Search Words

phpmyadmin error

PleskFatalException: Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: No such file or directory

MySQL and InnoDB data dictionaries are out of sync

the server is not responding

You probably did not create a configuration file


activate domain


46a8e394d6fa13134808921036a34da8 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 85a92ca67f2200d36506862eaa6ed6b8 bd7fc88cf1b01f097749ae6f87272128 29d1e90fd304f01e6420fbe60f66f838 aea4cd7bfd353ad7a1341a257ad4724a 0a53c5a9ca65a74d37ef5c5eaeb55d7f ed7be2b984f9c27de1d2dc349dc19c6d a766cea0c28e23e978fa78ef81918ab8 2a5151f57629129e26ff206d171fbb5f e335d9adf7edffca6a8af8039031a4c7

Email subscription for changes to this article
Save as PDF