<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="innochecksum">
      </a>
      6.6.2 innochecksum — Offline InnoDB File Checksum Utility
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045308294976">
  </a>
  <p>
   <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
    <span class="command">
     <strong>
      innochecksum
     </strong>
    </span>
   </a>
   prints checksums for
   <code class="literal">
    InnoDB
   </code>
   files. This tool reads an
   <code class="literal">
    InnoDB
   </code>
   tablespace file, calculates the
        checksum for each page, compares the calculated checksum to the
        stored checksum, and reports mismatches, which indicate damaged
        pages. It was originally developed to speed up verifying the
        integrity of tablespace files after power outages but can also
        be used after file copies. Because checksum mismatches cause
   <code class="literal">
    InnoDB
   </code>
   to deliberately shut down a running
        server, it may be preferable to use this tool rather than
        waiting for an in-production server to encounter the damaged
        pages.
  </p>
  <p>
   <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
    <span class="command">
     <strong>
      innochecksum
     </strong>
    </span>
   </a>
   cannot be used on tablespace
        files that the server already has open. For such files, you
        should use
   <a class="link" href="check-table.html" title="15.7.3.2 CHECK TABLE Statement">
    <code class="literal">
     CHECK TABLE
    </code>
   </a>
   to check
        tables within the tablespace. Attempting to run
   <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
    <span class="command">
     <strong>
      innochecksum
     </strong>
    </span>
   </a>
   on a tablespace that the server
        already has open results in an
   <span class="errortext">
    Unable to lock
        file
   </span>
   error.
  </p>
  <p>
   If checksum mismatches are found, restore the tablespace from
        backup or start the server and attempt to use
   <a class="link" href="mysqldump.html" title="6.5.4 mysqldump — A Database Backup Program">
    <span class="command">
     <strong>
      mysqldump
     </strong>
    </span>
   </a>
   to make a backup of the tables
        within the tablespace.
  </p>
  <p>
   Invoke
   <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
    <span class="command">
     <strong>
      innochecksum
     </strong>
    </span>
   </a>
   like this:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa92547492"><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">innochecksum <span class="token punctuation">[</span><em class="replaceable">options</em><span class="token punctuation">]</span> <em class="replaceable">file_name</em></code></pre>
  </div>
  <h4>
   <a name="idm46045308279552">
   </a>
   innochecksum Options
  </h4>
  <p>
   <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
    <span class="command">
     <strong>
      innochecksum
     </strong>
    </span>
   </a>
   supports the following options.
        For options that refer to page numbers, the numbers are
        zero-based.
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a name="option_innochecksum_help">
      </a>
      <a class="link" href="innochecksum.html#option_innochecksum_help">
       <code class="option">
        --help
       </code>
      </a>
      ,
      <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>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           false
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308264304">
     </a>
     <a class="indexterm" name="idm46045308262816">
     </a>
     <p>
      Displays command line help. Example usage:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa53418028"><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">innochecksum <span class="token property">--help</span></code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_innochecksum_info">
      </a>
      <a class="link" href="innochecksum.html#option_innochecksum_info">
       <code class="option">
        --info
       </code>
      </a>
      ,
      <code class="option">
       -I
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for info">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --info
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           false
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308247120">
     </a>
     <a class="indexterm" name="idm46045308245632">
     </a>
     <p>
      Synonym for
      <a class="link" href="innochecksum.html#option_innochecksum_help">
       <code class="option">
        --help
       </code>
      </a>
      .
            Displays command line help. Example usage:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa37445000"><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">innochecksum <span class="token property">--info</span></code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_innochecksum_version">
      </a>
      <a class="link" href="innochecksum.html#option_innochecksum_version">
       <code class="option">
        --version
       </code>
      </a>
      ,
      <code class="option">
       -V
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for version">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --version
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           false
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308229056">
     </a>
     <a class="indexterm" name="idm46045308227568">
     </a>
     <p>
      Displays version information. Example usage:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa52154510"><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">innochecksum <span class="token property">--version</span></code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_innochecksum_verbose">
      </a>
      <a class="link" href="innochecksum.html#option_innochecksum_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>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           false
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308211936">
     </a>
     <a class="indexterm" name="idm46045308210448">
     </a>
     <p>
      Verbose mode; prints a progress indicator to the log file
            every five seconds. In order for the progress indicator to
            be printed, the log file must be specified using the
      <code class="literal">
       --log option
      </code>
      . To turn on
      <code class="literal">
       verbose
      </code>
      mode, run:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa64737922"><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">innochecksum <span class="token property">--verbose</span></code></pre>
     </div>
     <p>
      To turn off verbose mode, run:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa46956508"><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">innochecksum <span class="token constant">--verbose</span><span class="token attr-value"><span class="token punctuation">=</span>FALSE</span></code></pre>
     </div>
     <p>
      The
      <code class="literal">
       --verbose
      </code>
      option and
      <code class="literal">
       --log
      </code>
      option can be specified at the same
            time. For example:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa837397"><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">innochecksum <span class="token property">--verbose</span> <span class="token constant">--log</span><span class="token attr-value"><span class="token punctuation">=</span>/var/lib/mysql/test/logtest.txt</span></code></pre>
     </div>
     <p>
      To locate the progress indicator information in the log
            file, you can perform the following search:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa84540626"><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">cat <span class="token punctuation">.</span>/logtest<span class="token punctuation">.</span>txt | grep <span class="token property">-i</span> <span class="token atrule">"okay"</span></code></pre>
     </div>
     <p>
      The progress indicator information in the log file appears
            similar to the following:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-none"><div class="docs-select-all right" id="sa60791365"><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-none">page 1663 okay: 2.863% done
