本文共 651 字，大约阅读时间需要 2 分钟。
MySQL 5.7向表导入数据时报错 ： mysql> load data infile '/var/lib/mysql-files/ADDSubscribers_MSISDN.txt' into table tmp_Subscribers_01 fields enclosed by '"'; ERROR 13 (HY000): Can't get stat of '/var/lib/mysql-files/ADDSubscribers_MSISDN.txt' (Errcode: 13 - Permission denied) 解决方法： 在load 语句中加上local参数 mysql> load data local infile '/tmp/ADDSubscribers_MSISDN.txt' into table tmp_Subscribers_01 fields enclosed by '"'; Query OK, 0 rows affected, 10 warnings (0.00 sec) Records: 10 Deleted: 0 Skipped: 10 Warnings: 10 来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26506993/viewspace-2123761/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/26506993/viewspace-2123761/