By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,374 Members | 1,768 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,374 IT Pros & Developers. It's quick & easy.

Corrupt read only tables

P: 1
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.
May 27 '15 #1

✓ answered by 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

Share this Question
Share on Google+
4 Replies


Expert Mod 100+
P: 589
Hard drive beginning to crash?

14.1.4.1 Corrupted MyISAM Tables
May 27 '15 #2

Expert Mod 100+
P: 589
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.
May 27 '15 #3

P: 1
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
May 27 '15 #4

computerfox
100+
P: 278
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.
May 27 '15 #5

Post your reply

Sign in to post your reply or Sign up for a free account.