page 8447 okay: 14.537% done
page 13695 okay: 23.568% done
page 18815 okay: 32.379% done
page 23039 okay: 39.648% done
page 28351 okay: 48.789% done
page 33023 okay: 56.828% done
page 37951 okay: 65.308% done
page 44095 okay: 75.881% done
page 49407 okay: 85.022% done
page 54463 okay: 93.722% done
...</code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_innochecksum_count">
      </a>
      <a class="link" href="innochecksum.html#option_innochecksum_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>
        <tr>
         <th>
          Type
         </th>
         <td>
          Base name
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           true
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308185520">
     </a>
     <a class="indexterm" name="idm46045308184032">
     </a>
     <p>
      Print a count of the number of pages in the file and exit.
            Example usage:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa5353300"><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">innochecksum <span class="token property">--count</span> <span class="token punctuation">.</span><span class="token punctuation">.</span>/data/test/tab1<span class="token punctuation">.</span>ibd</code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_innochecksum_start-page">
      </a>
      <a class="link" href="innochecksum.html#option_innochecksum_start-page">
       <code class="option">
        --start-page=
        <em class="replaceable">
         <code>
          num
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -s
       <em class="replaceable">
        <code>
         num
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for start-page">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --start-page=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308167808">
     </a>
     <a class="indexterm" name="idm46045308166320">
     </a>
     <p>
      Start at this page number. Example usage:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa27963982"><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">innochecksum <span class="token constant">--start-page</span><span class="token attr-value"><span class="token punctuation">=</span>600</span> <span class="token punctuation">.</span><span class="token punctuation">.</span>/data/test/tab1<span class="token punctuation">.</span>ibd</code></pre>
     </div>
     <p>
      or:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa22751730"><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">innochecksum <span class="token property">-s</span> 600 <span class="token punctuation">.</span><span class="token punctuation">.</span>/data/test/tab1<span class="token punctuation">.</span>ibd</code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_innochecksum_end-page">
      </a>
      <a class="link" href="innochecksum.html#option_innochecksum_end-page">
       <code class="option">
        --end-page=
        <em class="replaceable">
         <code>
          num
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -e
       <em class="replaceable">
        <code>
         num
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for end-page">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --end-page=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Numeric
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           18446744073709551615
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308143904">
     </a>
     <a class="indexterm" name="idm46045308142416">
     </a>
     <p>
      End at this page number. Example usage:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa56787347"><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">innochecksum <span class="token constant">--end-page</span><span class="token attr-value"><span class="token punctuation">=</span>700</span> <span class="token punctuation">.</span><span class="token punctuation">.</span>/data/test/tab1<span class="token punctuation">.</span>ibd</code></pre>
     </div>
     <p>
      or:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa56307808"><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">innochecksum <span class="token property">--p</span> 700 <span class="token punctuation">.</span><span class="token punctuation">.</span>/data/test/tab1<span class="token punctuation">.</span>ibd</code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_innochecksum_page">
      </a>
      <a class="link" href="innochecksum.html#option_innochecksum_page">
       <code class="option">
        --page=
        <em class="replaceable">
         <code>
          num
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -p
       <em class="replaceable">
        <code>
         num
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for page">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --page=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308124784">
     </a>
     <a class="indexterm" name="idm46045308123296">
     </a>
     <p>
      Check only this page number. Example usage:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa75565741"><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">innochecksum <span class="token constant">--page</span><span class="token attr-value"><span class="token punctuation">=</span>701</span> <span class="token punctuation">.</span><span class="token punctuation">.</span>/data/test/tab1<span class="token punctuation">.</span>ibd</code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_innochecksum_strict-check">
      </a>
      <a class="link" href="innochecksum.html#option_innochecksum_strict-check">
       <code class="option">
        --strict-check
       </code>
      </a>
      ,
      <code class="option">
       -C
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for strict-check">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --strict-check=algorithm
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Enumeration
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           crc32
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Valid Values
         </th>
         <td>
          <p class="valid-value">
           <code class="literal">
            innodb
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            crc32
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            none
           </code>
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308102944">
     </a>
     <a class="indexterm" name="idm46045308101456">
     </a>
     <p>
      Specify a strict checksum algorithm. Options include
      <code class="literal">
       innodb
      </code>
      ,
      <code class="literal">
       crc32
      </code>
      , and
      <code class="literal">
       none
      </code>
      .
     </p>
     <p>
      In this example, the
      <code class="literal">
       innodb
      </code>
      checksum
            algorithm is specified:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa25479592"><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">innochecksum <span class="token constant">--strict-check</span><span class="token attr-value"><span class="token punctuation">=</span>innodb</span> <span class="token punctuation">.</span><span class="token punctuation">.</span>/data/test/tab1<span class="token punctuation">.</span>ibd</code></pre>
     </div>
     <p>
      In this example, the
      <code class="literal">
       crc32
      </code>
      checksum
            algorithm is specified:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa78778271"><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">innochecksum <span class="token property">-C</span> crc32 <span class="token punctuation">.</span><span class="token punctuation">.</span>/data/test/tab1<span class="token punctuation">.</span>ibd</code></pre>
     </div>
     <p>
      The following conditions apply:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         If you do not specify the
         <a class="link" href="innochecksum.html#option_innochecksum_strict-check">
          <code class="option">
           --strict-check
          </code>
         </a>
         option,
         <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
          <span class="command">
           <strong>
            innochecksum
           </strong>
          </span>
         </a>
         validates
                against
         <code class="literal">
          innodb
         </code>
         ,
         <code class="literal">
          crc32
         </code>
         and
         <code class="literal">
          none
         </code>
         .
        </p>
       </li>
       <li class="listitem">
        <p>
         If you specify the
         <code class="literal">
          none
         </code>
         option, only
                checksums generated by
         <code class="literal">
          none
         </code>
         are
                allowed.
        </p>
       </li>
       <li class="listitem">
        <p>
         If you specify the
         <code class="literal">
          innodb
         </code>
         option,
                only checksums generated by
         <code class="literal">
          innodb
         </code>
         are allowed.
        </p>
       </li>
       <li class="listitem">
        <p>
         If you specify the
         <code class="literal">
          crc32
         </code>
         option, only
                checksums generated by
         <code class="literal">
          crc32
         </code>
         are
                allowed.
        </p>
       </li>
      </ul>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_innochecksum_no-check">
      </a>
      <a class="link" href="innochecksum.html#option_innochecksum_no-check">
       <code class="option">
        --no-check
       </code>
      </a>
      ,
      <code class="option">
       -n
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for no-check">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --no-check
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           false
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308067200">
     </a>
     <a class="indexterm" name="idm46045308065712">
     </a>
     <p>
      Ignore the checksum verification when rewriting a checksum.
            This option may only be used with the
      <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
       <span class="command">
        <strong>
         innochecksum
        </strong>
       </span>
      </a>
      <a class="link" href="innochecksum.html#option_innochecksum_write">
       <code class="option">
        --write
       </code>
      </a>
      option. If the
      <a class="link" href="innochecksum.html#option_innochecksum_write">
       <code class="option">
        --write
       </code>
      </a>
      option is not
            specified,
      <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
       <span class="command">
        <strong>
         innochecksum
        </strong>
       </span>
      </a>
      terminates.
     </p>
     <p>
      In this example, an
      <code class="literal">
       innodb
      </code>
      checksum is
            rewritten to replace an invalid checksum:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa54829348"><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">innochecksum <span class="token property">--no-check</span> <span class="token property">--write</span> innodb <span class="token punctuation">.</span><span class="token punctuation">.</span>/data/test/tab1<span class="token punctuation">.</span>ibd</code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_innochecksum_allow-mismatches">
      </a>
      <a class="link" href="innochecksum.html#option_innochecksum_allow-mismatches">
       <code class="option">
        --allow-mismatches
       </code>
      </a>
      ,
      <code class="option">
       -a
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for allow-mismatches">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --allow-mismatches=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           18446744073709551615
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308039328">
     </a>
     <a class="indexterm" name="idm46045308037840">
     </a>
     <p>
      The maximum number of checksum mismatches allowed before
      <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
       <span class="command">
        <strong>
         innochecksum
        </strong>
       </span>
      </a>
      terminates. The default
            setting is 0. If
      <code class="literal">
       --allow-mismatches=
      </code>
      <em class="replaceable">
       <code>
        N
       </code>
      </em>
      ,
            where
      <code class="literal">
       <em class="replaceable">
        <code>
         N
        </code>
       </em>
       &gt;=0
      </code>
      ,
      <em class="replaceable">
       <code>
        N
       </code>
      </em>
      mismatches are permitted and
      <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
       <span class="command">
        <strong>
         innochecksum
        </strong>
       </span>
      </a>
      terminates at
      <code class="literal">
       <em class="replaceable">
        <code>
         N
        </code>
       </em>
       +1
      </code>
      . When
      <code class="literal">
       --allow-mismatches
      </code>
      is set to 0,
      <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
       <span class="command">
        <strong>
         innochecksum
        </strong>
       </span>
      </a>
      terminates on the first
            checksum mismatch.
     </p>
     <p>
      In this example, an existing
      <code class="literal">
       innodb
      </code>
      checksum is rewritten to set
      <code class="literal">
       --allow-mismatches
      </code>
      to 1.
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa75598211"><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">innochecksum <span class="token constant">--allow-mismatches</span><span class="token attr-value"><span class="token punctuation">=</span>1</span> <span class="token property">--write</span> innodb <span class="token punctuation">.</span><span class="token punctuation">.</span>/data/test/tab1<span class="token punctuation">.</span>ibd</code></pre>
     </div>
     <p>
      With
      <code class="literal">
       --allow-mismatches
      </code>
      set to 1, if
            there is a mismatch at page 600 and another at page 700 on a
            file with 1000 pages, the checksum is updated for pages
            0-599 and 601-699. Because
      <code class="literal">
       --allow-mismatches
      </code>
      is set to 1, the
            checksum tolerates the first mismatch and terminates on the
            second mismatch, leaving page 600 and pages 700-999
            unchanged.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_innochecksum_write">
      </a>
      <a class="link" href="innochecksum.html#option_innochecksum_write">
       <code class="option">
        --write=
        <em class="replaceable">
         <code>
          name
         </code>
        </em>
       </code>
      </a>
      ,
      <code class="option">
       -w
       <em class="replaceable">
        <code>
         num
        </code>
       </em>
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for write">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --write=algorithm
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Enumeration
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           crc32
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Valid Values
         </th>
         <td>
          <p class="valid-value">
           <code class="literal">
            innodb
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            crc32
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            none
           </code>
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045308004816">
     </a>
     <a class="indexterm" name="idm46045308003328">
     </a>
     <p>
      Rewrite a checksum. When rewriting an invalid checksum, the
      <a class="link" href="innochecksum.html#option_innochecksum_no-check">
       <code class="option">
        --no-check
       </code>
      </a>
      option must
            be used together with the
      <code class="option">
       --write
      </code>
      option.
            The
      <a class="link" href="innochecksum.html#option_innochecksum_no-check">
       <code class="option">
        --no-check
       </code>
      </a>
      option
            tells
      <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
       <span class="command">
        <strong>
         innochecksum
        </strong>
       </span>
      </a>
      to ignore verification
            of the invalid checksum. You do not have to specify the
      <a class="link" href="innochecksum.html#option_innochecksum_no-check">
       <code class="option">
        --no-check
       </code>
      </a>
      option if
            the current checksum is valid.
     </p>
     <p>
      An algorithm must be specified when using the
      <a class="link" href="innochecksum.html#option_innochecksum_write">
       <code class="option">
        --write
       </code>
      </a>
      option.
            Possible values for the
      <code class="option">
       --write
      </code>
      option are:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         <code class="literal">
          innodb
         </code>
         : A checksum calculated in
                software, using the original algorithm from
         <code class="literal">
          InnoDB
         </code>
         .
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          crc32
         </code>
         : A checksum calculated using
                the
         <code class="literal">
          crc32
         </code>
         algorithm, possibly done
                with a hardware assist.
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          none
         </code>
         : A constant number.
        </p>
       </li>
      </ul>
     </div>
     <p>
      The
      <code class="option">
       --write
      </code>
      option rewrites entire pages to
            disk. If the new checksum is identical to the existing
            checksum, the new checksum is not written to disk in order
            to minimize I/O.
     </p>
     <p>
      <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
       <span class="command">
        <strong>
         innochecksum
        </strong>
       </span>
      </a>
      obtains an exclusive lock
            when the
      <code class="option">
       --write
      </code>
      option is used.
     </p>
     <p>
      In this example, a
      <code class="literal">
       crc32
      </code>
      checksum is
            written for
      <code class="filename">
       tab1.ibd
      </code>
      :
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa72081089"><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">innochecksum <span class="token property">-w</span> crc32 <span class="token punctuation">.</span><span class="token punctuation">.</span>/data/test/tab1<span class="token punctuation">.</span>ibd</code></pre>
     </div>
     <p>
      In this example, a
      <code class="literal">
       crc32
      </code>
      checksum is
            rewritten to replace an invalid
      <code class="literal">
       crc32
      </code>
      checksum:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa38722040"><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">innochecksum <span class="token property">--no-check</span> <span class="token property">--write</span> crc32 <span class="token punctuation">.</span><span class="token punctuation">.</span>/data/test/tab1<span class="token punctuation">.</span>ibd</code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_innochecksum_page-type-summary">
      </a>
      <a class="link" href="innochecksum.html#option_innochecksum_page-type-summary">
       <code class="option">
        --page-type-summary
       </code>
      </a>
      ,
      <code class="option">
       -S
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for page-type-summary">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --page-type-summary
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Boolean
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           false
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045307966416">
     </a>
     <a class="indexterm" name="idm46045307964912">
     </a>
     <p>
      Display a count of each page type in a tablespace. Example
            usage:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa74724036"><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">innochecksum <span class="token property">--page-type-summary</span> <span class="token punctuation">.</span><span class="token punctuation">.</span>/data/test/tab1<span class="token punctuation">.</span>ibd</code></pre>
     </div>
     <p>
      Sample output for
      <code class="literal">
       --page-type-summary
      </code>
      :
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-none"><div class="docs-select-all right" id="sa62446489"><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-none">File::../data/test/tab1.ibd
================PAGE TYPE SUMMARY==============
#PAGE_COUNT PAGE_TYPE
===============================================
       2        Index page
       0        Undo log page
       1        Inode page
       0        Insert buffer free list page
       2        Freshly allocated page
       1        Insert buffer bitmap
       0        System page
       0        Transaction system page
       1        File Space Header
       0        Extent descriptor page
       0        BLOB page
       0        Compressed BLOB page
       0        Other type of page
