MySQL InnoDB误差

Question

当我不断收到以下错误时，我的服务器MySQL数据库出现了问题：

InnoDB: The log sequence in ibdata files is higher
InnoDB: than the log sequence number in the ib_logfiles! Are database?
InnoDB: you are using the right ib_logfiles to start up the database?
InnoDB: Log sequence number in ib_logfiles in 6316712, log
InnoDB: sequence numbers stamped to ibdata file headers are between
InnoDB: 24916633497 and 24916633497

希望有人能帮我这个忙。谢谢，提前！

Answer 1

1. 停止MySQL服务器；
2. 检查错误日志，查看是否关闭成功。(无错误)
3. 移动日志文件: mv /path/to/datadir/ib_logfile* /tmp/
4. 启动MySQL服务器。这将创建新的日志；
5. 当您完全确定MySQL服务器已经成功启动时，可以删除旧的日志文件: rm /tmp/ib_logfile*
   1. 可能的回滚是重复以下步骤: 1，反向3，4。