Curtis Maurand wrote:
I don't know if anyone else is having this trouble, but mysqldump for me
does not dump the database in the correct order in order to load the
tables back in. Usually I get failures for dependency issues (tables
depending on other tables that haven't been created, yet.). I've found
that I've had to dump the tables one at a time and then restore them the
proper order.
I guess your problem is that before you load the dump back in, you don't do:
mysql> SET FOREIGN_KEY_CHECKS = 0;
This should work, after the source'ing you set it back to "1". If that's
not it, what error do you get?
IMHO the order doesn't matter and it's actually alphabetical.
HTH,
Alex
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
