![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_1646196331.webp)
mysqlimport
— A Data Import Program
311
Ignore errors. For example, if a table for a text file does not exist, continue processing any remaining
files. Without
--force
[310]
,
mysqlimport
exits if a table does not exist.
•
--host=host_name
[311]
,
-h host_name
Import data to the MySQL server on the given host. The default host is
localhost
.
•
--ignore
[311]
,
-i
See the description for the
--replace
[312]
option.
•
--ignore-lines=N
[311]
Ignore the first
N
lines of the data file.
•
--lines-terminated-by=...
[311]
This option has the same meaning as the corresponding clause for
LOAD DATA INFILE
. For
example, to import Windows files that have lines terminated with carriage return/linefeed pairs,
use
--lines-terminated-by="\r\n"
[311]
. (You might have to double the backslashes,
depending on the escaping conventions of your command interpreter.) See
Section 13.2.6, “
LOAD
DATA INFILE
Syntax”
.
•
--local
[311]
,
-L
Read input files locally from the client host.
•
--lock-tables
[301]
,
-l
Lock all tables for writing before processing any text files. This ensures that all tables are
synchronized on the server.
•
--low-priority
[311]
Use
LOW_PRIORITY
when loading the table. This affects only storage engines that use only table-
level locking (such as
MyISAM
,
MEMORY
, and
MERGE
).
•
--password[=password]
[311]
,
-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
[311]
or
-p
option on the command line,
mysqlimport
prompts for
one.
Specifying a password on the command line should be considered insecure. See
Section 6.1.2.1,
“End-User Guidelines for Password Security”
. You can use an option file to avoid giving the
password on the command line.
•
--pipe
[311]
,
-W
On Windows, connect to the server using a named pipe. This option applies only if the server
supports named-pipe connections.
•
--port=port_num
[311]
,
-P port_num
The TCP/IP port number to use for the connection.
•
--protocol={TCP|SOCKET|PIPE|MEMORY}
[311]
The connection protocol to use for connecting to the server. It is useful when the other connection
parameters normally would cause a protocol to be used other than the one you want. For details on
the permissible values, see
Section 4.2.2, “Connecting to the MySQL Server”
.
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...