could not open single-table tablespace file

最新推荐文章于 2024-06-19 13:44:25 发布

xianyongonly

最新推荐文章于 2024-06-19 13:44:25 发布

阅读量947

点赞数

分类专栏： mysql 文章标签： mysql

mysql 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

[size=large]window下免安装版mysql启动报如下错误[/size]

2014-02-11 16:20:27 8984 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace minblog/tal_advertisement uses space ID: 2 at filepath: .\minblog\tal_advertisement.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

[size=large]解决方法[/size]

[b][color=blue][size=medium]Move (DON'T DELETE) those files, into another folder:

innodb_index_stats.frm
innodb_table_stats.frm
slave_master_info.frm
slave_relay_log_info.frm
slave_worker_info.frm
and .ibd files with the same filename:

innodb_index_stats.ibd
innodb_table_stats.ibd
slave_master_info.ibd
slave_relay_log_info.ibd
slave_worker_info.ibd
Try start MySQL.[/size][/color][/b]