Jump to content

Check out our Community Blogs

Register and join over 40,000 other developers!

Recent Status Updates

View All Updates

- - - - -

Corrupt read only tables

mysql database

This topic has been archived. This means that you cannot reply to this topic.
1 reply to this topic

#1 jenozsolt


    CC Lurker

  • Just Joined
  • Pip
  • 1 posts

Posted 15 May 2015 - 11:22 AM

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.

#2 conorrose


    CC Lurker

  • Just Joined
  • Pip
  • 1 posts

Posted 29 May 2015 - 05:26 AM

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

Edited by WingedPanther73, 29 May 2015 - 06:40 AM.
remove irrelevant spam link

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download