MySQL 5.7向表导入数据报错 ERROR 13 HY000 Can t get stat of

发布时间：2022-04-04 11:00:39 所属栏目：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): Cant get stat of /var/lib/mysql-files/ADDSubscribers_MSISDN.txt (Err

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

（编辑：爱站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!

MySQL锁的分类与算法	如何设置mysql字符集为
mybatis if test非空判	mysql复制超时排查