Frequently Used MySQL Import Options for Command Line

MySQL MySQLi Database

mysqlimport can be run with a number of options. Followings are some options for mysqlimport and their effect on import.

Option	Action
-r or –replace	Cause imported rows to overwrite existing rows if they have the same unique key value.
-i or –ignore	Ignore rows that have the same unique key value as existing rows.
-f or –force	Force mysqlimport to continue inserting data even if errors are encountered.
-l or --lock-tables	Lock each table before importing (a good option on a busy server).
-d or –delete	Empty the table before inserting.
--fields-terminated- by='char'	Specify the separator used between values of the same row, default \t (tab).
--fields-enclosed- by='char'	Specify the delimiter that encloses each field; default is none.
--fields-optionally- enclosed-by='char'	Same as --fields-enclosed-by, but delimiter is used only to enclose string-type columns; default is none.
--fields-escaped- by='char'	Specify the escape character placed before special characters; default is \ (backslash, which if specified would be '\').
--lines-terminated-by='char'	Specify the separator used to terminate each row of data; default is (newline).
-u or –user	Specify your username; default is Unix login name.
-p or –password	Specify your password.
-h or –host	Import into MySQL on the named host; default is localhost.
-s or –silent	Silent mode; output appears only when errors occur.
-v or –verbose	Verbose mode, print more commentary.
-L or local	Name a local file on the client.
-V or –version	Print program version information and exit.
-? or –help	Print help message and exit.

usharani

Updated on: 2020-02-27T07:32:01+05:30

145 Views

Kickstart Your Career

Get certified by completing the course

Advertisements