===============================================
Additional information:
Undo page type: 0 insert, 0 update, 0 other
Undo page state: 0 active, 0 cached, 0 to_free, 0 to_purge, 0 prepared, 0 other</code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_innochecksum_page-type-dump">
      </a>
      <a class="link" href="innochecksum.html#option_innochecksum_page-type-dump">
       <code class="option">
        --page-type-dump
       </code>
      </a>
      ,
      <code class="option">
       -D
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for page-type-dump">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --page-type-dump=name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045307947040">
     </a>
     <a class="indexterm" name="idm46045307945552">
     </a>
     <p>
      Dump the page type information for each page in a tablespace
            to
      <code class="literal">
       stderr
      </code>
      or
      <code class="literal">
       stdout
      </code>
      .
            Example usage:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa66635377"><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">innochecksum <span class="token constant">--page-type-dump</span><span class="token attr-value"><span class="token punctuation">=</span>/tmp/a.txt</span> <span class="token punctuation">.</span><span class="token punctuation">.</span>/data/test/tab1<span class="token punctuation">.</span>ibd</code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_innochecksum_log">
      </a>
      <a class="link" href="innochecksum.html#option_innochecksum_log">
       <code class="option">
        --log
       </code>
      </a>
      ,
      <code class="option">
       -l
      </code>
     </p>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for log">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --log=path
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          File name
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <a class="indexterm" name="idm46045307928496">
     </a>
     <a class="indexterm" name="idm46045307927008">
     </a>
     <p>
      Log output for the
      <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
       <span class="command">
        <strong>
         innochecksum
        </strong>
       </span>
      </a>
      tool. A
            log file name must be provided. Log output contains checksum
            values for each tablespace page. For uncompressed tables,
            LSN values are also provided. Example usage:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa10769239"><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">innochecksum <span class="token constant">--log</span><span class="token attr-value"><span class="token punctuation">=</span>/tmp/log.txt</span> <span class="token punctuation">.</span><span class="token punctuation">.</span>/data/test/tab1<span class="token punctuation">.</span>ibd</code></pre>
     </div>
     <p>
      or:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa37192702"><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">innochecksum <span class="token property">-l</span> /tmp/log<span class="token punctuation">.</span>txt <span class="token punctuation">.</span><span class="token punctuation">.</span>/data/test/tab1<span class="token punctuation">.</span>ibd</code></pre>
     </div>
    </li>
    <li class="listitem">
     <p>
      <a name="option_innochecksum_read-from-standard-in">
      </a>
      <code class="literal">
       -
      </code>
      option.
     </p>
     <a class="indexterm" name="idm46045307919216">
     </a>
     <a class="indexterm" name="idm46045307917712">
     </a>
     <p>
      Specify the
      <code class="literal">
       -
      </code>
      option to read from
            standard input. If the
      <code class="literal">
       -
      </code>
      option is
            missing when
      <span class="quote">
       “
       <span class="quote">
        read from standard in
       </span>
       ”
      </span>
      is
            expected,
      <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
       <span class="command">
        <strong>
         innochecksum
        </strong>
       </span>
      </a>
      prints
      <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
       <span class="command">
        <strong>
         innochecksum
        </strong>
       </span>
      </a>
      usage information indicating
            that the
      <span class="quote">
       “
       <span class="quote">
        -
       </span>
       ”
      </span>
      option was omitted. Example
            usages:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa40380611"><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">cat t1<span class="token punctuation">.</span>ibd | innochecksum -</code></pre>
     </div>
     <p>
      In this example,
      <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
       <span class="command">
        <strong>
         innochecksum
        </strong>
       </span>
      </a>
      writes the
      <code class="literal">
       crc32
      </code>
      checksum algorithm to
      <code class="filename">
       a.ibd
      </code>
      without changing the original
      <code class="filename">
       t1.ibd
      </code>
      file.
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa57707235"><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">cat t1<span class="token punctuation">.</span>ibd | innochecksum <span class="token constant">--write</span><span class="token attr-value"><span class="token punctuation">=</span>crc32</span> - &gt; a<span class="token punctuation">.</span>ibd</code></pre>
     </div>
    </li>
   </ul>
  </div>
  <h4>
   <a name="idm46045307904848">
   </a>
   Running innochecksum on Multiple User-defined Tablespace Files
  </h4>
  <p>
   The following examples demonstrate how to run
   <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
    <span class="command">
     <strong>
      innochecksum
     </strong>
    </span>
   </a>
   on multiple user-defined
        tablespace files (
   <code class="filename">
    .ibd
   </code>
   files).
  </p>
  <p>
   Run
   <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
    <span class="command">
     <strong>
      innochecksum
     </strong>
    </span>
   </a>
   for all tablespace
        (
   <code class="filename">
    .ibd
   </code>
   ) files in the
   <span class="quote">
    “
    <span class="quote">
     test
    </span>
    ”
   </span>
   database:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa5843890"><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">innochecksum <span class="token punctuation">.</span>/data/test/*<span class="token punctuation">.</span>ibd</code></pre>
  </div>
  <p>
   Run
   <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
    <span class="command">
     <strong>
      innochecksum
     </strong>
    </span>
   </a>
   for all tablespace files
        (
   <code class="filename">
    .ibd
   </code>
   files) that have a file name starting
        with
   <span class="quote">
    “
    <span class="quote">
     t
    </span>
    ”
   </span>
   :
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa77466648"><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">innochecksum <span class="token punctuation">.</span>/data/test/t*<span class="token punctuation">.</span>ibd</code></pre>
  </div>
  <p>
   Run
   <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
    <span class="command">
     <strong>
      innochecksum
     </strong>
    </span>
   </a>
   for all tablespace files
        (
   <code class="filename">
    .ibd
   </code>
   files) in the
   <code class="filename">
    data
   </code>
   directory:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa81499900"><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">innochecksum <span class="token punctuation">.</span>/data/*/*<span class="token punctuation">.</span>ibd</code></pre>
  </div>
  <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
   <div class="admon-title">
    Note
   </div>
   <p>
    Running
    <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
     <span class="command">
      <strong>
       innochecksum
      </strong>
     </span>
    </a>
    on multiple
          user-defined tablespace files is not supported on Windows
          operating systems, as Windows shells such as
    <span class="command">
     <strong>
      cmd.exe
     </strong>
    </span>
    do not support glob pattern
          expansion. On Windows systems,
    <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
     <span class="command">
      <strong>
       innochecksum
      </strong>
     </span>
    </a>
    must be run separately for each user-defined tablespace file.
          For example:
   </p>
   <div class="copytoclipboard-wrapper">
    <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa21629920"><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">innochecksum<span class="token punctuation">.</span>exe t1<span class="token punctuation">.</span>ibd
