I have a schema with innodb and myisam tables. I have generated a dump like this:
mysqldump -uuser -ppass -R -q --compact dbname > file.sql
When i try to restore it in a new schema
mysql -user -ppass dbname < file.sql
the next error appears:
ERROR 1005 (HY000) at line 72: Can’t create table ‘./dbname/table.frm’ (errno: 150)
The table has references to another table that is not created yet.
If i delete the references statements for that table, it is created.
How can i restore it without delete table references?
Thanks for your help