Jump to content

Welcome to MSFN Forum
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account



Photo

Corrupt read only tables

- - - - -

  • Please log in to reply
4 replies to this topic

#1
enginbayar

enginbayar
  • Member
  • 1 posts
  • Joined 27-July 15
  • OS:Vista Ultimate x86
  • Country: Country Flag

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.




How to remove advertisement from MSFN

#2
submix8c

submix8c

    Inconceivable!

  • Patrons
  • 4,580 posts
  • Joined 14-September 05
  • OS:none specified
  • Country: Country Flag

HDD error?


Someday the tyrants will be unthroned... Jason "Jay" Chasteen; RIP, bro!

Posted Image


#3
Tripredacus

Tripredacus

    K-Mart-ian Legend

  • Super Moderator
  • 10,098 posts
  • Joined 28-April 06
  • OS:Windows 7 x86
  • Country: Country Flag

Donator

HDD error?


While it is a valid question, this is likely to be a trap topic for spambots to reply in. First post is a copy/paste of a post on another forum where that has occurred, you can find it with these google terms:

"corrupt read only tables" calebbaxter

MSFN RULES | GimageX HTA for PE 3-5 | lol probloms
tpxmsfn1_zps393339c1.jpg


#4
Yzöwl

Yzöwl

    Wise Owl

  • Super Moderator
  • 4,078 posts
  • Joined 13-October 04
  • OS:Windows 7 x64
  • Country: Country Flag

Donator

This topic has been moved from the Programming Forum area

 

These tables are normally stored in three files, the definition, data and index, and are very easily corrupted.

 

The usual advice is to jump ship to an alternative such as InnoDB.



#5
jonahwatkins

jonahwatkins

    Banned

  • Banned
  • 1 posts
  • Joined 28-July 15
  • OS:Vista Business x86
  • Country: Country Flag

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






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users