25.5. mysqlimport

25.5. mysqlimport

The mysqlimport client program loads data files into tables. It provides a command-line interface to the LOAD DATA INFILE statement. That is, mysqlimport examines the options given on the command line. It then connects to the server and, for each input file named in the command, issues a LOAD DATA INFILE statement that loads the file into the appropriate table.

By default, mysqlimport expects data files to contain tab-delimited lines terminated by newlines. Files in other formats can be imported by identifying the format using command-line options.

mysqlimport can load files located on the client host or on the server host. It can load tables managed by local or remote servers.

For further information about mysqlimport, see Section 15.3.1, "Importing Data with mysqlimport."