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