如何修复InnoDB表? [英] How do I repair an InnoDB table?

问题描述

昨晚我们(显然)对Solaris MySQL数据库引擎的执行不佳.至少某些InnoDB表已损坏，其中事务日志中的时间戳无序错误，以及有关索引已损坏的特定错误.

We (apparently) had poorly executed of our Solaris MySQL database engine last night. At least some of the InnoDB tables are corrupted, with timestamp out of order errors in the transaction log, and a specific error about the index being corrupted.

我们知道可用于MyISAM表修复的工具，但无法为InnoDB找到任何东西.

We know about the tools available for MyISAM table repairs, but cannot find anything for InnoDB.

旁注:尝试优化表(在我尝试重建损坏的索引时)会导致数据库服务器崩溃.

Side note: attempting a table optimize (in my attempt to rebuild the corrupted index) causes the database server to crash.

推荐答案

首先停止服务器并对光盘进行映像.只打一针是没有意义的.然后在此处.

First of all stop the server and image the disc. There's no point only having one shot at this. Then take a look here.

这篇关于如何修复InnoDB表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！