(mysql.info.gz) mysqlimport

(mysql.info.gz) Client-Side Scripts
 
 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
 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.
 
 `--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.
 
 `--debug[=DEBUG_OPTIONS], -# [DEBUG_OPTIONS]'
      Write a debugging log. The DEBUG_OPTIONS string often is
      `'d:t:o,FILE_NAME''.
 
 `--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'.  `LOAD DATA' LOAD DATA.
 
 `--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-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.
 
 `--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
      ignored.
 
 `--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
      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.gz) mysqlhotcopy
(mysql.info.gz) Client-Side Scripts
(mysql.info.gz) mysqlshow
automatically generated byinfo2html