Linux系统下mysql数据库导出scv格式数据

执行命令：SELECT DISTINCT Comments,StoreName,StoreUrl,Commentator,Comments,CommentTime FROM o_comment_data limit 20000000  into outfile '/home/2qw.csv'    fields terminated by ',' optionallyy 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错误  

查看show variables like ‘%secure_file%’

将路径/home改为/var/lib/mysql-files/ 再次执行即可