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

Editor to share with you how to solve the mysql command line import data report error problem, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Mysql command line import data report error solution: 1, enter [set global local_infile=1] in the command line to run, continue to enter [show variables like'% local%'] to run; 2, convert the character encoding to [UTF-8].

Mysql command line import Datagram error solution:

1. Error 1

Cause of error:

MySQL:6.1.6 Security Considerations for LOAD DATA LOCAL .

When you use a client that is local to MySQL to load data into the database, you need the permission of the server.

The solution is as follows: set the global variable and restart the client.

(1) enter set global local_infile=1 on the command line and run

(2) continue to enter show variables like'% local%', to run. The status of local_infile will be queried as on.

(3) restart the command line and import the data again. Be sure to restart, or the imported data will lose records. )

2. Error 2

Cause of error: string encoding problem.

Solution: open the data file to be imported with notepad++ and convert the character encoding to UTF-8.

The above is how to solve the problem of mysql command line import Datagram error all the content, thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.