(mysql.info.gz) Corrupted MyISAM tables

(mysql.info.gz) MyISAM table problems

(mysql.info.gz) MyISAM table close

 
 14.1.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 some of the following
 things happen:
 
    * The `mysqld' process is killed in the middle of a write.
 
    * Unexpected computer shutdown occurs (for example, the computer is
      turned off).
 
    * Hardware errors.
 
    * You are using an external program (such as `myisamchk') on a table
      that is being modified by the server at the same time.
 
    * A software bug in the MySQL or `MyISAM' code.
 
 
 Typical symptoms for a corrupt table are:
 
    * You get the following error while selecting data from the table:
 
           Incorrect key file for table: '...'. Try to repair it
 
    * Queries don't find rows in the table or return incomplete data.
 
 
 You can check whether a `MyISAM' table is okay with the `CHECK TABLE'
 statement.  You can repair a corrupted `MyISAM' table with `REPAIR
 TABLE'.  When `mysqld' is not running, you can also check or repair a
 table with the `myisamchk' command.  See  `CHECK TABLE' CHECK
 TABLE,  `REPAIR TABLE' REPAIR TABLE, and  myisamchk syntax.
 
 If your tables become corrupted frequently, you should try to determine
 why this is happening.  The most important thing to know is whether the
 table became corrupted as a result of a server crash. You can verify
 this easily by looking for a recent `restarted mysqld' message in the
 error log.  If there is such a message, it is likely that table
 corruption is a result of the server dying.  Otherwise, corruption may
 have occurred during normal operation, which is a bug. You should try
 to create a reproducible test case that demonstrates the problem.  See
  Crashing and  Reproduceable test case.

Info Catalog

(mysql.info.gz) MyISAM table problems

(mysql.info.gz) MyISAM table close

automatically generated byinfo2html