(mysql.info) mysqlimport

(mysql.info) client-utility-programs
 
 8.12 `mysqlimport' -- A Data Import Program
 ===========================================
 
 The `mysqlimport' client provides a command-line interface to the `LOAD
 DATA INFILE' SQL statement. Most options to `mysqlimport' correspond
 directly to clauses of `LOAD DATA INFILE' syntax. See  load-data.
 
 Invoke `mysqlimport' like this:
 
      shell> mysqlimport [OPTIONS] DB_NAME TEXTFILE1 [TEXTFILE2 ...]
 
 For each text file named on the command line, `mysqlimport' strips any
 extension from the filename and uses the result to determine the name
 of the table into which to import the file's contents. For example,
 files named `patient.txt', `patient.text', and `patient' all would be
 imported into a table named `patient'.
 
 `mysqlimport' supports the following options:
 
    * -help, -?
 
      Display a help message and exit.
 
    * -character-sets-dir=PATH
 
      The directory where character sets are installed. See 
      character-sets.
 
    * -columns=COLUMN_LIST, -c COLUMN_LIST
 
      This option takes a comma-separated list of column names as its
      value. The order of the column names indicates how to match data
      file columns with table columns.
 
    * -compress, -C
 
      Compress all information sent between the client and the server if
      both support compression.
 
    * -debug[=DEBUG_OPTIONS], -# [DEBUG_OPTIONS]
 
      Write a debugging log. The DEBUG_OPTIONS string often is
      `'d:t:o,FILE_NAME''.
 
    * -default-character-set=CHARSET_NAME
 
      Use CHARSET_NAME as the default character set. See 
      character-sets.
 
    * -delete, -D
 
      Empty the table before importing the text file.
 
    * -fields-terminated-by=..., -fields-enclosed-by=...,
      -fields-optionally-enclosed-by=..., -fields-escaped-by=...,
      -lines-terminated-by=...
 
      These options have the same meaning as the corresponding clauses
      for `LOAD DATA INFILE'. See  load-data.
 
    * -force, -f
 
      Ignore errors. For example, if a table for a text file does not
      exist, continue processing any remaining files.  Without -force,
      `mysqlimport' exits if a table does not exist.
 
    * -host=HOST_NAME, -h HOST_NAME
 
      Import data to the MySQL server on the given host. The default
      host is `localhost'.
 
    * -ignore, -i
 
      See the description for the -replace option.
 
    * -ignore-lines=N
 
      Ignore the first N lines of the data file.
 
    * -local, -L
 
      Read input files locally from the client host.
 
    * -lock-tables, -l
 
      Lock _all_ tables for writing before processing any text files.
      This ensures that all tables are synchronized on the server.
 
    * -low-priority
 
      Use `LOW_PRIORITY' when loading the table.
 
    * -password[=PASSWORD], -p[PASSWORD]
 
      The password to use when connecting to the server. If you use the
      short option form (-p), you _cannot_ have a space between the
      option and the password. If you omit the PASSWORD value following
      the -password or -p option on the command line, you are prompted
      for one.
 
      Specifying a password on the command line should be considered
      insecure. See  password-security.
 
    * -port=PORT_NUM, -P PORT_NUM
 
      The TCP/IP port number to use for the connection.
 
    * -protocol={TCP|SOCKET|PIPE|MEMORY}
 
      The connection protocol to use.
 
    * -replace, -r
 
      The -replace and -ignore options control handling of input rows
      that duplicate existing rows on unique key values. If you specify
      -replace, new rows replace existing rows that have the same unique
      key value. If you specify -ignore, input rows that duplicate an
      existing row on a unique key value are skipped. If you do not
      specify either option, an error occurs when a duplicate key value
      is found, and the rest of the text file is ignored.
 
    * -silent, -s
 
      Silent mode. Produce output only when errors occur.
 
    * -socket=PATH, -S PATH
 
      For connections to `localhost', the Unix socket file to use, or,
      on Windows, the name of the named pipe to use.
 
    * -user=USER_NAME, -u USER_NAME
 
      The MySQL username to use when connecting to the server.
 
    * -verbose, -v
 
      Verbose mode. Print more information about what the program does.
 
    * -version, -V
 
      Display version information and exit.
 
 Here is a sample session that demonstrates use of `mysqlimport':
 
      shell> mysql -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test
      shell> ed
      a
      100     Max Sydow
      101     Count Dracula
      .
      w imptest.txt
      32
      q
      shell> od -c imptest.txt
      0000000   1   0   0  \t   M   a   x       S   y   d   o   w  \n   1   0
      0000020   1  \t   C   o   u   n   t       D   r   a   c   u   l   a  \n
      0000040
      shell> mysqlimport --local test imptest.txt
      test.imptest: Records: 2  Deleted: 0  Skipped: 0  Warnings: 0
      shell> mysql -e 'SELECT * FROM imptest' test
      +------+---------------+
      | id   | n             |
      +------+---------------+
      |  100 | Max Sydow     |
      |  101 | Count Dracula |
      +------+---------------+
Info Catalog
(mysql.info) mysqlhotcopy
(mysql.info) client-utility-programs
(mysql.info) mysqlshow
automatically generated byinfo2html