<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="myisam-ftdump">
      </a>
      6.6.3 myisam_ftdump — Display Full-Text Index information
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045307859232">
  </a>
  <p>
   <a class="link" href="myisam-ftdump.html" title="6.6.3 myisam_ftdump — Display Full-Text Index information">
    <span class="command">
     <strong>
      myisam_ftdump
     </strong>
    </span>
   </a>
   displays information about
   <code class="literal">
    FULLTEXT
   </code>
   indexes in
   <code class="literal">
    MyISAM
   </code>
   tables. It reads the
   <code class="literal">
    MyISAM
   </code>
   index file
        directly, so it must be run on the server host where the table
        is located. Before using
   <a class="link" href="myisam-ftdump.html" title="6.6.3 myisam_ftdump — Display Full-Text Index information">
    <span class="command">
     <strong>
      myisam_ftdump
     </strong>
    </span>
   </a>
   , be
        sure to issue a
   <code class="literal">
    FLUSH TABLES
   </code>
   statement first
        if the server is running.
  </p>
  <p>
   <a class="link" href="myisam-ftdump.html" title="6.6.3 myisam_ftdump — Display Full-Text Index information">
    <span class="command">
     <strong>
      myisam_ftdump
     </strong>
    </span>
   </a>
   scans and dumps the entire
        index, which is not particularly fast. On the other hand, the
        distribution of words changes infrequently, so it need not be
        run often.
  </p>
  <p>
   Invoke
   <a class="link" href="myisam-ftdump.html" title="6.6.3 myisam_ftdump — Display Full-Text Index information">
    <span class="command">
     <strong>
      myisam_ftdump
     </strong>
    </span>
   </a>
   like this:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa40674197"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal">myisam_ftdump <span class="token punctuation">[</span><em class="replaceable">options</em><span class="token punctuation">]</span> <em class="replaceable">tbl_name</em> <em class="replaceable">index_num</em></code></pre>
  </div>
  <p>
   The
   <em class="replaceable">
    <code>
     tbl_name
    </code>
   </em>
   argument should be the
        name of a
   <code class="literal">
    MyISAM
   </code>
   table. You can also specify
        a table by naming its index file (the file with the
   <code class="filename">
    .MYI
   </code>
   suffix). If you do not invoke
   <a class="link" href="myisam-ftdump.html" title="6.6.3 myisam_ftdump — Display Full-Text Index information">
    <span class="command">
     <strong>
      myisam_ftdump
     </strong>
    </span>
   </a>
   in the directory where the
        table files are located, the table or index file name must be
        preceded by the path name to the table's database directory.
        Index numbers begin with 0.
  </p>
  <p>
   Example: Suppose that the
   <code class="literal">
    test
   </code>
   database
        contains a table named
   <code class="literal">
    mytexttable
   </code>
   that has
        the following definition:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa25498958"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token keyword">CREATE</span> <span class="token keyword">TABLE</span> mytexttable
