Export MySQL to CSV using UNIX

Question

Is it possible to Export a MySQL to a CSV using the command line in UNIX?

Jon Black · Accepted Answer · 2010-03-23 23:11:14Z

4

answered Mar 23, 2010 at 23:11

Jon Black

16.6k5 gold badges45 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

you almost beat the 30 second rule - they should award badges for that type of victory

Seamus Abshere · Accepted Answer · 2011-03-16 15:08:48Z

1

If you have Ruby, you can use the mysql2xxxx gem

gem install mysql2xxxx
mysql2csv --username=root --password=password --execute "select * from mytable" > mytable.csv

It's not as fast as mysqldump, but you don't need to be on the same computer as the MySQL server. It also provides mysql2xml and mysql2json.

answered Mar 16, 2011 at 15:08

Seamus Abshere

8,5264 gold badges49 silver badges61 bronze badges