Options for mariadb-import & mysqlimport in MariaDB Community Server 10.6
This page is part of MariaDB's MariaDB Documentation.
The parent of this page is: Command-Line Interfaces for MariaDB Community Server 10.6
Topics on this page:
mariadb-import utility is the newer name for
mysqlimport, though you can still run it using either name.
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).
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_
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.