could not open single-table tablespace file

最新推荐文章于 2022-03-10 12:04:13 发布

最新推荐文章于 2022-03-10 12:04:13 发布 · 999 阅读

文章标签：

#mysql

mysql 专栏收录该内容

3 篇文章

订阅专栏

本文解决了一个特定的MySQL启动错误，该错误涉及到重复的表空间ID。通过将特定的.ibd文件和其他相关文件移至另一个文件夹，可以避免冲突并成功启动MySQL。

[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]