【MySQL报错】ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
mysql 默认对导出的目录有权限限制,也就是说使用命令行进行导出的时候,需要指定目录进行操作;
解决方法:
方法一:
使用语句查询secure_file_priv 的值:show global variables like '%secure%';
方法二:
使用 into outfile 开始导出:(因为secure_file_priv配置的关系,所以必须导出到 /var/lib/mysql-files/目录下)
select * from table_name where a = 'test' into outfile '/var/lib/mysql-files/test.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
PS:FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ' " ' LINES TERMINATED BY '\n';因为导出的数据会出现一些乱码或者特殊字符,所以使用以上关键字进行转义
不幸运的人也有被眷顾的权利