Dump database to csv format

SELECT *FROM the_tableINTO OUTFILE '/tmp/the_table.csv'FIELDS TERMINATED BY ','ENCLOSED BY '"'LINES TERMINATED BY '\n';

References:
Save MySQL query results into a text or CSV file | a Tech-Recipes Tutorial