MySQL 5.7向表匯入資料包錯"ERROR 13 (HY000): Can't get stat of"

feelpurple發表於2016-08-21
原文網址 : http://blog.itpub.net/26506993/viewspace-2123761/
MySqlError
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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章