Announcement

Announcement Module
Collapse
No announcement yet.

restore database error

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • restore database error

    Hi,

    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
Working...
X