A Note on Recovering from InnoDB Corruption

InnoDB is a great storage engine for MySQL offering, among other things, transaction support. One of its drawbacks is the difficulty that you can face when corruption inevitably hits.

At work we have dealt with corrupt InnoDB tables often enough to make the procedure fairly routine. Last week I was faced with a situation that had me pulling my hair out; in fact we almost threw in the towel.