mysqldump导出整张表
当前应用场景为查询部分数据,并导出
mysql> select * from node_status where node_id = '12020120' into outfile '/home/node.csv';
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
导出文件失败,原因在于 没有导出文件到mysql设置的–secure_file_priv路径中,没有权限
解决:
mysql> show variables like '%secure%';
+--------------------------+-----------------------+