Mysqldump - dump insert statements only

If you are only interested in generating the insert statements (i.e. exclude create/drop table, comments, locks, and stuff like that) you may want to use the --compact -t options. I normally use it when I want to do bulk inserts and create a table a priori without indexes.

No comments: