(mysql.info.gz) Check

 
 5.7.3.8 How to Check `MyISAM' Tables for Errors
 ...............................................
 
 To check a `MyISAM' table, use the following commands:
 
 `myisamchk TBL_NAME'
      This finds 99.99% of all errors. What it can't find is corruption
      that involves _only_ the data file (which is very unusual). If you
      want to check a table, you should normally run `myisamchk' without
      options or with either the `-s' or `--silent' option.
 
 `myisamchk -m TBL_NAME'
      This finds 99.999% of all errors. It first checks all index
      entries for errors and then reads through all rows. It calculates
      a checksum for all keys in the rows and verifies that the checksum
      matches the checksum for the keys in the index tree.
 
 `myisamchk -e TBL_NAME'
      This does a complete and thorough check of all data (`-e' means
      "extended check"). It does a check-read of every key for each row
      to verify that they indeed point to the correct row.  This may
      take a long time for a large table that has many indexes.
      Normally, `myisamchk' stops after the first error it finds. If you
      want to obtain more information, you can add the `--verbose'
      (`-v') option.  This causes `myisamchk' to keep going, up through
      a maximum of 20 errors.
 
 `myisamchk -e -i TBL_NAME'
      Like the previous command, but the `-i' option tells `myisamchk' to
      print some informational statistics, too.
 
 
 In most cases, a simple `myisamchk' with no arguments other than the
 table name is sufficient to check a table.

Info Catalog

(mysql.info.gz) Crash recovery

(mysql.info.gz) Table maintenance

(mysql.info.gz) Repair

automatically generated byinfo2html