Site5 Q&A » Corrupt read only tables

Corrupt read only tables

In: MySQL Asked By: elmartorsson [2

]

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.

3 Answers Answer this Question Now

May 6, 2015

Answer #1

There are any number of ways that a table can become corrupt, but the most common ways are a disconnect while writing to the table or, simply, the MySQL server dropping unexpectedly.

Honestly, the myisamchk -r may be doing this, as well – if this is run at the same time as the table is being modified by something else, it will corrupt the table.

Answered By: jdavey [359

]

Answer #2

Visit following thread, where the same trouble was already solved http://www.sqlservercentral.com/Forums/Topic1619584-2893-1.aspx

Answered By: samuelbergius [2

]

Answer #3

That thread would also work, but please note that is related directly to innoDB tables.

Answered By: jdavey [359

]

Answer this Question

You must be Logged In to post an Answer.

Not a member yet? Sign Up Now »