ERROR 1290 (HY000): The MySQL server is running with the –secure-file-priv option so it cannot execute this statement

ERROR 1290 ao exportar para .csv

mysql> SELECT * FROM alunos
		INTO OUTFILE '/tmp/alunos.csv'
		FIELDS ENCLOSED BY '"'
		TERMINATED 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

mysql> SELECT * FROM alunos

INTO OUTFILE '/tmp/alunos.csv'

FIELDS ENCLOSED BY '"'

TERMINATED 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

Edite o arquivo /etc/my.cnf Adicione a linha

secure-file-priv = ""

1	secure-file-priv = ""

Exportando novamente

mysql> SELECT * FROM alunos
    -> INTO OUTFILE '/tmp/alunos.csv'
    -> FIELDS ENCLOSED BY '"'
    -> TERMINATED BY ';'
    -> ESCAPED BY '"'
    -> LINES TERMINATED BY '\r\n';
Query OK, 8000 rows affected (0.00 sec

mysql> SELECT * FROM alunos

-> INTO OUTFILE '/tmp/alunos.csv'

-> FIELDS ENCLOSED BY '"'

-> TERMINATED BY ';'

-> ESCAPED BY '"'

-> LINES TERMINATED BY '\r\n';

Query OK, 8000 rows affected (0.00 sec

Resolvido!