Hello, i have a problem with foreign key constrains.
If i dump some tables (type = innodb) with mysqldump, i get a dump, which is in alphabetical order. The problem is now, if the first table has an foreign key to the second table, i will get an error, if i dump the dump into the database. How i can fix that? My idea is a simple Perl script, witch dump all the tables alone with a given order and then ad them all to one (dump-) file ... if mysql has not a right "features" against that problem. Sören --------------------------------------------------------------------- Im Juni geht's ab! Die MTV Campus-Invasion rockt die Unis mit absoluten Top-Acts: Silverchair, Reamonn, Naidoo und viel andere. Mehr unter http://www.firstcampus.com/de/ --------------------------------------------------------------------- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php