Differences

This shows you the differences between two versions of the page.

Link to this comparison view

mysqlimport [2012/03/30 10:12] (current)
Line 1: Line 1:
 +====== 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>​