shell> mysqlimport [options] db_name textfile1 [textfile2 ...]

•--help, -?

Display a help message and exit.

•--character-sets-dir=path

The directory where character sets are installed. See Section 9.5, “Character Set Configuration”.

•--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 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. A typical debug_options string is ´d:t:o,file_name´. The default is ´d:t:o´.

•--debug-check

Print some debugging information when the program exits. This option was added in MySQL 5.1.21.

•--debug-info

Print debugging information and memory and CPU usage statistics when the program exits. This option was added in MySQL 5.1.14.

•--default-character-set=charset_name

Use charset_name as the default character set. See Section 9.5, “Character Set Configuration”.

•--defaults-extra-file=filename

Set filename as the file to read default options from after the global defaults files has been read. Must be given as first option.

•--defaults-file=filename

Set filename as the file to read default options from, override global defaults files. Must be given as first option.

•--delete, -d

Empty the table before importing the text file.

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

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

•--force, -f

Ignore errors. For example, if a table for a text file does not exist, continue processing any remaining files. Without --force, mysqlimport exits if a table does not 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.

•--lines-terminated-by=...

This option has the same meaning as the corresponding clause for LOAD DATA INFILE. For example, to import Windows files that have lines terminated with carriage return/linefeed pairs, use --lines-terminated-by="\r\n". (You might have to double the backslashes, depending on the escaping conventions of your command interpreter.) See Section 12.2.6, “LOAD DATA INFILE Syntax”.

•--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.

•--low-priority

Use LOW_PRIORITY when loading the table. This affects only storage engines that use only table-level locking (such as MyISAM, MEMORY, and MERGE).

•--no-defaults

Do not read default options from any option file. This must be given as the first argument.

•--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, mysqlimport prompts for one.

Specifying a password on the command line should be considered insecure. See Section 5.3.2.2, “End-User Guidelines for Password Security”. You can use an option file to avoid giving the password on the command line.

•--pipe, -W

On Windows, connect to the server via a named pipe. This option applies only if the server supports named-pipe connections.

•--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 for connecting to the server. It is useful when the other connection parameters normally would cause a protocol to be used other than the one you want. For details on the allowable values, see Section 4.2.2, “Connecting to the MySQL Server”.

•--print-defaults

Print the program argument list and exit. This must be given as the first argument.

•--replace, -r

The --replace and --ignore options control handling of input rows that duplicate existing rows 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 do not 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

For connections to localhost, the Unix socket file to use, or, on Windows, the name of the named pipe to use.

•--ssl*

Options that begin with --ssl specify whether to connect to the server via SSL and indicate where to find SSL keys and certificates. See Section 5.5.6.3, “SSL Command Options”.

•--user=user_name, -u user_name

The MySQL user name to use when connecting to the server.

•--use-threads=N

Load files in parallel using N threads. This option was added in MySQL 5.1.7.

•--verbose, -v

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

•--version, -V

Display version information and exit.

shell> mysql -e ´CREATE TABLE imptest(id INT, n VARCHAR(30))´ test
shell> ed
a
100     Max Sydow
101     Count Dracula
.
w imptest.txt
32
q
shell> od -c imptest.txt
0000000   1   0   0  \t   M   a   x       S   y   d   o   w  \n   1   0
0000020   1  \t   C   o   u   n   t       D   r   a   c   u   l   a  \n
0000040
shell> mysqlimport --local test imptest.txt
test.imptest: Records: 2  Deleted: 0  Skipped: 0  Warnings: 0
shell> mysql -e ´SELECT * FROM imptest´ test
+------+---------------+
| id   | n             |
+------+---------------+
|  100 | Max Sydow     |
|  101 | Count Dracula |
+------+---------------+