MySQL 5.7向表导入数据报错"ERROR 13 (HY000): Can't get stat of"

发布时间：2020-08-10 14:25:06 来源：ITPUB博客阅读：773 作者：feelpurple 栏目：MySQL数据库

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

向AI问一下细节

MySQL 5.7向表导入数据报错"ERROR 13 (HY000): Can't get stat of"

猜你喜欢

最新资讯

相关推荐

相关标签