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:

  1. /etc/my.cnf
  2. /etc/mysql/my.cnf
  3. /usr/etc/my.cnf
  4. /.my.cnf

The following groups are read: mysqlimport client client-server client-mariadb

The following options may be used:

variableDescription
--character-sets-dir=nameDirectory for character set files.
-c, --columns=nameUse 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, --compressUse compression in server/client protocol.
-# , --debug[=name]Output debug log. Often this is 'd:t:o,filename'.
--debug-checkCheck memory and open file usage at exit.
--debug-infoPrint some debug info at exit.
--default-character-set=nameSet the default character set.
--defaults-extra-file=nameRead this file after the global files are read. Must be given as the first option.
--defaults-file=nameOnly read default options from the given file name Must be given as the first option.
-d, --deleteFirst delete all rows from table.
--fields-terminated-by=nameFields in the input file are terminated by the given string.
--fields-enclosed-by=nameFields in the import file are enclosed by the given character.
--fields-optionally-enclosed-by=nameFields in the input file are optionally enclosed by the given character.
--fields-escaped-by=nameFields in the input file are escaped by the given character.
-f, --forceContinue even if we get an SQL error.
-?, --helpDisplays this help and exits.
-h name, --host=nameConnect to host.
-i, --ignoreIf duplicate unique key was found, keep old row.
--ignore-lines=nIgnore first n lines of data infile.
--lines-terminated-by=nameLines in the input file are terminated by the given string.
-L, --localRead all files through the client.
-l, --lock-tablesLock all tables for write (this disables threads).
--low-priorityUse LOW_PRIORITY when updating the table.
--no-defaultsDon'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 tty.
-P num, --port=numPort 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-defaultsPrint the program argument list and exit. Must be given as the first option.
--protocol=nameThe protocol to use for connection (tcp, socket, pipe, memory).
-r, --replaceIf duplicate unique key was found, replace old row.
-s, --silentBe more silent.
-S name, --socket=nameThe socket file to use for connection.
--sslEnable SSL for connection (automatically enabled with other flags).Disable with --skip-ssl.
--ssl-ca=nameCA file in PEM format (check OpenSSL docs, implies --ssl).
--ssl-capath=nameCA directory (check OpenSSL docs, implies --ssl).
--ssl-cert=nameX509 cert in PEM format (implies --ssl).
--ssl-cipher=nameSSL cipher to use (implies --ssl).
--ssl-key=nameX509 key in PEM format (implies --ssl).
--ssl-verify-server-certVerify server's "Common Name" in its cert against hostname used when connecting. This option is disabled by default.
--use-threads=numLoad files in parallel. The argument is the number of threads to use for loading data.
-u name, --user=nameUser for login if not current user.
-v, --verbosePrint info about the various stages.
-V, --versionOutput version information and exit.

Default values

Variables (--variable-name=value) and boolean options {FALSE|TRUE}Value (after reading options)
character-sets-dir(No default value)
default-character-setlatin1
columns(No default value)
compressFALSE
debug-checkFALSE
debug-infoFALSE
deleteFALSE
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)
forceFALSE
host(No default value)
ignoreFALSE
ignore-lines0
lines-terminated-by(No default value)
localFALSE
lock-tablesFALSE
low-priorityFALSE
port3306
replaceFALSE
silentFALSE
socket/var/run/mysqld/mysqld.sock
sslFALSE
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-certFALSE
use-threads0
user(No default value)
verboseFALSE

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.