no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
— | mysqlimport [2012/03/30 16:12] (current) – created - external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== mysqlimport ====== | ||
+ | * [[MySQL]] | ||
+ | * [[mysqladmin]] | ||
+ | * [[mysqldump]] | ||
+ | |||
+ | **Import database** | ||
+ | |||
+ | < | ||
+ | mysqlimport [options] database mysql.sql | ||
+ | </ | ||
+ | |||
+ | **Empty table before importing** | ||
+ | |||
+ | < | ||
+ | mysqlimport -D [options] database mysql.sql | ||
+ | </ | ||
+ | |||
+ | **Lock tables for writing** | ||
+ | |||
+ | This ensures that all tables are synchronized on the server. | ||
+ | |||
+ | < | ||
+ | mysqlimport -l [options] database mysql.sql | ||
+ | </ | ||
+ | |||
+ | **Replace existing rows on unique key values** | ||
+ | |||
+ | < | ||
+ | mysqlimport -r [options] database mysql.sql | ||
+ | </ | ||
+ | |||
+ | === Authentication === | ||
+ | |||
+ | **Username** | ||
+ | |||
+ | < | ||
+ | mysqlimport -u username [options] database mysql.sql | ||
+ | </ | ||
+ | |||
+ | **Password** | ||
+ | |||
+ | < | ||
+ | mysqlimport -p [options] database mysql.sql | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | mysqlimport -p[password] [options] database mysql.sql | ||
+ | </ | ||
+ | |||
+ | **Hostname** | ||
+ | < | ||
+ | mysqlimport -h hostname [options] database mysql.sql | ||
+ | </ |