Hello! mysql Ver 11.18 Distrib 3.23.53, for portbld-freebsd4.7 (i386)
I have a problem with dumping data into databases. I dump the database with mysqldump into a SQL-File. So, i delete the database. Now i want to redump the SQL-File into database. SQL tells me an error. The Problem is MySQL doesn't sort table by Constrains. In the Test-Case you see what MySQL Dumps, but the problem is that 'a_table' has references to 'b_table' and 'b_table' doesn't exist on an initial dump from file into database. Test-Case: # # Tabellenstruktur für Tabelle `a_table` # DROP TABLE IF EXISTS `a_table`; CREATE TABLE `a_table` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `b_table_id` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `b_table_id` (`b_table_id`), FOREIGN KEY (`b_table_id`) REFERENCES `b_table` (`id`) ON DELETE CASCADE ) TYPE=InnoDB; # # Tabellenstruktur für Tabelle `b_table` # DROP TABLE IF EXISTS `b_table`; CREATE TABLE `b_table` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=InnoDB; -- Mit freundlichen Grüßen Enrico Stahn --- Enrico Stahn Kaiserin-Augusta-Allee 10-11, 10553 Berlin, Germany todo GmbH Tel: +49 30 726 192 0 Fax: +49 30 726 192 192 [EMAIL PROTECTED], http://www.todo.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