《Mysql必讀Mysql錯誤Cannot find or open table x/x from the internal問題解決方法》要點：
本文介紹了Mysql必讀Mysql錯誤Cannot find or open table x/x from the internal問題解決方法，希望對您有用。如果有疑問，可以聯系我們。
MYSQL必讀網站事件日志出現了這個錯誤：
MYSQL必讀事件類型: 錯誤
事件來源: MySQL
事件種類: 無
事件 ID: 100
日期:? 2012-8-14
事件:? 8:07:59
用戶:? N/A
計算機: abcserver
描述:
代碼如下:
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.
MYSQL必讀但是查了一下,并沒有這個表啊.這個的錯誤的意思大概是某表已經刪除了,但是.frm文件還存在,所以會造成讀取錯誤等等.
MYSQL必讀于是服務器上找了一下,在mysql數據存儲文件夾,找到了pw_zhuanti.frm文件,刪除,之后解決了,再也沒有出現過這個問題了.
轉載請注明本頁網址：
http://www.fzlkiss.com/jiaocheng/1381.html
