====== mysqlimport ======

  * [[MySQL]]
  * [[mysqladmin]]
  * [[mysqldump]]

**Import database**

<code>
mysqlimport [options] database mysql.sql
</code>

**Empty table before importing**

<code>
mysqlimport -D [options] database mysql.sql
</code>

**Lock tables for writing**

This ensures that all tables are synchronized on the server.

<code>
mysqlimport -l [options] database mysql.sql
</code>

**Replace existing rows on unique key values**

<code>
mysqlimport -r [options] database mysql.sql
</code>

=== Authentication ===

**Username**

<code>
mysqlimport -u username [options] database mysql.sql
</code>

**Password**

<code>
mysqlimport -p [options] database mysql.sql
</code>

<code>
mysqlimport -p[password] [options] database mysql.sql
</code>

**Hostname**
<code>
mysqlimport -h hostname [options] database mysql.sql
</code>