用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