Options for mariadb-import & mysqlimport in 10.5 CS
The mariadb-import
utility is the newer name for mysqlimport
, though you can still run it using either name.
Option |
Description |
---|---|
Directory for character set files. |
|
Use only these columns to import the data to. Give the column names in a comma separated list. This is same as giving columns to LOAD DATA INFILE. |
|
Use compression in server/client protocol. |
|
Output debug log. Often this is 'd:t:o,filename'. |
|
Check memory and open file usage at exit. |
|
Print some debug info at exit. |
|
Default authentication client-side plugin to use. |
|
Set the default character set. |
|
Read this file after the global files are read. |
|
Only read default options from the given file #. |
|
Additionally read default groups with # appended as a suffix. |
|
First delete all rows from table. |
|
Fields in the import file are enclosed by the given character. |
|
Fields in the input file are escaped by the given character. |
|
Fields in the input file are optionally enclosed by the given character. |
|
Fields in the input file are terminated by the given string. |
|
Continue even if we get an SQL error. |
|
Displays this help and exits. |
|
Connect to host. |
|
If duplicate unique key was found, keep old row. |
|
Disable foreign key checks while importing the data. |
|
Ignore first n lines of data infile. |
|
Lines in the input file are terminated by the given string. |
|
Read all files through the client. |
|
Lock all tables for write (this disables threads). |
|
Use LOW_PRIORITY when updating the table. |
|
Don't read default options from any option file. |
|
Password to use when connecting to server. If password is not given it's asked from the tty. |
|
Directory for client-side plugins. |
|
Port number to use for connection or 0 for default to, in order of preference, my.cnf, $MYSQL_TCP_PORT, /etc/services, built-in default (3306). |
|
Print the program argument list and exit. |
|
The protocol to use for connection (tcp, socket, pipe). |
|
If duplicate unique key was found, replace old row. |
|
Be more silent. |
|
The socket file to use for connection. |
|
Enable SSL for connection (automatically enabled with other flags). |
|
CA file in PEM format (check OpenSSL docs, implies --ssl). |
|
CA directory (check OpenSSL docs, implies --ssl). |
|
X509 cert in PEM format (implies --ssl). |
|
SSL cipher to use (implies --ssl). |
|
Certificate revocation list (implies --ssl). |
|
Certificate revocation list path (implies --ssl). |
|
X509 key in PEM format (implies --ssl). |
|
Verify server's "Common Name" in its cert against hostname used when connecting. This option is disabled by default. |
|
TLS protocol version for secure connection. |
|
Load files in parallel. The argument is the number of threads to use for loading data. |
|
User for login if not current user. |
|
Print info about the various stages. |
|
Output version information and exit. |