Skip navigation links

MySQL Forums :: Newbie :: Table is marked as crashed and should be repaired


Advanced Search

Table is marked as crashed and should be repaired
Posted by: ritesh taksali ()
Date: March 19, 2008 05:12AM

Hi All

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"

Options: ReplyQuote


Subject Written By Posted
Table is marked as crashed and should be repaired ritesh taksali 03/19/2008 05:12AM
Re: Table is marked as crashed and should be repaired Vinod Sugur 03/19/2008 06:18AM


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.