<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="mysql-cluster-programs-ndb-import">
      </a>
      25.5.13 ndb_import — Import CSV Data Into NDB
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045103063952">
  </a>
  <p>
   <a class="link" href="mysql-cluster-programs-ndb-import.html" title="25.5.13 ndb_import — Import CSV Data Into NDB">
    <span class="command">
     <strong>
      ndb_import
     </strong>
    </span>
   </a>
   imports CSV-formatted data, such
        as that produced by
   <a class="link" href="mysqldump.html" title="6.5.4 mysqldump — A Database Backup Program">
    <span class="command">
     <strong>
      mysqldump
     </strong>
    </span>
   </a>
   <a class="link" href="mysqldump.html#option_mysqldump_tab">
    <code class="option">
     --tab
    </code>
   </a>
   , directly into
   <code class="literal">
    NDB
   </code>
   using the NDB API.
   <a class="link" href="mysql-cluster-programs-ndb-import.html" title="25.5.13 ndb_import — Import CSV Data Into NDB">
    <span class="command">
     <strong>
      ndb_import
     </strong>
    </span>
   </a>
   requires a connection to an NDB
        management server (
   <a class="link" href="mysql-cluster-programs-ndb-mgmd.html" title="25.5.4 ndb_mgmd — The NDB Cluster Management Server Daemon">
    <span class="command">
     <strong>
      ndb_mgmd
     </strong>
    </span>
   </a>
   ) to function; it
        does not require a connection to a MySQL Server.
  </p>
  <h4>
   <a name="idm46045103055536">
   </a>
   Usage
  </h4>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa75899383"><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">ndb_import <em class="replaceable">db_name</em> <em class="replaceable">file_name</em> <em class="replaceable">options</em></code></pre>
  </div>
  <p>
   <a class="link" href="mysql-cluster-programs-ndb-import.html" title="25.5.13 ndb_import — Import CSV Data Into NDB">
    <span class="command">
     <strong>
      ndb_import
     </strong>
    </span>
   </a>
   requires two arguments.
   <em class="replaceable">
    <code>
     db_name
    </code>
   </em>
   is the name of the database
        where the table into which to import the data is found;
   <em class="replaceable">
    <code>
     file_name
    </code>
   </em>
   is the name of the CSV file
        from which to read the data; this must include the path to this
        file if it is not in the current directory. The name of the file
        must match that of the table; the file's extension, if any,
        is not taken into consideration. Options supported by
   <a class="link" href="mysql-cluster-programs-ndb-import.html" title="25.5.13 ndb_import — Import CSV Data Into NDB">
    <span class="command">
     <strong>
      ndb_import
     </strong>
    </span>
   </a>
   include those for specifying field
        separators, escapes, and line terminators, and are described
        later in this section.
  </p>
  <p>
   <a class="link" href="mysql-cluster-programs-ndb-import.html" title="25.5.13 ndb_import — Import CSV Data Into NDB">
    <span class="command">
     <strong>
      ndb_import
     </strong>
    </span>
   </a>
   rejects any empty lines which it
        reads from the CSV file, except when importing a single column,
        in which case an empty value can be used as the column value.
   <a class="link" href="mysql-cluster-programs-ndb-import.html" title="25.5.13 ndb_import — Import CSV Data Into NDB">
    <span class="command">
     <strong>
      ndb_import
     </strong>
    </span>
   </a>
   handles this in the same manner as
        a
   <a class="link" href="load-data.html" title="15.2.9 LOAD DATA Statement">
    <code class="literal">
     LOAD DATA
    </code>
   </a>
   statement does.
  </p>
  <p>
   <a class="link" href="mysql-cluster-programs-ndb-import.html" title="25.5.13 ndb_import — Import CSV Data Into NDB">
    <span class="command">
     <strong>
      ndb_import
     </strong>
    </span>
   </a>
   must be able to connect to an NDB
        Cluster management server; for this reason, there must be an
        unused
   <code class="literal">
    [api]
   </code>
   slot in the cluster
   <code class="filename">
    config.ini
   </code>
   file.
  </p>
  <p>
   To duplicate an existing table that uses a different storage
        engine, such as
   <a class="link" href="innodb-storage-engine.html" title="Chapter 17 The InnoDB Storage Engine">
    <code class="literal">
     InnoDB
    </code>
   </a>
   , as an
   <code class="literal">
    NDB
   </code>
   table, use the
   <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
    <span class="command">
     <strong>
      mysql
     </strong>
    </span>
   </a>
   client to perform a
   <a class="link" href="select-into.html" title="15.2.13.1 SELECT ... INTO Statement">
    <code class="literal">
     SELECT INTO
        OUTFILE
    </code>
   </a>
   statement to export the existing table to a
        CSV file, then to execute a
   <a class="link" href="create-table-like.html" title="15.1.20.3 CREATE TABLE ... LIKE Statement">
    <code class="literal">
     CREATE TABLE
        LIKE
    </code>
   </a>
   statement to create a new table having the same
        structure as the existing table, then perform
   <a class="link" href="alter-table.html" title="15.1.9 ALTER TABLE Statement">
    <code class="literal">
     ALTER TABLE ...
        ENGINE=NDB
    </code>
   </a>
   on the new table; after this, from the
        system shell, invoke
   <a class="link" href="mysql-cluster-programs-ndb-import.html" title="25.5.13 ndb_import — Import CSV Data Into NDB">
    <span class="command">
     <strong>
      ndb_import
     </strong>
    </span>
   </a>
   to load the
        data into the new
   <code class="literal">
    NDB
   </code>
   table. For example, an
        existing
   <code class="literal">
    InnoDB
   </code>
   table named
   <code class="literal">
    myinnodb_table
   </code>
   in a database named
   <code class="literal">
    myinnodb
   </code>
   can be exported into an
   <code class="literal">
    NDB
   </code>
   table named
   <code class="literal">
    myndb_table
   </code>
   in a database named
   <code class="literal">
    myndb
   </code>
   as shown here, assuming that you are
        already logged in as a MySQL user with the appropriate
        privileges:
  </p>
  <div class="orderedlist">
   <ol class="orderedlist" type="1">
    <li class="listitem">
     <p>
      In the
      <a class="link" href="mysql.html" title="6.5.1 mysql — The MySQL Command-Line Client">
       <span class="command">
        <strong>
         mysql
        </strong>
       </span>
      </a>
      client:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa82000561"><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 prompt">mysql&gt;</span> <span class="token keyword">USE</span> myinnodb<span class="token punctuation">;</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token operator">*</span> <span class="token keyword">INTO</span> <span class="token keyword">OUTFILE</span> <span class="token string">'/tmp/myndb_table.csv'</span>
     <span class="token operator">&gt;</span>  <span class="token keyword">FIELDS</span> <span class="token keyword">TERMINATED</span> <span class="token keyword">BY</span> <span class="token string">','</span> <span class="token keyword">OPTIONALLY</span> <span class="token keyword">ENCLOSED</span> <span class="token keyword">BY</span> <span class="token string">'"'</span> <span class="token keyword">ESCAPED</span> <span class="token keyword">BY</span> <span class="token string">'\\'</span>
     <span class="token operator">&gt;</span>  <span class="token keyword">LINES</span> <span class="token keyword">TERMINATED</span> <span class="token keyword">BY</span> <span class="token string">'\n'</span>
     <span class="token operator">&gt;</span>  <span class="token keyword">FROM</span> myinnodbtable<span class="token punctuation">;</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">CREATE</span> <span class="token keyword">DATABASE</span> myndb<span class="token punctuation">;</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">USE</span> myndb<span class="token punctuation">;</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">CREATE</span> <span class="token keyword">TABLE</span> myndb_table <span class="token operator">LIKE</span> myinnodb<span class="token punctuation">.</span>myinnodb_table<span class="token punctuation">;</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">ALTER</span> <span class="token keyword">TABLE</span> myndb_table <span class="token keyword">ENGINE</span><span class="token operator">=</span><span class="token keyword">NDB</span><span class="token punctuation">;</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">EXIT</span><span class="token punctuation">;</span>
