Options for mariadb-import & mysqlimport in MariaDB Community Server 10.5
This page is part of MariaDB's Documentation.
The parent of this page is: Command-Line Interfaces for MariaDB Community Server 10.5
Topics on this page:
Overview
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_ | |
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. |