Export MySQL data to csv

MySQL data can be exported to CSV and many other formats using MySQL Workbench

http://dev.mysql.com/doc/workbench/en/mysqldbexport.html

You can use command as

Go to place where you installed workbench say

C:\Program Files\MySQL\MySQL Workbench 5.2 CE\utilities>

Run the command below

mysqldbexport --server=username:password@locahost:3306 --format=csv --file-per-table --export=both databaseName

What above command is saying is

Connect to localhost using username and password

Create csv file for per table data

Create in csv format

Export both data and Table definitions

It would create csv files in the utilities folder.

You can read more about command at link above. You can easily specify the output display format. Permitted format values are sql, grid, tab, csv, and vertical. The default is sql.