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 | ||
| + | </ | ||