Bye
$<span class="token operator">&gt;</span></code></pre>
     </div>
     <p>
      Once the target database and table have been created, a
            running
      <a class="link" href="mysqld.html" title="6.3.1 mysqld — The MySQL Server">
       <span class="command">
        <strong>
         mysqld
        </strong>
       </span>
      </a>
      is no longer required. You
            can stop it using
      <a class="link" href="mysqladmin.html" title="6.5.2 mysqladmin — A MySQL Server Administration Program">
       <span class="command">
        <strong>
         mysqladmin shutdown
        </strong>
       </span>
      </a>
      or
            another method before proceeding, if you wish.
     </p>
    </li>
    <li class="listitem">
     <p>
      In the system shell:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa59256298"><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 comment" spellcheck="true"># if you are not already in the MySQL bin directory:</span>
<span class="token prompt">$&gt; </span><span class="token command">cd</span> <em class="replaceable">path-to-mysql-bin-dir</em>

<span class="token prompt">$&gt; </span><span class="token command">ndb_import</span> myndb /tmp/myndb_table<span class="token punctuation">.</span>csv <span class="token constant">--fields-optionally-enclosed-by</span>=<span class="token atrule">'"'</span> \
    <span class="token constant">--fields-terminated-by</span>=<span class="token atrule">","</span> <span class="token constant">--fields-escaped-by</span>=<span class="token atrule">'\\'</span></code></pre>
     </div>
     <p>
      The output should resemble what is shown here:
     </p>
     <div class="copytoclipboard-wrapper">
      <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa72824657"><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">job-1 import myndb<span class="token punctuation">.</span>myndb_table from /tmp/myndb_table<span class="token punctuation">.</span>csv
