mysql - 凌晨,数据尽毁 | .ibd' already exists though the corresponding table

Question

没时间整理格式了. 小编给看看吧.

凌晨, 磁盘突然一段异响后, 重启 mysql , 所有数据库无法打开, 有时,
有的库里只剩原来 10% 的表了, phpmyadmin 各种报错 ...

查了下系统日志, 看到这些, 没力气了, 已经头大, 大家帮帮忙...

Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure

For more information, see Help and Support Center at http://www.mysql.com.  


InnoDB: Cannot open table pro_szjz_m/psm_order from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.

For more information, see Help and Support Center at http://www.mysql.com.  

InnoDB: The file '.\pro_szjz_m\psm_aanote.ibd' already exists though the corresponding table did not exist in the InnoDB data dictionary. Have you moved InnoDB .ibd files around without using the SQL commands DISCARD TABLESPACE and IMPORT TABLESPACE, or did mysqld crash in the middle of CREATE TABLE? You can resolve the problem by removing the file '.\pro_szjz_m\psm_aanote.ibd' under the 'datadir' of MySQL.

For more information, see Help and Support Center at http://www.mysql.com.  

InnoDB: Cannot create file '.\pro_szjz_m\psm_aanote.ibd'

InnoDB: The file '.\pro_szjz_m\psm_aanote.ibd' already exists though the corresponding table did not exist in the InnoDB data dictionary. Have you moved InnoDB .ibd files around without using the SQL commands DISCARD TABLESPACE and IMPORT TABLESPACE, or did mysqld crash in the middle of CREATE TABLE? You can resolve the problem by removing the file '.\pro_szjz_m\psm_aanote.ibd' under the 'datadir' of MySQL.

For more information, see Help and Support Center at http://www.mysql.com. 

Answer 1

先試試第一個問題

mysql*path*/mysql/bin/mysql_upgrade -u root -p

後面的已經在日誌說了，一點點試試找到問題