mysql异常关闭错误异常处理

时间:2022-08-26 08:05:14

用xmapp启动mysql时报错:

2015-10-22 10:07:32 4904 [Note] InnoDB: Database was not shutdown normally!
2015-10-22 10:07:32 4904 [Note] InnoDB: Starting crash recovery.
2015-10-22 10:07:32 4904 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-10-22 10:07:32 4904 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace logist/jdorder uses space ID: 2 at filepath: .\logist\jdorder.ibd. Cannot open tablespace mysql/innodb_index_stats which uses space ID: 2 at filepath: .\mysql\innodb_index_stats.ibd
InnoDB: Error: could not open single-table tablespace file .\mysql\innodb_index_stats.ibd

 解决方式:

修改mysql/bin/my.ini文件,增加

innodb_force_recovery =1