Shulou(Shulou.com)06/02 Report--

This article will explain in detail about the use of linux mysqlimport command MySQL server data import, the editor thinks it is very practical, so share it for you to do a reference, I hope you can get something after reading this article.

The mysqlimport command provides a command-line tool for the MySQL database server to import data, which reads data from a text file in a specific format and inserts it into a MySQL database table.

Syntax format: mysqlimport [parameters]

Common parameters:

-D clear the table before importing data-f continue to process the remaining operations when an error occurs-ip address or hostname of the hMySQL server-u user name of the connection MySQL server-p password of the connection MySQL server

Use the mysqlimport command to import data like the MySQL server, you need to pay attention to the encoding format of the file, otherwise it may lead to garbled imported data.

Reference example

Import the database:

[root@linuxcool ~] # mysqlimport-u root-local linuxcool.sql-fields-terminated-by= "|"

Import this article into the database:

[root@linuxcool ~] # [root@linuxcool ~] # mysqlimport-v-u root-p linuxcool_db linuxcool.txt about using linux mysqlimport command MySQL server data import to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.