Fixing a corrupted index on a table


  • Server won't start, or it will start and show a scary FATAL error message.


  • Continue to increment the innodb_force_recovery option in the database until you can log in:
  • Dump the table in question to a .sql file.
  • Try dropping the table.
    • You may have to toggle foreign key checking off:
    • If dropping the table hangs, increase the innodb_force_recovery setting some more until you can.
  • Reimport the table from the .sql file
  • Ensure foreign key checking is re-enabled
  • Remove the innodb_force_recovery option from the config