myisamchk — MyISAM Table-Maintenance Utility This means that you are trying to check a table that has been updated by another program (such as the  mysqld  server) that hasn’t yet closed the file or that has died without closing the file properly, which can sometimes lead to the corruption of one or more  MyISAM  tables. If  mysqld  is running, you must force it to flush any table modifications that are still buffered in memory by using  FLUSH TABLES . You should then ensure that no one is using the tables while you are running  myisamchk However, the easiest way to avoid this problem is to use  CHECK TABLE  instead of myisamchk  to check tables. See Section 13.7.3.2, “CHECK TABLE Statement” . myisamchk  supports the following options, which can be specified on the command line or in the [myisamchk]  group of an option file. For information about option files used by MySQL programs, see Section 4.2.2.2, “Using Option Files” . Table 4.19 myisamchk Options Option Name Description --analyze Analyze the distribution of key values --backup Make a backup of the .MYD file as file_name- time.BAK --block-search Find the record that a block at the given offset belongs to --check Check the table for errors --check-only-changed Check only tables that have changed since the last check --correct-checksum Correct the checksum information for the table --data-file-length Maximum length of the data file (when re-creating data file when it is full) --debug Write debugging log --decode_bits Decode_bits --defaults-extra-file Read named option file in addition to usual option files --defaults-file Read only named option file --defaults-group-suffix Option group suffix value --description Print some descriptive information about the table --extend-check Do very thorough table check or repair that tries to recover every possible row from the data file --fast Check only tables that haven’t been closed properly --force Do a repair operation automatically if myisamchk finds any errors in the table --force Overwrite old temporary files. For use with the -r or - o option --ft_max_word_len Maximum word length for FULLTEXT indexes --ft_min_word_len Minimum word length for FULLTEXT indexes --ft_stopword_file Use stopwords from this file instead of built-in list 563