<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="replication-features-directory">
      </a>
      19.5.1.10 Replication and DIRECTORY Table Options
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045135657568">
  </a>
  <a class="indexterm" name="idm46045135656080">
  </a>
  <a class="indexterm" name="idm46045135654592">
  </a>
  <a class="indexterm" name="idm46045135653104">
  </a>
  <a class="indexterm" name="idm46045135651616">
  </a>
  <p>
   If a
   <code class="literal">
    DATA DIRECTORY
   </code>
   or
   <code class="literal">
    INDEX
        DIRECTORY
   </code>
   table option is used in a
   <a class="link" href="create-table.html" title="15.1.20 CREATE TABLE Statement">
    <code class="literal">
     CREATE TABLE
    </code>
   </a>
   statement on the
        source server, the table option is also used on the replica.
        This can cause problems if no corresponding directory exists in
        the replica host file system or if it exists but is not
        accessible to the replica MySQL server. This can be overridden
        by using the
   <a class="link" href="sql-mode.html#sqlmode_no_dir_in_create">
    <code class="literal">
     NO_DIR_IN_CREATE
    </code>
   </a>
   server SQL mode on the replica, which causes the replica to
        ignore the
   <code class="literal">
    DATA DIRECTORY
   </code>
   and
   <code class="literal">
    INDEX
        DIRECTORY
   </code>
   table options when replicating
   <a class="link" href="create-table.html" title="15.1.20 CREATE TABLE Statement">
    <code class="literal">
     CREATE TABLE
    </code>
   </a>
   statements. The
        result is that
   <code class="literal">
    MyISAM
   </code>
   data and index files
        are created in the table's database directory.
  </p>
  <p>
   For more information, see
   <a class="xref" href="sql-mode.html" title="7.1.11 Server SQL Modes">
    Section 7.1.11, “Server SQL Modes”
   </a>
   .
  </p>
 </div>
 <br/>
</div>
