MySQL Forums :: Newbie :: Table is marked as crashed and should be repaired
Table is marked as crashed and should be repaired
Posted by: ritesh taksali
Date: March 19, 2008 05:12AM
We are running MYSQL database version 5.0.27, in this we have a table which have one field on which we have created the index, in this table we do high transcation by executing insert/select/update queries
We are getting this error " Table <TableName> is marked as crashed and should be repaired" randomely..
How to fix this error on the fly/real time, so that this error will never come, and no need to stop the client applications which are accessing this database..
As per initila investigation it looks like that this error comes becaue of index file corruption (.myi), which we can repair using the command
"myisamchk -r <DatabaseName>\*.myi"
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.