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

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