mysql 恢复模式2启动_MySQL 启动失败数据恢复案例

陈星汉

于 2021-01-19 01:38:07 发布

阅读量805

点赞数

文章标签： mysql 恢复模式2启动

本文链接：https://blog.csdn.net/weixin_31069599/article/details/113170784

版权

本文介绍了在MySQL启动失败时如何利用InnoDB的恢复模式进行数据恢复。通过设置`innodb_force_recovery`参数，从级别1逐步尝试，避免使用可能引起数据破坏的高级别。在恢复模式2下成功启动MySQL，备份数据，删除错误的日志和数据文件，然后从备份恢复。关闭修复模式并重启MySQL后，数据库恢复正常运行。

摘要由CSDN通过智能技术生成

Forcing InnoDB Recovery提供了6个等级的修复模式，需要注意的是值大于3的时候，会对数据文件造成永久的破坏，不可恢复。六个等级的介绍摘抄如下：

Forcing InnoDB Recovery

1 (SRV_FORCE_IGNORE_CORRUPT)

Lets the server run even if it detects a corrupt page. Tries to make SELECT * FROM tbl_name jump over corrupt index records and pages, which helps in dumping tables.

2 (SRV_FORCE_NO_BACKGROUND)

Prevents the master thread and any purge threads from running. If a crash would occur during the purge operation, this recovery value prevents it.

3 (SRV_FORCE_NO_TRX_UNDO)

Does not run transaction rollbacks after crash recovery.

4 (SRV_FORCE_NO_IBUF_MERGE)

Prevents insert buffer merge operations. If they would cause a crash, does not do them. Does not calculate table statistics. This value can permanently corrupt data files. After using this value, be prepared to drop and recreate all secondary indexes.

5 (SRV_F