【mysql】MySQL InnoDB 表损坏，显示错误： “MySQL is trying to open a table handle but the .ibd file for table ### does not exist”

服务器系统盘因为一次电源意外断电跳闸导致烧坏磁道，系统重启时候无法进入系统，更换服务器器后运行程序，发现事务日志里面频繁报错：
Cannot find or open table **** 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.

删除表，同时删除对应的ibd后缀文件再数据库文件夹里，庆幸备份了数据表且数据没有更新，本地恢复数据表，导出成新的sql表，运行回复表，成功。
以后还得是要注意定时备份