InnoDB: Error: table `database`.`table` does not exist in the InnoDB internal data dictionary

Created:

2016-11-16 13:00:43 UTC

Modified:

2017-08-08 13:14:36 UTC

1

Was this article helpful?


Have more questions?

Submit a request

InnoDB: Error: table `database`.`table` does not exist in the InnoDB internal data dictionary

Applicable to:

  • Plesk 12.5 for Linux

Symptoms

Cannot restore MySQL dump, the following error can be found in MySQL logs:

InnoDB: Error: table `database`.`table` does not exist in the InnoDB internal
data dictionary though MySQL is trying to drop it.
Have you copied the .frm file of the table to the
MySQL database directory from another database?
You can look for further help from
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html

Cause

.frm file of the table of affected database was corrupted or removed.

Resolution

  1. Log in to plesk database:

    # plesk db
  2. Drop database:

    mysql> drop database <database>;
  3. Manually create this database:

    mysql> create database <database>;
  4. Try to restore database from dump.

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