I honestly don't know anything about mySQL.

I have a mySQL dump file which I need to edit in excel, so I assume I need to convert it to a CSV? How do I do this?

Thanks!

To my knowledge you will not be able to convert the actual dump file to anything else, your best bet is to get access to the mysql server and dump out in CSV.

dam

There are some perl routines on the net that convert from mysql dump to postgres. If you know just a little bit of perl, you could hack one of those to dump CSV.

Dumping CSV from the server would be better though.

maybe try importing to MS Access first, then extract to Excel...?

CapCity-

Thanks, I tried that, and got an "unrecognized database" error.

I'll just try to get the CSV dump, thanks guys.

is the MySQL dump file just a bunch of DDL statements with the data? I am not sure, but I think I read/heard that...

If so, MySQL probably just has some minor SQL dialect differences with which if you can locate them and then find/replace them for say MS Access or SQLServer dialect(s) - the import may work.

I know there are tools you can purchase to do this - not sure if that is an option. Perhaps they have trial versions?

Check out one of the MySQL front end programs. I'm almost positive I've done this through one of those. It should create a CSV file directly from the data being accessed.

Agree with 91AggieLawyer. I believe the MySQL Admin Tools pack can export tables to csv. I'm almost positive I've done this. Either the admin tools, or the query browser.