tools for exporting mysql db into csv files

Question

are there any solid tools (preferably command line tools for linux) for exporting mysql db into csv files? it needs to follow csv standards properly and handle all the newline character and other special characters properly. select * into table does not seem to be properly converting the data correctly.

user330315 · Accepted Answer · 2012-01-14 20:40:01Z

1

Try SQL Workbench/J.

It is Java based (therefor platform independent) and works on the commandline, in batch mode and as a GUI tool.

You have full control over the export format (including handling of special characters) using the WbExport command.

answered Jan 14, 2012 at 20:40

user330315

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

Comments

Milad Naseri · Accepted Answer · 2012-01-14 19:51:15Z

1

You can use phpmyadmin. It has an Export feature that does that splendidly.

answered Jan 14, 2012 at 19:51

Milad Naseri

4,1281 gold badge30 silver badges40 bronze badges

Comments

Mohammad Saberi · Accepted Answer · 2012-01-14 19:52:30Z

1

There are different tools for it:

answered Jan 14, 2012 at 19:52

Mohammad Saberi

13.2k28 gold badges81 silver badges132 bronze badges

Collectives™ on Stack Overflow

tools for exporting mysql db into csv files

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related