Corrupt read only tables

[martinpayne]

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.

[RonB]

Hard drive beginning to crash?

14.1.4.1 Corrupted MyISAM Tables

[RonB]

That's an old version. Personally, I'd upgrade to the latest version (5.6 or 5.7) and convert the table(s) to InnoDB.

[loganwatts]

The recovery plan is following:
Split corrupted InnoDB tablespace into pages; sort the pages by type and index_id
Fetch records from PRIMARY index of the table
DROP corrupted table and create new one
Load records back into MySQL

Also you may visit the branch where the similar issue was resolved http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=196415

[computerfox]

Can you find the log files? Usually there's something in there. What machine is it crashing on, Windows? As Ron said, make sure it's up to date. Also, you might have to create a copy of the table and transfer the data over.