<span class="token punctuation">(</span>
  id   <span class="token datatype">INT</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span><span class="token punctuation">,</span>
  txt  <span class="token datatype">TEXT</span> <span class="token operator">NOT</span> <span class="token boolean">NULL</span><span class="token punctuation">,</span>
  <span class="token keyword">PRIMARY</span> <span class="token keyword">KEY</span> <span class="token punctuation">(</span>id<span class="token punctuation">)</span><span class="token punctuation">,</span>
  <span class="token keyword">FULLTEXT</span> <span class="token punctuation">(</span>txt<span class="token punctuation">)</span>
<span class="token punctuation">)</span> <span class="token keyword">ENGINE</span><span class="token operator">=</span>MyISAM<span class="token punctuation">;</span></code></pre>
  </div>
  <p>
   The index on
   <code class="literal">
    id
   </code>
   is index 0 and the
   <code class="literal">
    FULLTEXT
   </code>
   index on
   <code class="literal">
    txt
   </code>
   is
        index 1. If your working directory is the
   <code class="literal">
    test
   </code>
   database directory, invoke
   <a class="link" href="myisam-ftdump.html" title="6.6.3 myisam_ftdump — Display Full-Text Index information">
    <span class="command">
     <strong>
      myisam_ftdump
     </strong>
    </span>
   </a>
   as follows:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa30774849"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal">myisam_ftdump mytexttable 1</code></pre>
  </div>
  <p>
   If the path name to the
   <code class="literal">
    test
   </code>
   database
        directory is
   <code class="filename">
    /usr/local/mysql/data/test
   </code>
   ,
        you can also specify the table name argument using that path
        name. This is useful if you do not invoke
   <a class="link" href="myisam-ftdump.html" title="6.6.3 myisam_ftdump — Display Full-Text Index information">
    <span class="command">
     <strong>
      myisam_ftdump
     </strong>
    </span>
   </a>
   in the database directory:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa21727029"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal">myisam_ftdump /usr/local/mysql/data/test/mytexttable 1</code></pre>
  </div>
  <p>
   You can use
   <a class="link" href="myisam-ftdump.html" title="6.6.3 myisam_ftdump — Display Full-Text Index information">
    <span class="command">
     <strong>
      myisam_ftdump
     </strong>
    </span>
   </a>
   to generate a list
        of index entries in order of frequency of occurrence like this
        on Unix-like systems:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa34041109"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal">myisam_ftdump <span class="token property">-c</span> mytexttable 1 | sort <span class="token property">-r</span></code></pre>
  </div>
  <p>
   On Windows, use:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa421994"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-terminal">myisam_ftdump <span class="token property">-c</span> mytexttable 1 | sort /R</code></pre>
  </div>
  <p>
   <a class="link" href="myisam-ftdump.html" title="6.6.3 myisam_ftdump — Display Full-Text Index information">
    <span class="command">
     <strong>
      myisam_ftdump
     </strong>
    </span>
   </a>
   supports the following options:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a name="option_myisam_ftdump_help">
      </a>
      <a class="link" href="myisam-ftdump.html#option_myisam_ftdump_help">
       <code class="option">
        --help
       </code>
      </a>
      ,
      <code class="option">
       -h
      </code>
      <code class="option">
       -?
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for help">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --help
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045307814608">
     </a>
     <a class="indexterm" name="idm46045307813120">
     </a>
     <p>
      Display a help message and exit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_myisam_ftdump_count">
      </a>
      <a class="link" href="myisam-ftdump.html#option_myisam_ftdump_count">
       <code class="option">
        --count
       </code>
      </a>
      ,
      <code class="option">
       -c
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for count">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --count
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045307802944">
     </a>
     <a class="indexterm" name="idm46045307801456">
     </a>
     <p>
      Calculate per-word statistics (counts and global weights).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_myisam_ftdump_dump">
      </a>
      <a class="link" href="myisam-ftdump.html#option_myisam_ftdump_dump">
       <code class="option">
        --dump
       </code>
      </a>
      ,
      <code class="option">
       -d
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for dump">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --dump
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045307791312">
     </a>
     <a class="indexterm" name="idm46045307789824">
     </a>
     <p>
      Dump the index, including data offsets and word weights.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_myisam_ftdump_length">
      </a>
      <a class="link" href="myisam-ftdump.html#option_myisam_ftdump_length">
       <code class="option">
        --length
       </code>
      </a>
      ,
      <code class="option">
       -l
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for length">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --length
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045307779680">
     </a>
     <a class="indexterm" name="idm46045307778192">
     </a>
     <p>
      Report the length distribution.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_myisam_ftdump_stats">
      </a>
      <a class="link" href="myisam-ftdump.html#option_myisam_ftdump_stats">
       <code class="option">
        --stats
       </code>
      </a>
      ,
      <code class="option">
       -s
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for stats">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --stats
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045307768032">
     </a>
     <a class="indexterm" name="idm46045307766544">
     </a>
     <p>
      Report global index statistics. This is the default
            operation if no other operation is specified.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_myisam_ftdump_verbose">
      </a>
      <a class="link" href="myisam-ftdump.html#option_myisam_ftdump_verbose">
       <code class="option">
        --verbose
       </code>
      </a>
      ,
      <code class="option">
       -v
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for verbose">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --verbose
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045307756352">
     </a>
     <a class="indexterm" name="idm46045307754864">
     </a>
     <p>
      Verbose mode. Print more output about what the program does.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
