Mysql error Cannot find open x x from the internal Problem solution

  • 2020-06-19 11:49:55
  • OfStack

This error occurred in the site event log:

Event type: Error
Event source: MySQL
Event type: None
Event ID: 100
Date: 2012-8-14
Events: 8:07:59
User: N/A
Computer: abcserver
Description:

Cannot find or open table phpwind/pw_zhuanti from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database? or, the table contains indexes that this version of the engine
doesn't support.
See http://dev.mysql.com/doc/refman/5.1/en/innodb-troubleshooting.html
how you can resolve the problem.
For more information, see Help and Support Center at http://www.mysql.com.

But I looked it up and there was no list. This error means that the table has been deleted, but the.frm file still exists, causing a read error and so on.

So I searched 1 time on the server, found pw_zhuanti.frm file in the mysql data store folder, deleted it, fixed it, and never had this problem again.


Related articles: