Oracle 5.0, Reference Manual

Page: 329 / 3232

mysqlimport
— A Data Import Program
309
processing option files described at Section 4.2.3.4, “Command-Line Options that Affect Option-File
Handling” .
Table 4.6.
mysqlimport
Options
Format Option File Description
--
columns=column_list [310] columns [310] This option takes a comma-separated list of column
names as its value
--compress [310] compress [310] Compress all information sent between the client and the
server
--
debug[=debug_options] [310] debug [310] Write a debugging log
--default-character-
set=charset_name [310] default-character-
set [310] Use charset_name as the default character set
--delete [310] delete [310] Empty the table before importing the text file
--fields-enclosed-
by=string [310] fields-enclosed-
by [310] This option has the same meaning as the corresponding
clause for LOAD DATA INFILE
--fields-escaped-
by [310] fields-escaped-
by [310] This option has the same meaning as the corresponding
clause for LOAD DATA INFILE
--fields-optionally-
enclosed-
by=string [310] fields-optionally-
enclosed-by [310] This option has the same meaning as the corresponding
clause for LOAD DATA INFILE
--fields-terminated-
by=string [310] fields-terminated-
by [310] -- This option has the same meaning as the
corresponding clause for LOAD DATA INFILE
--force [310] force [310] Continue even if an SQL error occurs
--help [310] Display help message and exit
--
host=host_name [311] host [311] Connect to the MySQL server on the given host
--ignore [311] ignore [311] See the description for the --replace option
--ignore-
lines=# [311] ignore-lines [311] Ignore the first N lines of the data file
--lines-terminated-
by=string [311] lines-terminated-
by [311] This option has the same meaning as the corresponding
clause for LOAD DATA INFILE
--local [311] local [311] Read input files locally from the client host
--lock-tables [311] lock-tables [311] Lock all tables for writing before processing any text files
--low-priority [311] low-priority [311] Use LOW_PRIORITY when loading the table.
--
password[=password] [311] password [311] The password to use when connecting to the server
--pipe [311] On Windows, connect to server using a named pipe
--
port=port_num [311] port [311] The TCP/IP port number to use for the connection
--
protocol=type [311] protocol [311] The connection protocol to use
--replace [312] replace [312] The --replace and --ignore options control handling of
input rows that duplicate existing rows on unique key
values
--silent [312] silent [312] Produce output only when errors occur
--
socket=path [312] socket [312] For connections to localhost