MySQL Forums
Forum List  »  MyISAM

Can't repair MyISAM table
Posted by: inoy cavalera
Date: September 19, 2011 09:52AM

Hi Experts,


I have a mysql database which is used to stored a measurement data. For unknown reason the database is crashed (#145 - Table '.\runout\ro_data' is marked as crashed and should be repaired) and i'm unable to repair it.
When i run CHECK TABLE query there are 4 results...

Table Op Msg_type Msg_text
runout.ro_data check warning Table is marked as crashed
runout.ro_data check warning 12 clients are using or haven't closed the table p...
runout.ro_data check error Size of datafile is: 0 Should be: 11497635...
runout.ro_data check error Corrupt

and everytime i run REPAIR TABLE query, my table become accessible but no data appear, i lost all the data.

My MYI file is about 4.9 GB and the MYD file is 0 KB.
How can i repair my table without loosing any data?

Thank you...

Options: ReplyQuote


Subject
Views
Written By
Posted
Can't repair MyISAM table
2889
September 19, 2011 09:52AM


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.