Can't repair MyISAM table
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...
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.