mysqlimport - nx.beandog.org

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== 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>

Trace: • high_availability • dcron • openbsd_liveusb • mysql_security • dig • cd • hdfs_dfsadmin • netbsd_pkg_info • netbsd_install_sets • psearch

Navigation

Search

Toolbox

QR Code