Jump to content


Check out our Community Blogs

Register and join over 40,000 other developers!


Recent Status Updates

View All Updates

Photo
- - - - -

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

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

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