job-1 <span class="token punctuation">[</span>running<span class="token punctuation">]</span> import myndb<span class="token punctuation">.</span>myndb_table from /tmp/myndb_table<span class="token punctuation">.</span>csv
job-1 <span class="token punctuation">[</span>success<span class="token punctuation">]</span> import myndb<span class="token punctuation">.</span>myndb_table from /tmp/myndb_table<span class="token punctuation">.</span>csv
job-1 imported 19984 rows in 0h0m9s at 2277 rows/s
jobs summary<span class="token punctuation">:</span> defined<span class="token punctuation">:</span> 1 run<span class="token punctuation">:</span> 1 with success<span class="token punctuation">:</span> 1 with failure<span class="token punctuation">:</span> 0
$&gt;</code></pre>
     </div>
    </li>
   </ol>
  </div>
  <p>
   All options that can be used with
   <a class="link" href="mysql-cluster-programs-ndb-import.html" title="25.5.13 ndb_import — Import CSV Data Into NDB">
    <span class="command">
     <strong>
      ndb_import
     </strong>
    </span>
   </a>
   are shown in the following table. Additional descriptions follow
        the table.
  </p>
  <p>
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a name="option_ndb_import_abort-on-error">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_abort-on-error">
       <code class="option">
        --abort-on-error
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103000368">
     </a>
     <a class="indexterm" name="idm46045102998880">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for abort-on-error">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --abort-on-error
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Dump core on any fatal error; used for debugging only.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_ai-increment">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_ai-increment">
       <code class="option">
        --ai-increment
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102988768">
     </a>
     <a class="indexterm" name="idm46045102987280">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ai-increment">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ai-increment=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           4294967295
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      For a table with a hidden primary key, specify the
            autoincrement increment, like the
      <a class="link" href="replication-options-source.html#sysvar_auto_increment_increment">
       <code class="literal">
        auto_increment_increment
       </code>
      </a>
      system variable does in the MySQL Server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_ai-offset">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_ai-offset">
       <code class="option">
        --ai-offset
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102966336">
     </a>
     <a class="indexterm" name="idm46045102964848">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ai-offset">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ai-offset=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           4294967295
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      For a table with hidden primary key, specify the
            autoincrement offset. Similar to the
      <a class="link" href="replication-options-source.html#sysvar_auto_increment_offset">
       <code class="literal">
        auto_increment_offset
       </code>
      </a>
      system variable.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_ai-prefetch-sz">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_ai-prefetch-sz">
       <code class="option">
        --ai-prefetch-sz
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102944000">
     </a>
     <a class="indexterm" name="idm46045102942512">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ai-prefetch-sz">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ai-prefetch-sz=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           1024
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           4294967295
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      For a table with a hidden primary key, specify the number of
            autoincrement values that are prefetched. Behaves like the
      <a class="link" href="mysql-cluster-options-variables.html#sysvar_ndb_autoincrement_prefetch_sz">
       <code class="literal">
        ndb_autoincrement_prefetch_sz
       </code>
      </a>
      system variable does in the MySQL Server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_character-sets-dir">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_character-sets-dir">
       <code class="option">
        --character-sets-dir
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102921952">
     </a>
     <a class="indexterm" name="idm46045102920496">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for character-sets-dir">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --character-sets-dir=path
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Directory containing character sets.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_connections">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_connections">
       <code class="option">
        --connections
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102910256">
     </a>
     <a class="indexterm" name="idm46045102908768">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for connections">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --connections=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           4294967295
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Number of cluster connections to create.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_connect-retries">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_connect-retries">
       <code class="option">
        --connect-retries
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102889728">
     </a>
     <a class="indexterm" name="idm46045102888240">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for connect-retries">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --connect-retries=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           12
          </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">
           12
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Number of times to retry connection before giving up.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_connect-retry-delay">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_connect-retry-delay">
       <code class="option">
        --connect-retry-delay
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102869216">
     </a>
     <a class="indexterm" name="idm46045102867760">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for connect-retry-delay">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --connect-retry-delay=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           5
          </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">
           5
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Number of seconds to wait between attempts to contact
            management server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_connect-string">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_connect-string">
       <code class="option">
        --connect-string
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102848576">
     </a>
     <a class="indexterm" name="idm46045102847088">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for connect-string">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --connect-string=connection_string
          </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>
     <p>
      Same as
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_continue">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_continue">
       <code class="option">
        --continue
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102831792">
     </a>
     <a class="indexterm" name="idm46045102830304">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for continue">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --continue
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      When a job fails, continue to the next job.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_core-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_core-file">
       <code class="option">
        --core-file
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102820608">
     </a>
     <a class="indexterm" name="idm46045102819120">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for core-file">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --core-file
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Write core file on error; used in debugging.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_csvopt">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_csvopt">
       <code class="option">
        --csvopt
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        string
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102808928">
     </a>
     <a class="indexterm" name="idm46045102807440">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for csvopt">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --csvopt=opts
          </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>
     <p>
      Provides a shortcut method for setting typical CSV import
            options. The argument to this option is a string consisting
            of one or more of the following parameters:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         <code class="literal">
          c
         </code>
         : Fields terminated by comma
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          d
         </code>
         : Use defaults, except where
                overridden by another parameter
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          n
         </code>
         : Lines terminated by
         <code class="literal">
          \n
         </code>
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          q
         </code>
         : Fields optionally enclosed by
                double quote characters (
         <code class="literal">
          "
         </code>
         )
        </p>
       </li>
       <li class="listitem">
        <p>
         <code class="literal">
          r
         </code>
         : Line terminated by
         <code class="literal">
          \r
         </code>
        </p>
       </li>
      </ul>
     </div>
     <p>
      The order of parameters used in the argument to this option
            is handled such that the rightmost parameter always takes
            precedence over any potentially conflicting parameters which
            have already been used in the same argument value. This also
            applies to any duplicate instances of a given parameter.
     </p>
     <p>
      This option is intended for use in testing under conditions
            in which it is difficult to transmit escapes or quotation
            marks.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_db-workers">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_db-workers">
       <code class="option">
        --db-workers
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102781504">
     </a>
     <a class="indexterm" name="idm46045102780016">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for db-workers">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --db-workers=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           4
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           4294967295
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Number of threads, per data node, executing database
            operations.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_defaults-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_defaults-file">
       <code class="option">
        --defaults-file
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102760944">
     </a>
     <a class="indexterm" name="idm46045102759456">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for defaults-file">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --defaults-file=path
          </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>
     <p>
      Read default options from given file only.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_defaults-extra-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_defaults-extra-file">
       <code class="option">
        --defaults-extra-file
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102745248">
     </a>
     <a class="indexterm" name="idm46045102743792">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for defaults-extra-file">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --defaults-extra-file=path
          </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>
     <p>
      Read given file after global files are read.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_defaults-group-suffix">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_defaults-group-suffix">
       <code class="option">
        --defaults-group-suffix
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102729504">
     </a>
     <a class="indexterm" name="idm46045102728048">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for defaults-group-suffix">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --defaults-group-suffix=string
          </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>
     <p>
      Also read groups with concat(group, suffix).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_errins-type">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_errins-type">
       <code class="option">
        --errins-type
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        name
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102713344">
     </a>
     <a class="indexterm" name="idm46045102711856">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for errins-type">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --errins-type=name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Enumeration
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Valid Values
         </th>
         <td>
          <p class="valid-value">
           <code class="literal">
            stopjob
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            stopall
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            sighup
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            sigint
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            list
           </code>
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Error insert type; use
      <code class="literal">
       list
      </code>
      as the
      <em class="replaceable">
       <code>
        name
       </code>
      </em>
      value to obtain all possible
            values. This option is used for testing purposes only.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_errins-delay">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_errins-delay">
       <code class="option">
        --errins-delay
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102689328">
     </a>
     <a class="indexterm" name="idm46045102687840">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for errins-delay">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --errins-delay=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           1000
          </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">
           4294967295
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          ms
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Error insert delay in milliseconds; random variation is
            added. This option is used for testing purposes only.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_fields-enclosed-by">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_fields-enclosed-by">
       <code class="option">
        --fields-enclosed-by
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        char
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102666256">
     </a>
     <a class="indexterm" name="idm46045102664800">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for fields-enclosed-by">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --fields-enclosed-by=char
          </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>
     <p>
      This works in the same way as the
      <code class="literal">
       FIELDS ENCLOSED
            BY
      </code>
      option does for the
      <a class="link" href="load-data.html" title="15.2.9 LOAD DATA Statement">
       <code class="literal">
        LOAD
            DATA
       </code>
      </a>
      statement, specifying a character to be
            interpreted as quoting field values. For CSV input, this is
            the same as
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_fields-optionally-enclosed-by">
       <code class="option">
        --fields-optionally-enclosed-by
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_fields-escaped-by">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_fields-escaped-by">
       <code class="option">
        --fields-escaped-by
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        name
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102646800">
     </a>
     <a class="indexterm" name="idm46045102645344">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for fields-escaped-by">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --fields-escaped-by=char
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           \
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Specify an escape character in the same way as the
      <code class="literal">
       FIELDS ESCAPED BY
      </code>
      option does for the SQL
      <a class="link" href="load-data.html" title="15.2.9 LOAD DATA Statement">
       <code class="literal">
        LOAD DATA
       </code>
      </a>
      statement.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_fields-optionally-enclosed-by">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_fields-optionally-enclosed-by">
       <code class="option">
        --fields-optionally-enclosed-by
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        char
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102628704">
     </a>
     <a class="indexterm" name="idm46045102627200">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for fields-optionally-enclosed-by">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --fields-optionally-enclosed-by=char
          </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>
     <p>
      This works in the same way as the
      <code class="literal">
       FIELDS OPTIONALLY
            ENCLOSED BY
      </code>
      option does for the
      <a class="link" href="load-data.html" title="15.2.9 LOAD DATA Statement">
       <code class="literal">
        LOAD DATA
       </code>
      </a>
      statement,
            specifying a character to be interpreted as optionally
            quoting field values. For CSV input, this is the same as
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_fields-enclosed-by">
       <code class="option">
        --fields-enclosed-by
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_fields-terminated-by">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_fields-terminated-by">
       <code class="option">
        --fields-terminated-by
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        char
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102609424">
     </a>
     <a class="indexterm" name="idm46045102607968">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for fields-terminated-by">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --fields-terminated-by=char
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           \t
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      This works in the same way as the
      <code class="literal">
       FIELDS TERMINATED
            BY
      </code>
      option does for the
      <a class="link" href="load-data.html" title="15.2.9 LOAD DATA Statement">
       <code class="literal">
        LOAD
            DATA
       </code>
      </a>
      statement, specifying a character to be
            interpreted as the field separator.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_help">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_help">
       <code class="option">
        --help
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102591664">
     </a>
     <a class="indexterm" name="idm46045102590176">
     </a>
     <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>
     <p>
      Display help text and exit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_idlesleep">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_idlesleep">
       <code class="option">
        --idlesleep
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102580000">
     </a>
     <a class="indexterm" name="idm46045102578512">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for idlesleep">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --idlesleep=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           4294967295
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          ms
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Number of milliseconds to sleep waiting for more work to
            perform.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_idlespin">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_idlespin">
       <code class="option">
        --idlespin
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102556976">
     </a>
     <a class="indexterm" name="idm46045102555488">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for idlespin">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --idlespin=#
          </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">
           4294967295
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Number of times to retry before sleeping.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_ignore-lines">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_ignore-lines">
       <code class="option">
        --ignore-lines
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102536080">
     </a>
     <a class="indexterm" name="idm46045102534592">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ignore-lines">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ignore-lines=#
          </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">
           4294967295
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Cause ndb_import to ignore the first
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
      lines of the input file. This
            can be employed to skip a file header that does not contain
            any data.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_input-type">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_input-type">
       <code class="option">
        --input-type
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        name
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102514480">
     </a>
     <a class="indexterm" name="idm46045102512992">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for input-type">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --input-type=name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Enumeration
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           csv
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Valid Values
         </th>
         <td>
          <p class="valid-value">
           <code class="literal">
            random
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            csv
           </code>
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Set the type of input type. The default is
      <code class="literal">
       csv
      </code>
      ;
      <code class="literal">
       random
      </code>
      is
            intended for testing purposes only. .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_input-workers">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_input-workers">
       <code class="option">
        --input-workers
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102493216">
     </a>
     <a class="indexterm" name="idm46045102491728">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for input-workers">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --input-workers=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           4
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           4294967295
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Set the number of threads processing input.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_keep-state">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_keep-state">
       <code class="option">
        --keep-state
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102472688">
     </a>
     <a class="indexterm" name="idm46045102471200">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for keep-state">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --keep-state
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      By default, ndb_import removes all state files (except
            non-empty
      <code class="filename">
       *.rej
      </code>
      files) when it
            completes a job. Specify this option (nor argument is
            required) to force the program to retain all state files
            instead.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_lines-terminated-by">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_lines-terminated-by">
       <code class="option">
        --lines-terminated-by
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        name
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102460096">
     </a>
     <a class="indexterm" name="idm46045102458640">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for lines-terminated-by">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --lines-terminated-by=char
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           \n
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      This works in the same way as the
      <code class="literal">
       LINES TERMINATED
            BY
      </code>
      option does for the
      <a class="link" href="load-data.html" title="15.2.9 LOAD DATA Statement">
       <code class="literal">
        LOAD
            DATA
       </code>
      </a>
      statement, specifying a character to be
            interpreted as end-of-line.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_log-level">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_log-level">
       <code class="option">
        --log-level
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102441904">
     </a>
     <a class="indexterm" name="idm46045102440416">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for log-level">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --log-level=#
          </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">
           2
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Performs internal logging at the given level. This option is
            intended primarily for internal and development use.
     </p>
     <p>
      In debug builds of NDB only, the logging level can be set
            using this option to a maximum of 4.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_login-path">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_login-path">
       <code class="option">
        --login-path
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102420736">
     </a>
     <a class="indexterm" name="idm46045102419248">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for login-path">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --login-path=path
          </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>
     <p>
      Read given path from login file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_no-login-paths">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_no-login-paths">
       <code class="option">
        --no-login-paths
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102404976">
     </a>
     <a class="indexterm" name="idm46045102403488">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for no-login-paths">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --no-login-paths
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Skips reading options from the login path file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_max-rows">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_max-rows">
       <code class="option">
        --max-rows
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102393328">
     </a>
     <a class="indexterm" name="idm46045102391840">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for max-rows">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --max-rows=#
          </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">
           4294967295
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          bytes
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Import only this number of input data rows; the default is
            0, which imports all rows.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_missing-ai-column">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_missing-ai-column">
       <code class="option">
        --missing-ai-column
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102370640">
     </a>
     <a class="indexterm" name="idm46045102369184">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for missing-ai-column">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --missing-ai-column='name'
          </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>
     <p>
      This option can be employed when importing a single table,
            or multiple tables. When used, it indicates that the CSV
            file being imported does not contain any values for an
      <code class="literal">
       AUTO_INCREMENT
      </code>
      column, and that
      <a class="link" href="mysql-cluster-programs-ndb-import.html" title="25.5.13 ndb_import — Import CSV Data Into NDB">
       <span class="command">
        <strong>
         ndb_import
        </strong>
       </span>
      </a>
      should supply them; if the
            option is used and the
      <code class="literal">
       AUTO_INCREMENT
      </code>
      column contains any values, the import operation cannot
            proceed.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_monitor">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_monitor">
       <code class="option">
        --monitor
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102351376">
     </a>
     <a class="indexterm" name="idm46045102349888">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for monitor">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --monitor=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           2
          </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">
           4294967295
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          bytes
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Periodically print the status of a running job if something
            has changed (status, rejected rows, temporary errors). Set
            to 0 to disable this reporting. Setting to 1 prints any
            change that is seen. Higher values reduce the frequency of
            this status reporting.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_ndb-connectstring">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102328592">
     </a>
     <a class="indexterm" name="idm46045102327136">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-connectstring">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-connectstring=connection_string
          </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>
     <p>
      Set connection string for connecting to
      <a class="link" href="mysql-cluster-programs-ndb-mgmd.html" title="25.5.4 ndb_mgmd — The NDB Cluster Management Server Daemon">
       <span class="command">
        <strong>
         ndb_mgmd
        </strong>
       </span>
      </a>
      . Syntax:
      <code class="literal">
       [nodeid=
       <em class="replaceable">
        <code>
         id
        </code>
       </em>
       ;][host=]
       <em class="replaceable">
        <code>
         hostname
        </code>
       </em>
       [:
       <em class="replaceable">
        <code>
         port
        </code>
       </em>
       ]
      </code>
      .
            Overrides entries in
      <code class="literal">
       NDB_CONNECTSTRING
      </code>
      and
      <code class="filename">
       my.cnf
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_ndb-mgm-tls">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_ndb-mgm-tls">
       <code class="option">
        --ndb-mgm-tls
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102308096">
     </a>
     <a class="indexterm" name="idm46045102306608">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-mgm-tls">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-mgm-tls=level
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Enumeration
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           relaxed
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Valid Values
         </th>
         <td>
          <p class="valid-value">
           <code class="literal">
            relaxed
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            strict
           </code>
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Sets the level of TLS support required to connect to the
            management server; one of
      <code class="literal">
       relaxed
      </code>
      or
      <code class="literal">
       strict
      </code>
      .
      <code class="literal">
       relaxed
      </code>
      (the
            default) means that a TLS connection is attempted, but
            success is not required;
      <code class="literal">
       strict
      </code>
      means
            that TLS is required to connect.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_ndb-mgmd-host">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_ndb-mgmd-host">
       <code class="option">
        --ndb-mgmd-host
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102285552">
     </a>
     <a class="indexterm" name="idm46045102284064">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-mgmd-host">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-mgmd-host=connection_string
          </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>
     <p>
      Same as
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_ndb-nodeid">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_ndb-nodeid">
       <code class="option">
        --ndb-nodeid
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102268880">
     </a>
     <a class="indexterm" name="idm46045102267392">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-nodeid">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-nodeid=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Set node ID for this node, overriding any ID set by
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_ndb-optimized-node-selection">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_ndb-optimized-node-selection">
       <code class="option">
        --ndb-optimized-node-selection
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102252016">
     </a>
     <a class="indexterm" name="idm46045102250512">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-optimized-node-selection">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-optimized-node-selection
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Enable optimizations for selection of nodes for
            transactions. Enabled by default; use
      <code class="option">
       --skip-ndb-optimized-node-selection
      </code>
      to
            disable.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_ndb-tls-search-path">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_ndb-tls-search-path">
       <code class="option">
        --ndb-tls-search-path
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102240160">
     </a>
     <a class="indexterm" name="idm46045102238704">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-tls-search-path">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-tls-search-path=list
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Path name
         </td>
        </tr>
        <tr>
         <th>
          Default Value (Unix)
         </th>
         <td>
          <code class="literal">
           $HOME/ndb-tls
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Default Value (Windows)
         </th>
         <td>
          <code class="literal">
           $HOMEDIR/ndb-tls
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Specify a list of directories to search for a CA file. On
            Unix platforms, the directory names are separated by colons
            (
      <code class="literal">
       :
      </code>
      ); on Windows systems, the semicolon
            character (
      <code class="literal">
       ;
      </code>
      ) is used as the separator. A
            directory reference may be relative or absolute; it may
            contain one or more environment variables, each denoted by a
            prefixed dollar sign (
      <code class="literal">
       $
      </code>
      ), and expanded
            prior to use.
     </p>
     <p>
      Searching begins with the leftmost named directory and
            proceeds from left to right until a file is found. An empty
            string denotes an empty search path, which causes all
            searches to fail. A string consisting of a single dot
            (
      <code class="literal">
       .
      </code>
      ) indicates that the search path
            limited to the current working directory.
     </p>
     <p>
      If no search path is supplied, the compiled-in default value
            is used. This value depends on the platform used: On
            Windows, this is
      <code class="literal">
       \ndb-tls
      </code>
      ; on other
            platforms (including Linux), it is
      <code class="literal">
       $HOME/ndb-tls
      </code>
      . This can be overridden by
            compiling NDB Cluster using
      <a class="link" href="source-configuration-options.html#option_cmake_with_ndb_tls_search_path">
       <code class="option">
        -DWITH_NDB_TLS_SEARCH_PATH
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_no-asynch">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_no-asynch">
       <code class="option">
        --no-asynch
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102214944">
     </a>
     <a class="indexterm" name="idm46045102213456">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for no-asynch">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --no-asynch
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Run database operations as batches, in single transactions.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_no-defaults">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_no-defaults">
       <code class="option">
        --no-defaults
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102203728">
     </a>
     <a class="indexterm" name="idm46045102202240">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for no-defaults">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --no-defaults
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Do not read default options from any option file other than
            login file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_no-hint">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_no-hint">
       <code class="option">
        --no-hint
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102192416">
     </a>
     <a class="indexterm" name="idm46045102190928">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for no-hint">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --no-hint
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Do not use distribution key hinting to select a data node.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_opbatch">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_opbatch">
       <code class="option">
        --opbatch
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102180832">
     </a>
     <a class="indexterm" name="idm46045102179344">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for opbatch">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --opbatch=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           256
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           4294967295
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          bytes
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Set a limit on the number of operations (including blob
            operations), and thus the number of asynchronous
            transactions, per execution batch.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_opbytes">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_opbytes">
       <code class="option">
        --opbytes
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102157632">
     </a>
     <a class="indexterm" name="idm46045102156144">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for opbytes">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --opbytes=#
          </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">
           4294967295
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          bytes
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Set a limit on the number of bytes per execution batch. Use
            0 for no limit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_output-type">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_output-type">
       <code class="option">
        --output-type
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        name
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102134608">
     </a>
     <a class="indexterm" name="idm46045102133120">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for output-type">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --output-type=name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Enumeration
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           ndb
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Valid Values
         </th>
         <td>
          <code class="literal">
           null
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Set the output type.
      <code class="literal">
       ndb
      </code>
      is the default.
      <code class="literal">
       null
      </code>
      is used only for testing.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_output-workers">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_output-workers">
       <code class="option">
        --output-workers
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102114640">
     </a>
     <a class="indexterm" name="idm46045102113152">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for output-workers">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --output-workers=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           2
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           4294967295
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Set the number of threads processing output or relaying
            database operations.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_pagesize">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_pagesize">
       <code class="option">
        --pagesize
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102093552">
     </a>
     <a class="indexterm" name="idm46045102092064">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for pagesize">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --pagesize=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           4096
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           4294967295
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          bytes
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Align I/O buffers to the given size.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_pagecnt">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_pagecnt">
       <code class="option">
        --pagecnt
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102070512">
     </a>
     <a class="indexterm" name="idm46045102069024">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for pagecnt">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --pagecnt=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           64
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           4294967295
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Set the size of I/O buffers as multiple of page size. The
            CSV input worker allocates buffer that is doubled in size.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_polltimeout">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_polltimeout">
       <code class="option">
        --polltimeout
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102049520">
     </a>
     <a class="indexterm" name="idm46045102048032">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for polltimeout">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --polltimeout=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           1000
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           1
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           4294967295
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          ms
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Set a timeout per poll for completed asynchronous
            transactions; polling continues until all polls are
            completed, or until an error occurs.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_print-defaults">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_print-defaults">
       <code class="option">
        --print-defaults
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045102026816">
     </a>
     <a class="indexterm" name="idm46045102025328">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for print-defaults">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --print-defaults
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Print program argument list and exit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_rejects">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_rejects">
       <code class="option">
        --rejects
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045102015104">
     </a>
     <a class="indexterm" name="idm46045102013616">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for rejects">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --rejects=#
          </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">
           4294967295
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Limit the number of rejected rows (rows with permanent
            errors) in the data load. The default is 0, which means that
            any rejected row causes a fatal error. Any rows causing the
            limit to be exceeded are added to the
      <code class="filename">
       .rej
      </code>
      file.
     </p>
     <p>
      The limit imposed by this option is effective for the
            duration of the current run. A run restarted using
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_resume">
       <code class="option">
        --resume
       </code>
      </a>
      is considered a
      <span class="quote">
       “
       <span class="quote">
        new
       </span>
       ”
      </span>
      run for this purpose.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_resume">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_resume">
       <code class="option">
        --resume
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101991616">
     </a>
     <a class="indexterm" name="idm46045101990128">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for resume">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --resume
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      If a job is aborted (due to a temporary db error or when
            interrupted by the user), resume with any rows not yet
            processed.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_rowbatch">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_rowbatch">
       <code class="option">
        --rowbatch
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045101979872">
     </a>
     <a class="indexterm" name="idm46045101978384">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for rowbatch">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --rowbatch=#
          </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">
           4294967295
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          rows
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Set a limit on the number of rows per row queue. Use 0 for
            no limit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_rowbytes">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_rowbytes">
       <code class="option">
        --rowbytes
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045101956816">
     </a>
     <a class="indexterm" name="idm46045101955328">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for rowbytes">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --rowbytes=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           262144
          </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">
           4294967295
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          bytes
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Set a limit on the number of bytes per row queue. Use 0 for
            no limit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_stats">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_stats">
       <code class="option">
        --stats
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101934224">
     </a>
     <a class="indexterm" name="idm46045101932736">
     </a>
     <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>
     <p>
      Save information about options related to performance and
            other internal statistics in files named
      <code class="filename">
       *.sto
      </code>
      and
      <code class="filename">
       *.stt
      </code>
      .
            These files are always kept on successful completion (even
            if
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_keep-state">
       <code class="option">
        --keep-state
       </code>
      </a>
      is not
            also specified).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_state-dir">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_state-dir">
       <code class="option">
        --state-dir
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        name
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045101919952">
     </a>
     <a class="indexterm" name="idm46045101918464">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for state-dir">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --state-dir=path
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           .
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Where to write the state files
            (
      <code class="filename">
       <em class="replaceable">
        <code>
         tbl_name
        </code>
       </em>
       .map
      </code>
      ,
      <code class="filename">
       <em class="replaceable">
        <code>
         tbl_name
        </code>
       </em>
       .rej
      </code>
      ,
      <code class="filename">
       <em class="replaceable">
        <code>
         tbl_name
        </code>
       </em>
       .res
      </code>
      ,
            and
      <code class="filename">
       <em class="replaceable">
        <code>
         tbl_name
        </code>
       </em>
       .stt
      </code>
      )
            produced by a run of the program; the default is the current
            directory.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_table">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_table">
       <code class="option">
        --table=
        <em class="replaceable">
         <code>
          name
         </code>
        </em>
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101899968">
     </a>
     <a class="indexterm" name="idm46045101898480">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for table">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --table=name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [input file base name]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      By default,
      <a class="link" href="mysql-cluster-programs-ndb-import.html" title="25.5.13 ndb_import — Import CSV Data Into NDB">
       <span class="command">
        <strong>
         ndb_import
        </strong>
       </span>
      </a>
      attempts to import
            data into a table whose name is the base name of the CSV
            file from which the data is being read. You can override the
            choice of table name by specifying it with the
      <code class="option">
       --table
      </code>
      option (short form
      <code class="option">
       -t
      </code>
      ).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_tempdelay">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_tempdelay">
       <code class="option">
        --tempdelay
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045101881456">
     </a>
     <a class="indexterm" name="idm46045101879968">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for tempdelay">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --tempdelay=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           10
          </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">
           4294967295
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Unit
         </th>
         <td>
          ms
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Number of milliseconds to sleep between temporary errors.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_temperrors">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_temperrors">
       <code class="option">
        --temperrors
       </code>
      </a>
      =
      <em class="replaceable">
       <code>
        #
       </code>
      </em>
     </p>
     <a class="indexterm" name="idm46045101858448">
     </a>
     <a class="indexterm" name="idm46045101856960">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for temperrors">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --temperrors=#
          </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">
           4294967295
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Number of times a transaction can fail due to a temporary
            error, per execution batch. The default is 0, which means
            that any temporary error is fatal. Temporary errors do not
            cause any rows to be added to the
      <code class="filename">
       .rej
      </code>
      file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_verbose">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_verbose">
       <code class="option">
        --verbose
       </code>
      </a>
      ,
      <code class="option">
       -v
      </code>
     </p>
     <a class="indexterm" name="idm46045101836512">
     </a>
     <a class="indexterm" name="idm46045101835024">
     </a>
     <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>
     <p>
      Enable verbose output.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_usage">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_usage">
       <code class="option">
        --usage
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101820944">
     </a>
     <a class="indexterm" name="idm46045101819456">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for usage">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --usage
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Display help text and exit; same as
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_help">
       <code class="option">
        --help
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_import_version">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-import.html#option_ndb_import_version">
       <code class="option">
        --version
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045101808688">
     </a>
     <a class="indexterm" name="idm46045101807200">
     </a>
     <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>
       </tbody>
      </table>
     </div>
     <p>
      Display version information and exit.
     </p>
    </li>
   </ul>
  </div>
  <p>
   As with
   <a class="link" href="load-data.html" title="15.2.9 LOAD DATA Statement">
    <code class="literal">
     LOAD DATA
    </code>
   </a>
   , options for
        field and line formatting much match those used to create the
        CSV file, whether this was done using
   <a class="link" href="select-into.html" title="15.2.13.1 SELECT ... INTO Statement">
    <code class="literal">
     SELECT INTO ...
        OUTFILE
    </code>
   </a>
   , or by some other means. There is no
        equivalent to the
   <a class="link" href="load-data.html" title="15.2.9 LOAD DATA Statement">
    <code class="literal">
     LOAD DATA
    </code>
   </a>
   statement
   <code class="literal">
    STARTING WITH
   </code>
   option.
  </p>
 </div>
 <br/>
</div>
