MySQL a CSV

Forma fácil de dumpear una consulta de mysql a csv:

SELECT * INTO OUTFILE '/tmp/salida'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n'
from table;

Se debe ejecutar como root.