MySQL 5.7向表匯入資料包錯"ERROR 13 (HY000): Can't get stat of"
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)
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
在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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【MySQL】Can't get stat of './mysql/slow_log.CSV' (Errcode: 2)MySql
- MySQL報錯'ERROR 2002 (HY000): Can't connect to local MySQL server through'MySqlErrorServer
- 【MySQL】ERROR 1005 (HY000): Can't create table' (errno: 150)MySqlError
- mysql資料匯入問題處理(ERROR 1418 (HY000))MySqlError
- Mysql報錯Fatal error:Can't open and lock privilege tablesMySqlError
- mysql匯入報錯Variable 'sql_notes' can't be set to the value of 'NULL'MySqlNull
- ERROR 2002(HY000):Can't connect to local MySQL socket '/tmp/mysql.sock'ErrorMySql
- MYSQL ERROR 2003 (HY000) CanMySqlError
- ERROR 1135 (HY000): Can't create a new threadErrorthread
- ERROR 2002 (HY000): Can't connect server socket /tmp/mysql.sockErrorServerMySql
- [ERROR] Can't open the mysql.plugin tableErrorMySqlPlugin
- MySQL 5.5 原始碼安裝報錯"[ERROR] Can't start server"MySql原始碼ErrorServer
- MySQL錯誤1042-Can't get hostname for your addressMySql
- MySQL "ERROR 1010(HY000):Error dropping database(canMySqlErrorDatabase
- ERROR 2003 (HY000)Can't connect to MySQL server on '192.168.8.247' (113)ErrorMySqlServer
- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)ErrorMySqlServerlocalhost
- ERROR 1135 (HY000): Can't create a new thread (errno 11)Errorthread
- mysql [ERROR] Can't create IP socket: Permission deniedMySqlError
- MySQL表資料匯入與匯出MySql
- MySQL報錯Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.MySqlPluginError
- linux下連線mysql報錯ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysqLinuxMySqlErrorServer
- 【MySQL】ERROR 1290 (HY000): --secure-file-priv--匯出報錯MySqlError
- ERROR 1005 (HY000): Can't create table 'starive.SC' (errno: 150)"Error
- MySQL錯誤1042-Can't get hostname for your address解決方法MySql
- MySQL 5.7 建立使用者報錯 ERROR 1805 (HY000): Column count of mysql.user is wrongMySqlError
- mysql can't connect error about privilege----not root userMySqlError
- [mysql] 批量匯入提示: Variable ‘character_set_client’ can’t be set to the value of ‘NULLMySqlclientNull
- ERROR 1005 (HY000): Can't create table'matrix.system_log' (errno: 150)Error
- 把Excel表資料匯入到mysqlExcelMySql
- MySQL 5.5 關閉資料庫報錯"Can't connect to local MySQL server through socket"MySql資料庫Server
- mysql資料匯入匯出MySql
- mysql資料匯出匯入MySql
- ERROR 2002 (HY000): Can't connect server socket /var/run/mysqld/mysqld.sockErrorServerMySql
- MySQL5.7叢集(MGR)啟動報ERROR 3092 (HY000)MySqlError
- 資料庫 MySQL 資料匯入匯出資料庫MySql
- GTID複製報錯處理:Last_Error: Error 'Can't drop database 'test';ASTErrorDatabase
- mysql匯入資料亂碼錯誤一則MySql
- 更換mysql資料目錄後出現ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) 的解決辦法MySqlErrorServer