各位大神中秋快樂
有一個菜鳥問題請教, 我在匯入csv檔案到mysql的時候,
利用data infile寫入, 系統提示secure_file_priv的問題
我使用的是centos 8系統, 查找到預設的路徑為 'var/lib/mysql-files'
因為我不想把mysql重啟, 于是不去修改my.cnf的檔案, 選擇把我要放的csv放到var/lib/mysql-files底下
但是系統還是持續報錯..
程式如下：
mysql> show variables like "secure_file_priv";
+------------------+-----------------------+
| Variable_name | Value |
+------------------+-----------------------+
| secure_file_priv | /var/lib/mysql-files/ |
+------------------+-----------------------+
1 row in set (0.01 sec)
mysql> load data infile '/var/lib/mysql-files/master.clientlist.csv'
-> into table agentcompany_compare
-> fields terminated by ','
-> lines terminated by '\n'
-> ignore 1 rows;
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
接近崩潰, 求各位大神指教
uj5u.com熱心網友回復：
這個能跑動了, 但甚麼都寫不進去mysql> load data infile '/var/lib/mysql-
files/clientlist.csv' into table agentcompany_compare
-> fields terminated by ','
-> lines terminated by ';\n'
-> ignore 1 rows;
Query OK, 0 rows affected (0.01 sec)
Records: 0 Deleted: 0 Skipped: 0 Warnings: 0
也有試過其他組合:
mysql> load data infile '/var/lib/mysql-
files/clientlist.csv' into table agentcompany_compare
-> fields terminated by ','
-> lines terminated by ';\n';
ERROR 1300 (HY000): Invalid utf8mb4 character string:
'idagentcompany acid acname actel acaddress
logo
1 1 "
'
mysql> load data infile '/var/lib/mysql-
files/clientlist.csv' into table agentcompany_compare
-> fields terminated by ','
-> lines terminated by '\r\n';
ERROR 1366 (HY000): Incorrect integer value:
'idagentcompany acid acname actel acaddress
logo' for column 'idagentcompany' at row 1
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/149809.html
標籤：MySQL
上一篇：關于二個表關聯查詢的SQL寫法