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