Re: Corruptions like crazy
After reading the extract below from the document, based upon what it is saying, it appears that either the disk drive has a problem or there is "A software bug in the MySQL or MyISAM code". It seems strange that if it is a disk drive problem it would consistently effect three tables at exactly the same time in exactly the same way (the two stages of errors as described in the first post). This morning the problem was such that I repaired the tables and ran the check to make sure there were no errors but the update from my webpage issued an error suggesting I repair the table when when I ran the myisamchk command it said there were no errors. So I had no choice but return the database with phpMyAdmin and that fixed the problem. So I guess it is time to take a break and eat.
15.2.4.1 Corrupted MyISAM Tables
Even though the MyISAM table format is very reliable (all changes to a table made by an SQL statement are written before the statement returns), you can still get corrupted tables if any of the following events occur:
The mysqld process is killed in the middle of a write.
An unexpected computer shutdown occurs (for example, the computer is turned off).
Hardware failures.
You are using an external program (such as myisamchk) to modify a table that is being modified by the server at the same time.
A software bug in the MySQL or MyISAM code.
Subject
Written By
Posted
Re: Corruptions like crazy
April 29, 2015 02:00PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.