mysqlimport - MySQL data importer

The mysqlimport client comes with a command line interface that helps execute LOAD DATA SQL statements. Most options of mysqlimport respond directly to the clauses of the LOAD DATA syntax

Call mysqlimport

The utility mysqlimport can be called as follows -

shell> mysqlimport [options] db_name textfile1 [textfile2 ...]

For naming on the command line For each text file, mysqlimport removes any extensions from the file name and uses the results to find the name of the table into which the file contents must be imported.

Example

Let us take an example: files named sample.txt, sample.text and sample all will be imported into a table named sample.

The utility supports the following feature options, which can be specified on the command line or in the [mysqlimport] and [client] groups of the options file.

--bind-address=ip_address

If the computer has multiple network interfaces, you can use this option to select which interface you need to use to connect to the MySQL server.

--character-sets-dir= dir_name

is the directory where character sets are installed.

--columns=column_list, -c column_list

It takes a comma-separated list of column names as its value. Column order The name indicates how the data file column matches the table column.

--compress, -C

It compresses all information sent between the client and the server (if possible).

--compression-algorithms=value

It refers to the compression algorithms allowed when connecting to the server. this Available algorithms are the same as the protocol_compression_algorithms system Changing. The default value is uncompressed.

--enable-cleartext-plugin

Enable the mysql_clear_password cleartext authentication plug-in.

--force, -f

This option ignores errors. Let's take an example: if the table for a text file does not exist, continue processing the remaining files. Without --force, mysqlimport will exit if the table does not exist.

The above is the detailed content of mysqlimport - MySQL data importer. For more information, please follow other related articles on the PHP Chinese website!