建站
咨詢
售后
建站咨詢
新聞中心
這里有您想知道的互聯(lián)網(wǎng)營銷解決方案
MySQL5.7向表導(dǎo)入數(shù)據(jù)報錯"ERROR13(HY000):Can'tgetstatof"
MySQL 5.7向表導(dǎo)入數(shù)據(jù)時報錯：
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)
本文標(biāo)題：MySQL5.7向表導(dǎo)入數(shù)據(jù)報錯"ERROR13(HY000):Can'tgetstatof"
轉(zhuǎn)載來于：http://www.dlmjj.cn/article/pgpgss.html
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參數(shù)
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
在load語句中加上local參數(shù)
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
本文標(biāo)題：MySQL5.7向表導(dǎo)入數(shù)據(jù)報錯"ERROR13(HY000):Can'tgetstatof"
轉(zhuǎn)載來于：http://www.dlmjj.cn/article/pgpgss.html
