content_image/857703.jpg
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: 

• --help , -h -? 

Display a help message and exit. 

• --count , -c 

Calculate per-word statistics (counts and global weights). 

• --dump , -d 

Dump the index, including data offsets and word weights. 

• --length , -l 

Report the length distribution. 

• --stats , -s 

Report global index statistics. This is the default operation if no other operation is specified. 

• --verbose , -v 

Verbose mode. Print more output about what the program does. 

## 4.6.4 myisamchk — MyISAM Table-Maintenance Utility 

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. 

<img src='content_image/857703.jpg'>

## Caution 

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. 

