mysqlimport

Import data into MySQL server using command line

Supplementary instructions

mysqlimport command provides a command line data import tool for the mysql database server. It reads data from a text file in a specific format and inserts it into the MySQL database table.

grammar

mysqlimport(options)(parameters)

Options

-D: Clear the table before importing data;
-f: Continue processing the remaining operations when an error occurs;
-h: The IP address or host name of the MySQL server;
-u: Username to connect to the MySQL server;
-p: Password to connect to the MySQL server.

Parameters

• Database name: Specify the name of the database to be imported;
• Text file: Contains text files in specific formats.