Im getting in trouble trying to restore a .sql dump generated with mysqldump for a database with lots of foreign keys because of the order of tables in the .sql. the first table already declares a FOREIGN KEY referencing a table not yet created, halting with a 'cant create blahblahblah'.
(ERROR 1005 at line 11: Can't create table './sdb_teste/alertas.frm' (errno: 150)) Any solutions to this problem? Sergio Bruder -- http://pontobr.org pub 1024D/0C7D9F49 2000-05-26 Sergio Devojno Bruder <[EMAIL PROTECTED]> Key fingerprint = 983F DBDF FB53 FE55 87DF 71CA 6B01 5E44 0C7D 9F49 sub 1024g/138DF93D 2000-05-26 --------------------------------------------------------------------- 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