1.linux下(mysql 5.6.36)
a> 查看参数配置(已经开启,如果secure_file_priv 为NULL表示没开启,需要小伙伴们手动修改my.ini配置文件开启)
+------------------+------------------------+
| Variable_name | Value |
+------------------+------------------------+
| secure_file_priv | /home/webedit/hq/data/ |
+------------------+------------------------+
问题:无论怎样重启运行:LOAD DATA INFILE '/home/webedit/hq/data/article_content.csv' INTO TABLE article_content_record character set utf8 fields terminated by ',' enclosed by '"';都无法导入错误如下
The MySQL server is running with the --secure-file-priv option so it cannot execute this statement 好像没修改成功一样
b>解决:这就需要查看linux下另外一个参数
mysql load data infile 导入的各种问题
最新推荐文章于 2024-05-12 04:14:54 发布
![](https://img-home.csdnimg.cn/images/20240611030827.png)