Trace:

Differences

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

--- mysqlimport [2012/03/30 10:12]
+++ 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>