mysqlimport
You are viewing an old version of this article. View
the current version here.
Syntax
mysqlimport [OPTIONS] database textfile1 [textfile2 ...]
Description
mysqlimport loads tables from text files in various formats. The base name of the text file must be the name of the table that should be used. If one uses sockets to connect to the MariaDB server, the server will open and read the text file directly. In other cases the client will open the text file. The SQL command LOAD DATA INFILE is used to import the rows.
Options
Default options are read from the following files in the given order:
/etc/my.cnf
/etc/mysql/my.cnf
/usr/etc/my.cnf
/.my.cnf
The following groups are read: mysqlimport
client
client-server
client-mariadb
The following options may be used:
variable | Description |
---|---|
--character-sets-dir=name | Directory for character set files. |
-c cols , --columns=cols | 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. |
-C , --compress | Use compression in server/client protocol. |
-# [options] , --debug[=options] | Output debug log. Often this is d:t:o,filename . The default is d:t:o . |
--debug-check | Check memory and open file usage at exit. |
--debug-info | Print some debug info at exit. |
--default-auth=plugin | Default authentication client-side plugin to use. |
--default-character-set=name | Set the default character set. |
--defaults-extra-file=name | Read this file after the global files are read. Must be given as the first option. |
--defaults-file=name | Only read default options from the given file name Must be given as the first option. |
--defaults-group-suffix=name | In addition to the given groups, also read groups with this suffix. |
-d , --delete | First delete all rows from table. |
--fields-terminated-by=name | Fields in the input file are terminated by the given string. |
--fields-enclosed-by=name | Fields in the import file are enclosed by the given character. |
--fields-optionally-enclosed-by=name | Fields in the input file are optionally enclosed by the given character. |
--fields-escaped-by=name | Fields in the input file are escaped by the given character. |
-f , --force | Continue even if we get an SQL error. |
-? , --help | Displays this help and exits. |
-h name , --host=name | Connect to host. |
-i , --ignore | If duplicate unique key was found, keep old row. |
--ignore-lines=n | Ignore first n lines of data infile. |
--lines-terminated-by=name | Lines in the input file are terminated by the given string. |
-L , --local | Read all files through the client. |
-l , --lock-tables | Lock all tables for write (this disables threads). |
--low-priority | Use LOW_PRIORITY when updating the table. |
--no-defaults | Don't read default options from any option file. Must be given as the first option. |
-p[passwd] , --password[=passwd] | Password to use when connecting to server. If password is not given it's asked from the terminal. Specifying a password on the command line should be considered insecure. 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. |
--plugin-dir | Directory for client-side plugins. |
-P num , --port=num | Port number to use for connection or 0 for default to, in order of preference, my.cnf, the MYSQL_TCP_PORT environment variable, /etc/services, built-in default (3306). |
--print-defaults | Print the program argument list and exit. Must be given as the first option. |
--protocol=name | The protocol to use for connection (tcp, socket, pipe, memory). |
-r , --replace | If duplicate unique key was found, replace old row. |
--shared-memory-base-name | Shared-memory name to use for Windows connections using shared memory to a local server (started with the --shared-memory option). Case-sensitive. |
-s , --silent | Silent mode. Produce output only when errors occur. |
-S , --socket=name | For connections to localhost, the Unix socket file to use, or, on Windows, the name of the named pipe to use. |
--ssl | Enable SSL for connection (automatically enabled with other flags).Disable with '--skip-ssl '. |
--ssl-ca=name | CA file in PEM format (check OpenSSL docs, implies --ssl ). |
--ssl-capath=name | CA directory (check OpenSSL docs, implies --ssl ). |
--ssl-cert=name | X509 cert in PEM format (implies --ssl ). |
--ssl-cipher=name | SSL cipher to use (implies --ssl ). |
--ssl-key=name | X509 key in PEM format (implies --ssl ). |
--ssl-crl=name | Certificate revocation list (implies --ssl ). |
--ssl-crlpath=name | Certificate revocation list path (implies --ssl ). |
--ssl-verify-server-cert | Verify server's "Common Name" in its cert against hostname used when connecting. This option is disabled by default. |
--use-threads=num | Load files in parallel. The argument is the number of threads to use for loading data. |
-u name , --user=name | User for login if not current user. |
-v , --verbose | Print info about the various stages. |
-V , --version | Output version information and exit. |
Default values
Variables ( ) and boolean options {FALSE | Value (after reading options) |
---|---|
character-sets-dir | (No default value) |
default-character-set | latin1 |
columns | (No default value) |
compress | FALSE |
debug-check | FALSE |
debug-info | FALSE |
delete | FALSE |
fields-terminated-by | (No default value) |
fields-enclosed-by | (No default value) |
fields-optionally-enclosed-by | (No default value) |
fields-escaped-by | (No default value) |
force | FALSE |
host | (No default value) |
ignore | FALSE |
ignore-lines | 0 |
lines-terminated-by | (No default value) |
local | FALSE |
lock-tables | FALSE |
low-priority | FALSE |
port | 3306 |
replace | FALSE |
silent | FALSE |
socket | /var/run/mysqld/mysqld.sock |
ssl | FALSE |
ssl-ca | (No default value) |
ssl-capath | (No default value) |
ssl-cert | (No default value) |
ssl-cipher | (No default value) |
ssl-key | (No default value) |
ssl-verify-server-cert | FALSE |
use-threads | 0 |
user | (No default value) |
verbose | FALSE |
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.