myisamchk — MyISAM Table-Maintenance Utility myisam_ftdump mytexttable 1 If the path name to the  test  database directory is  /usr/local/mysql/data/test , you can also specify the table name argument using that path name. This is useful if you do not invoke myisam_ftdump  in the database directory: myisam_ftdump /usr/local/mysql/data/test/mytexttable 1 You can use  myisam_ftdump  to generate a list of index entries in order of frequency of occurrence like this on Unix-like systems: myisam_ftdump -c mytexttable 1 | sort -r On Windows, use: myisam_ftdump -c mytexttable 1 | sort /R myisam_ftdump  supports the following options: Display a help message and exit. Calculate per-word statistics (counts and global weights). Dump the index, including data offsets and word weights. Report the length distribution. Report global index statistics. This is the default operation if no other operation is specified. Verbose mode. Print more output about what the program does. The  myisamchk  utility gets information about your database tables or checks, repairs, or optimizes them.  myisamchk  works with  MyISAM  tables (tables that have  .MYD  and  .MYI  files for storing data and indexes). You can also use the  CHECK TABLE  and  REPAIR TABLE  statements to check and repair  MyISAM  tables. See Section 13.7.3.2, “CHECK TABLE Statement” , and Section 13.7.3.5, “REPAIR TABLE Statement” . The use of  myisamchk  with partitioned tables is not supported. It is best to make a backup of a table before performing a table repair operation; under some circumstances the operation might cause data loss. Possible causes include but are not limited to file system errors. • --help ,  -h -? • --count ,  -c • --dump ,  -d • --length ,  -l • --stats ,  -s • --verbose ,  -v 4.6.4 myisamchk — MyISAM Table-Maintenance Utility Caution 561