{
    "mode": "man",
    "parameter": "myisam_ftdump",
    "section": "1",
    "url": "https://www.chedong.com/phpMan.php/man/myisam_ftdump/1/json",
    "generated": "2026-09-01T12:53:00Z",
    "synopsis": "myisamftdump [options] tblname indexnum",
    "sections": {
        "NAME": {
            "content": "myisamftdump - display full-text index information\n",
            "subsections": []
        },
        "SYNOPSIS": {
            "content": "myisamftdump [options] tblname indexnum\n",
            "subsections": []
        },
        "DESCRIPTION": {
            "content": "myisamftdump displays information about FULLTEXT indexes in MyISAM tables. It reads the\nMyISAM index file directly, so it must be run on the server host where the table is located.\nBefore using myisamftdump, be sure to issue a FLUSH TABLES statement first if the server is\nrunning.\n\nmyisamftdump scans and dumps the entire index, which is not particularly fast. On the other\nhand, the distribution of words changes infrequently, so it need not be run often.\n\nInvoke myisamftdump like this:\n\nmyisamftdump [options] tblname indexnum\n\nThe tblname argument should be the name of a MyISAM table. You can also specify a table by\nnaming its index file (the file with the .MYI suffix). If you do not invoke myisamftdump in\nthe directory where the table files are located, the table or index file name must be\npreceded by the path name to the table's database directory. Index numbers begin with 0.\n\nExample: Suppose that the test database contains a table named mytexttable that has the\nfollowing definition:\n\nCREATE TABLE mytexttable\n(\nid   INT NOT NULL,\ntxt  TEXT NOT NULL,\nPRIMARY KEY (id),\nFULLTEXT (txt)\n) ENGINE=MyISAM;\n\nThe index on id is index 0 and the FULLTEXT index on txt is index 1. If your working\ndirectory is the test database directory, invoke myisamftdump as follows:\n\nmyisamftdump mytexttable 1\n\nIf the path name to the test database directory is /usr/local/mysql/data/test, you can also\nspecify the table name argument using that path name. This is useful if you do not invoke\nmyisamftdump in the database directory:\n\nmyisamftdump /usr/local/mysql/data/test/mytexttable 1\n\nYou can use myisamftdump to generate a list of index entries in order of frequency of\noccurrence like this on Unix-like systems:\n\nmyisamftdump -c mytexttable 1 | sort -r\n\nOn Windows, use:\n\nmyisamftdump -c mytexttable 1 | sort /R\n\nmyisamftdump supports the following options:\n\n•   --help, -h -?\n┌─────────────────────┬────────┐\n│ Command-Line Format │ --help │\n└─────────────────────┴────────┘\n\nDisplay a help message and exit.\n\n•   --count, -c\n┌─────────────────────┬─────────┐\n│ Command-Line Format │ --count │\n└─────────────────────┴─────────┘\n\nCalculate per-word statistics (counts and global weights).\n\n•   --dump, -d\n┌─────────────────────┬────────┐\n│ Command-Line Format │ --dump │\n└─────────────────────┴────────┘\n\nDump the index, including data offsets and word weights.\n\n•   --length, -l\n┌─────────────────────┬──────────┐\n│ Command-Line Format │ --length │\n└─────────────────────┴──────────┘\n\nReport the length distribution.\n\n•   --stats, -s\n┌─────────────────────┬─────────┐\n│ Command-Line Format │ --stats │\n└─────────────────────┴─────────┘\n\nReport global index statistics. This is the default operation if no other operation is\nspecified.\n\n•   --verbose, -v\n┌─────────────────────┬───────────┐\n│ Command-Line Format │ --verbose │\n└─────────────────────┴───────────┘\n\nVerbose mode. Print more output about what the program does.\n",
            "subsections": []
        },
        "COPYRIGHT": {
            "content": "Copyright © 1997, 2026, Oracle and/or its affiliates.\n\nThis documentation is free software; you can redistribute it and/or modify it only under the\nterms of the GNU General Public License as published by the Free Software Foundation; version\n2 of the License.\n\nThis documentation is distributed in the hope that it will be useful, but WITHOUT ANY\nWARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR\nPURPOSE. See the GNU General Public License for more details.\n\nYou should have received a copy of the GNU General Public License along with the program; if\nnot, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA\n02110-1301 USA or see http://www.gnu.org/licenses/.\n\n",
            "subsections": []
        },
        "SEE ALSO": {
            "content": "For more information, please refer to the MySQL Reference Manual, which may already be\ninstalled locally and which is also available online at http://dev.mysql.com/doc/.\n",
            "subsections": []
        },
        "AUTHOR": {
            "content": "Oracle Corporation (http://dev.mysql.com/).\n\nMySQL 8.0                                    03/23/2026                             MYISAMFTDUMP(1)",
            "subsections": []
        }
    },
    "summary": "myisamftdump - display full-text index information",
    "flags": [],
    "examples": [],
    "see_also": []
}