MySQL Reference Manual :: 8.10 The mysqlimport Data Import Program

--help, -?

Display a help message and exit.

--columns=column_list, -c column_list

This option takes a comma-separated list of column names as its value. The order of the column names indicates how to match up data file columns with table columns.

--compress, -C

Compress all information sent between the client and the server if both support compression.

--debug[=debug_options], -# [debug_options]

Write a debugging log. The debug_options string often is 'd:t:o,file_name'.

--delete, -D

Empty the table before importing the text file.

--fields-terminated-by=... , --fields-enclosed-by=... , --fields-optionally-enclosed-by=... , --fields-escaped-by=... , --lines-terminated-by=...

These options have the same meaning as the corresponding clauses for LOAD DATA INFILE. See Section 13.2.5, “LOAD DATA INFILE Syntax”.

--force, -f

Ignore errors. For example, if a table for a text file doesn't exist, continue processing any remaining files. Without --force, mysqlimport exits if a table doesn't exist.

--host=host_name, -h host_name

Import data to the MySQL server on the given host. The default host is localhost.

--ignore, -i

See the description for the --replace option.

--ignore-lines=n

Ignore the first n lines of the data file.

--local, -L

Read input files locally from the client host.

--lock-tables, -l

Lock all tables for writing before processing any text files. This ensures that all tables are synchronized on the server.

--password[=password], -p[password]

The password to use when connecting to the server. If you use the short option form (-p), you cannot have a space between the option and the password. If you omit the password value following the --password or -p option on the command line, you are prompted for one.

--port=port_num, -P port_num

The TCP/IP port number to use for the connection.

--protocol={TCP | SOCKET | PIPE | MEMORY}

The connection protocol to use. New in MySQL 4.1.

--replace, -r

The --replace and --ignore options control handling of input records that duplicate existing records on unique key values. If you specify --replace, new rows replace existing rows that have the same unique key value. If you specify --ignore, input rows that duplicate an existing row on a unique key value are skipped. If you don't specify either option, an error occurs when a duplicate key value is found, and the rest of the text file is ignored.

--silent, -s

Silent mode. Produce output only when errors occur.

--socket=path, -S path

The socket file to use when connecting to localhost (which is the default host).

--user=user_name, -u user_name

The MySQL username to use when connecting to the server.

--verbose, -v

Verbose mode. Print out more information what the program does.

--version, -V

Display version information and exit.