always circumstances that may cause database tables to become corrupted.
the SQL statements returns) , you can still get corrupted tables if some of the following
things happens:
7 Unexpected shutdown of the computer (for example, if the computer is turned off).
7 A hardware error.
7 You are using an external program (like myisamchk) on a live table.
7 A software bug in the MySQL or MyISAM code.
TABLE], page 265.
You can repair a corrupted table with REPAIR TABLE. See Section 4.5.5 [REPAIR TABLE],
page 267. You can also repair a table, when mysqld is not running with the myisamchk
command. myisamchk syntax.
If your tables get corrupted a lot you should try to find the reason for this! See Section A.4.1
[Crashing], page 873.
In this case the most important thing to know is if the table got corrupted if the mysqld
died (one can easily verify this by checking if there is a recent row restarted mysqld in
the mysqld error file). If this isn't the case, then you should try to make a test case of this.
See Section E.1.6 [Reproduceable test case], page 1030.
been closed properly.
If you get the following warning from CHECK TABLE or myisamchk:
corrupted, but means that you should at least do a check on the table to verify that it's
okay.
The counter works as follows:
manual-908.html manual-91.html