如何修复 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屋！