CSV文件导入mysql报错
mysql> load data infile '/u01/my3306/data/test/test.csv'
-> into table ld_csv1
-> fields terminated by ',' optionally enclosed by '"' escaped by '"'
-> lines terminated by '\r\n';
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
1. 查看mysql secure_file_prive的值
mysql> show variables like "secure_file_priv";
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| secure_file_priv | NULL | # NULL:限制mysqld不允许导出
+------------------+-------+
1 row in set (0.00 sec)
secure_file_priv=/tmp/ :限制mysqld的导入导出只能发生在/tmp/目录下
secure_file_priv=' '