ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
Mysql client 로 연결후 SHOW variable 로 MySQL 환경 변수 확인
mysql> SHOW VARIABLES LIKE "secure_file_priv";
+------------------+-----------------------+
| Variable_name | Value |
+------------------+-----------------------+
| secure_file_priv | /var/lib/mysql-files/ |
+------------------+-----------------------+
1 row in set (0.02 sec)
CODE
INTO OUTFILE 의 저장 경로를 위의 secure_file_priv 폴더로 변경
INTO OUTFILE '/tmp/orders.csv' → INTO OUTFILE '/var/lib/mysql-files/orders.csv'