How can a read only MYISAM table become corrupt?
I have to do a myisamchk -r approx. once a week as the table gets marked as crashed.
I can’t see how this is happening though as no changes are being made to it, it’s read only.
It’s running on mysqld-nt version 5.0.51b, the same table running on a mac and a linux box have not done this, so far.
There are any number of ways that a table can become corrupt, but the most common ways are a disconnect while writing to the table or, simply, the MySQL server dropping unexpectedly.
Honestly, the myisamchk -r may be doing this, as well – if this is run at the same time as the table is being modified by something else, it will corrupt the table.
Visit following thread, where the same trouble was already solved http://www.sqlservercentral.com/Forums/Topic1619584-2893-1.aspx
That thread would also work, but please note that is related directly to innoDB tables.
You must be Logged In to post an Answer.
Not a member yet? Sign Up Now »