innochecksum<span class="token punctuation">.</span>exe t2<span class="token punctuation">.</span>ibd
innochecksum<span class="token punctuation">.</span>exe t3<span class="token punctuation">.</span>ibd</code></pre>
   </div>
  </div>
  <h4>
   <a name="idm46045307884576">
   </a>
   Running innochecksum on Multiple System Tablespace Files
  </h4>
  <p>
   By default, there is only one
   <code class="literal">
    InnoDB
   </code>
   system
        tablespace file (
   <code class="filename">
    ibdata1
   </code>
   ) but multiple
        files for the system tablespace can be defined using the
   <a class="link" href="innodb-parameters.html#sysvar_innodb_data_file_path">
    <code class="literal">
     innodb_data_file_path
    </code>
   </a>
   option.
        In the following example, three files for the system tablespace
        are defined using the
   <a class="link" href="innodb-parameters.html#sysvar_innodb_data_file_path">
    <code class="literal">
     innodb_data_file_path
    </code>
   </a>
   option:
   <code class="filename">
    ibdata1
   </code>
   ,
   <code class="filename">
    ibdata2
   </code>
   , and
   <code class="filename">
    ibdata3
   </code>
   .
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa32209107"><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"><span class="token punctuation">.</span>/bin/mysqld <span class="token property">--no-defaults</span> <span class="token constant">--innodb-data-file-path</span>=<span class="token atrule">"ibdata1:10M;ibdata2:10M;ibdata3:10M:autoextend"</span></code></pre>
  </div>
  <p>
   The three files (
   <code class="filename">
    ibdata1
   </code>
   ,
   <code class="filename">
    ibdata2
   </code>
   , and
   <code class="filename">
    ibdata3
   </code>
   )
        form one logical system tablespace. To run
   <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
    <span class="command">
     <strong>
      innochecksum
     </strong>
    </span>
   </a>
   on multiple files that form one
        logical system tablespace,
   <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
    <span class="command">
     <strong>
      innochecksum
     </strong>
    </span>
   </a>
   requires the
   <code class="literal">
    -
   </code>
   option to read tablespace
        files in from standard input, which is equivalent to
        concatenating multiple files to create one single file. For the
        example provided above, the following
   <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
    <span class="command">
     <strong>
      innochecksum
     </strong>
    </span>
   </a>
   command would be used:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa81951293"><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">cat ibdata* | innochecksum -</code></pre>
  </div>
  <p>
   Refer to the
   <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
    <span class="command">
     <strong>
      innochecksum
     </strong>
    </span>
   </a>
   options information
        for more information about the
   <span class="quote">
    “
    <span class="quote">
     -
    </span>
    ”
   </span>
   option.
  </p>
  <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
   <div class="admon-title">
    Note
   </div>
   <p>
    Running
    <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
     <span class="command">
      <strong>
       innochecksum
      </strong>
     </span>
    </a>
    on multiple files in
          the same tablespace is not supported on Windows operating
          systems, as Windows shells such as
    <span class="command">
     <strong>
      cmd.exe
     </strong>
    </span>
    do not support glob pattern expansion. On Windows systems,
    <a class="link" href="innochecksum.html" title="6.6.2 innochecksum — Offline InnoDB File Checksum Utility">
     <span class="command">
      <strong>
       innochecksum
      </strong>
     </span>
    </a>
    must be run separately for
          each system tablespace file. For example:
   </p>
   <div class="copytoclipboard-wrapper">
    <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa83208852"><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">innochecksum<span class="token punctuation">.</span>exe ibdata1
innochecksum<span class="token punctuation">.</span>exe ibdata2
innochecksum<span class="token punctuation">.</span>exe ibdata3</code></pre>
   </div>
  </div>
 </div>
 <br/>
</div>
