this to import data and table structures from a text file given as
the third argument, into a database named in the second argument of
the utility. This utility interacts with the server and uses the
LOAD DATA INFILE statement. The root name of the
text file being imported must be the same as the table name.
Additional text files may be given in a space-separated list. Options
may be given on the command line as the first argument to the utility
or they may be provided in the server’s
configuration file (e.g., my.cnf) under the
[mysqlimport]. When included in the configuration
file, options appear without the leading double dashes. Here is an
alphabetical list of options you can give for the first argument
along with an explanation of each:
Specifies the directory containing character sets.
Identifies the order of fields in the text file as they relate to the columns in the table. Columns are given in a comma-separated list.
Instructs the utility to compress data passed between it and the server if supported.
Instructs the utility to write debugging information to the log
specified along with various settings (e.g.,
Specifies the default character set.
Instructs the utility to accept additional options from the ...