PhpMyadmin: MySQL said The server is not responding

Refers to:

  • Plesk 11.0 for Linux
  • Plesk 11.5 for Windows
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux

Created:

2016-11-16 13:22:31 UTC

Modified:

2016-12-21 20:34:38 UTC

0

Was this article helpful?


Have more questions?

Submit a request

PhpMyadmin: MySQL said The server is not responding

Symptoms

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.

Cause

The database is corrupted.

Resolution

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

    [mysqld]
    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
Have more questions? Submit a request
Please sign in to leave a comment.