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

This article mainly gives you a brief talk about mysql data import and parsing. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here, so let's go straight to the topic of mysql data import and parsing. I hope we can bring you some practical help.

Learn the problems encountered when importing data:

Mysql > load data infile'/ etc/name.txt' into table id charset gbk;-- Import name.txt into the id table in gbk encoding

ERROR 1290 (HY000): The MySQL server is running with the-- secure-file-priv option so it cannot execute this statemen

According to the hint, it should be a security limitation. The first step, of course, is to ask du Niang. After reading a few pages, there are all examples of modifying the configuration file under windows, which is not in line with the reality of my linux. Finally found a reliable, modified but can not start mysql, that is quite depressing. Fortunately, there was a burst of inspiration and finally solved:

Secure_file_prive=null-limits that mysqld does not allow import and export

Secure_file_priv=/tmp/-limits the import and export of mysqld to the / tmp/ directory only

Secure_file_priv=''- there is no restriction on the import and export of mysqld. There must be =''. The examples on the Internet are not assigned, so mysql cannot be started.

Mysql data import and analysis will first tell you here, for other related issues you want to know can continue to pay attention to our industry information. Our section will capture some industry news and professional knowledge to share with you every day.

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.