DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info) check

Info Catalog (mysql.info) crash-recovery (mysql.info) table-maintenance (mysql.info) repair
 
 5.10.4.2 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 cannot 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 the -s (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 key values 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 -v (verbose) option. This
      causes `myisamchk' to keep going, up through a maximum of 20
      errors.
 
    * `myisamchk -e -i TBL_NAME'
 
      This is like the previous command, but the -i option tells
      `myisamchk' to print additional statistical information.
 
 In most cases, a simple `myisamchk' command with no arguments other
 than the table name is sufficient to check a table.
 
Info Catalog (mysql.info) crash-recovery (mysql.info) table-maintenance (mysql.info) repair
automatically generated byinfo2html