HOW TO : Repair corrupted MYSQL Table

I recently came across a corrupted table in MySQL and was getting the following error, when I was trying to access a table.

“mysql ERROR 145 (HY000): Table ‘xxxxxxx’ is marked as crashed and should be repaired”

I repaired the table by

  • Log into the mysql client using “mysql”
  • Change to the required database by using “use DATABASE_NAME”
  • Repair the table by using “repair table TABLE_NAME”

Love the simplicity of MySQL :).