September 29, 2009

MySql: How to repair a crashed table ?

To repair MySql table just go to shell prompt and execute this command ..


mysqlcheck --auto-repair databasename tablename

For eg: mysqlcheck --auto-repair testdbname testtable

To check the status of a table use "--check" option.

Eg: mysqlcheck --check dbname tablename


No comments: