[ERROR] Cannot find or open table wu777/processlist from the internal data dictionary of InnoDB tho
来源:互联网 发布:ee是哪个国家域名 编辑:程序博客网 时间:2024/05/23 21:18
错误日志报错:
160719 14:51:01 [ERROR] Cannot find or open table wu777/processlist 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.5/en/innodb-troubleshooting.html
how you can resolve the problem.
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.5/en/innodb-troubleshooting.html
how you can resolve the problem.
在information_schema里能看到该表的相应信息。如:
mysql> use wu777;
Database changed
Database changed
mysql> show tables;
+-------------------------------+
Tables_in_wu777
+-------------------------------+
processlist
+-------------------------------+
Tables_in_wu777
+-------------------------------+
processlist
但是却无法访问这个表。
ERROR 1146 (42S02): Table 'wu777.processlist' doesn't exist
而且,.frm文件还存在。
解决办法:
drop table wu777.processlist;
虽然执行该sql仍然会报错ERROR 1051 (42S02): Unknown table 'wu777.processlist'',但是再show tables就看不到这个表了。
0 0
- [ERROR] Cannot find or open table wu777/processlist from the internal data dictionary of InnoDB tho
- Error: Cannot find or open the PDB file
- Cannot find or open the PDB file???
- Cannot find or open the PDB file
- Cannot find or open the PDB file
- Cannot find or open the PDB file
- Cannot find or open the PDB file
- Cannot find or open the PDB file
- Cannot find or open the PDB file
- Cannot find or open the PDB file
- Cannot find or open the PDB file
- Cannot find or open the PDB file
- Cannot find or open the PDB file
- Cannot find or open the PDB file
- Cannot find or open the PDB file
- Export the table decribe from oracle data dictionary
- mysql Cannot find or open table x/x 及解决办法
- Recover Table Structure From InnoDB Dictionary
- Android View滑动
- [例证]从滑动冲突到事件分发(从源码角度分析)
- Android开发笔记之软键盘的隐藏
- js如何判断一个对象是不是Array?
- 字符设备驱动访问原理
- [ERROR] Cannot find or open table wu777/processlist from the internal data dictionary of InnoDB tho
- Android不同api调用显示路径
- 1007: [HNOI2008]水平可见直线
- ckeditor源码编辑模式,添加style、javascript内容丢失的解决
- Android-使用JsBridge来优化js与本地的交互
- 为什么匿名内部类参数必须为final类型
- Xcode提交AppStore报错: Communication error.Please user diagnostic mode to check connectivity. **
- Java集合框架:HashMap
- SSH学习日记之Struts(一)