Kudithipudi.Org

June 2, 2008

HOW TO : Repair corrupted MYSQL Table

Filed under: HOWTO,Linux,Technology — Vinay @ 7:52 pm

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 :) .

No Comments »

No comments yet.

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress