MySQL 8 Administrator???s Guide

myisam_ftdump - displaying full-text index utility

This is a utility for displaying information about MyISAM tables and FULLTEXT indexes. It will scan and dump the entire index, which can be a slow and lengthy process. If the server is already running, then you need to make sure to insert a FLUSH TABLES statement first.

Execution for the myisam_ftdump command will look like the following code block:

shell> myisam_ftdump [options] <table_name> <index_num>

In the previous example, table_name should be the name of the MyISAM table with the .MYI index extension.

Suppose the test database has a table named mytexttable with the following definition:

CREATE TABLE mytexttable ( id INT NOT NULL, txt TEXT NOT NULL, PRIMARY KEY (id), FULLTEXT (txt) ...