<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="myisamlog">
      </a>
      6.6.5 myisamlog — Display MyISAM Log File Contents
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045306541792">
  </a>
  <p>
   <a class="link" href="myisamlog.html" title="6.6.5 myisamlog — Display MyISAM Log File Contents">
    <span class="command">
     <strong>
      myisamlog
     </strong>
    </span>
   </a>
   processes the contents of a
   <code class="literal">
    MyISAM
   </code>
   log file. To create such a file, start
        the server with a
   <a class="link" href="server-options.html#option_mysqld_log-isam">
    <code class="option">
     --log-isam=
     <code class="filename">
      log_file
     </code>
    </code>
   </a>
   option.
  </p>
  <p>
   Invoke
   <a class="link" href="myisamlog.html" title="6.6.5 myisamlog — Display MyISAM Log File Contents">
    <span class="command">
     <strong>
      myisamlog
     </strong>
    </span>
   </a>
   like this:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa46382698"><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">myisamlog <span class="token punctuation">[</span><em class="replaceable">options</em><span class="token punctuation">]</span> <span class="token punctuation">[</span><em class="replaceable">file_name</em> <span class="token punctuation">[</span><em class="replaceable">tbl_name</em><span class="token punctuation">]</span> <span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">]</span></code></pre>
  </div>
  <p>
   The default operation is update (
   <code class="option">
    -u
   </code>
   ). If a
        recovery is done (
   <code class="option">
    -r
   </code>
   ), all writes and possibly
        updates and deletes are done and errors are only counted. The
        default log file name is
   <code class="filename">
    myisam.log
   </code>
   if no
   <em class="replaceable">
    <code>
     log_file
    </code>
   </em>
   argument is given. If tables
        are named on the command line, only those tables are updated.
  </p>
  <p>
   <a class="link" href="myisamlog.html" title="6.6.5 myisamlog — Display MyISAM Log File Contents">
    <span class="command">
     <strong>
      myisamlog
     </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_myisamlog_help">
      </a>
      <code class="option">
       -?
      </code>
      ,
      <code class="option">
       -I
      </code>
     </p>
     <p>
      Display a help message and exit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_myisamlog_commands">
      </a>
      <code class="option">
       -c
       <em class="replaceable">
        <code>
         N
        </code>
       </em>
      </code>
     </p>
     <p>
      Execute only
      <em class="replaceable">
       <code>
        N
       </code>
      </em>
      commands.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_myisamlog_files">
      </a>
      <code class="option">
       -f
       <em class="replaceable">
        <code>
         N
        </code>
       </em>
      </code>
     </p>
     <p>
      Specify the maximum number of open files.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_myisamlog_filepath">
      </a>
      <code class="option">
       -F
       <em class="replaceable">
        <code>
         filepath/
        </code>
       </em>
      </code>
     </p>
     <p>
      Specify the file path with a trailing slash.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_myisamlog_information">
      </a>
      <code class="option">
       -i
      </code>
     </p>
     <p>
      Display extra information before exiting.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_myisamlog_offset">
      </a>
      <code class="option">
       -o
       <em class="replaceable">
        <code>
         offset
        </code>
       </em>
      </code>
     </p>
     <p>
      Specify the starting offset.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_myisamlog_path">
      </a>
      <code class="option">
       -p
       <em class="replaceable">
        <code>
         N
        </code>
       </em>
      </code>
     </p>
     <p>
      Remove
      <em class="replaceable">
       <code>
        N
       </code>
      </em>
      components from path.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_myisamlog_recovery">
      </a>
      <code class="option">
       -r
      </code>
     </p>
     <p>
      Perform a recovery operation.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_myisamlog_record-position">
      </a>
      <code class="option">
       -R
       <em class="replaceable">
        <code>
         record_pos_file
            record_pos
        </code>
       </em>
      </code>
     </p>
     <p>
      Specify record position file and record position.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_myisamlog_update">
      </a>
      <code class="option">
       -u
      </code>
     </p>
     <p>
      Perform an update operation.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_myisamlog_verbose">
      </a>
      <code class="option">
       -v
      </code>
     </p>
     <p>
      Verbose mode. Print more output about what the program does.
            This option can be given multiple times to produce more and
            more output.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_myisamlog_write">
      </a>
      <code class="option">
       -w
       <em class="replaceable">
        <code>
         write_file
        </code>
       </em>
      </code>
     </p>
     <p>
      Specify the write file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_myisamlog_version">
      </a>
      <code class="option">
       -V
      </code>
     </p>
     <p>
      Display version information.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
