MySQL Data Dumper

SQL inserts and column names

Asked by ochedru

Is it possible to have Mydumper generate INSERT statements comprising column names? I did not find any option to control this.
I don't know what is the implicit column order, but if I want to restore my dump created with --no-schemas on a newly created schema, I guess problems will arise.
Note mysqldump has option --complete-insert to add column names to the resulting SQL dump. See http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_complete-insert.

Question information

Language:
English Edit question
Status:
Answered
For:
MySQL Data Dumper Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Max Bubenick (max-bubenick) said : 		#1

There is not option so far, but you can always create a blueprint for it.

Revision history for this message
ochedru (ochedru) said : 		#2

Done: https://blueprints.launchpad.net/mydumper/+spec/complete-insert
Thanks

Can you help with this problem?

Provide an answer of your own, or ask ochedru for more information if necessary.

To post a message you must log in.