( mysqlimport

Info Catalog ( mysqlhotcopy ( Client-Side Scripts ( mysqlshow
 8.10 The `mysqlimport' 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'.   `LOAD DATA' LOAD
 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.
 `--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 up
      data file columns with table columns.
 `--compress, -C'
      Compress all information sent between the client and the server if
      both support compression.
      Write a debugging log. The DEBUG_OPTIONS string often is
 `--delete, -D'
      Empty the table before importing the text file.
      These options have the same meaning as the corresponding clauses
 `--force, -f'
      Ignore errors.  For example, if a table for a text file doesn't
      exist, continue processing any remaining files.  Without `--force',
      `mysqlimport' exits if a table doesn't 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 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.
 `--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 will be
      prompted for one.
 `--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.  New in MySQL 4.1.
 `--replace, -r'
      The `--replace' and `--ignore' options control handling of input
      records that duplicate existing records 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 don't specify either option, an error occurs when a
      duplicate key value is found, and the rest of the text file is
 `--silent, -s'
      Silent mode.  Produce output only when errors occur.
 `--socket=PATH, -S PATH'
      The socket file to use when connecting to `localhost' (which is the
      default host).
 `--user=USER_NAME, -u USER_NAME'
      The MySQL username to use when connecting to the server.
 `--verbose, -v'
      Verbose mode.  Print out more information 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
      100     Max Sydow
      101     Count Dracula
      w imptest.txt
      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
      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 ( mysqlhotcopy ( Client-Side Scripts ( mysqlshow
automatically generated byinfo2html