mysqlimport
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
