Link to home
Start Free TrialLog in
Avatar of phpzilla
phpzilla

asked on

Mysqldump in CSV format

I need to dump ALL tables in mysql in CSV format.

Is there a command using mysqldump to JUST output every row for every table in CSV format?
Avatar of David L. Hansen
David L. Hansen
Flag of United States of America image

Here is one solution:
http://download.cnet.com/SqlToTxt/3000-2247_4-10872060.html?tag=mncol;1
It is called sqltotxt (it is free to try but costs $60 to use full-featured).

There is also this solution (which is free but a little messier).  If you are comfortable dabbling in sql scripts this may be the way to go.
ASKER CERTIFIED SOLUTION
Avatar of johanntagle
johanntagle
Flag of Philippines image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial