Page 1 of 1

MySQL Dump options

Posted: Fri Oct 16, 2009 8:48 am
by GeXus
I'm trying to dump only the create statements from a database and only the insert statements with data, basically as two separate dumps. Any idea how to do this?

I've tried this:

Code: Select all

 
mysqldump --complete-insert database_name
 
But just say's there's an error in my sql... can't seem to figure it out.

Re: MySQL Dump options

Posted: Fri Oct 16, 2009 4:14 pm
by pickle
There's some pretty good documentation on mysqldump. If you have access to the command line, man mysqldump would be the best place to start.