Export Database in a batch

[dluconsu]

I exported the whole database into a batch file. The tables in the database have foreign key referencial integrity constraint. The tables are in alphabetical order in the script generated, therefore the script might not be generated in a “parent-table first, child-table later” manaer. Since the parent table must be created before the child table can be created, this makes the generated script un-runnable.

Another complain is the coding style of the script. It is not pretty-printed and keywords are not in upper case.

[CalEvans]

1: check the box SET FOREIGN_KEY_CHECKS=0 (yea, I know it's not real intuitive unless you know what that command does in mysql) That will turn off the FK checking for the import.

2: So? Other than for grins and giggles, do you ever actually READ the code generated by export? 🙂 (FWIW, I always use mysqldump for this anyhow…old habits die hard and I'm used to the way it outputs.)

HTH,

=C=

[Author]

Posts