MySQL Forums
Forum List  »  Backup

Re: load from mysqldump fails with ERROR 1005 (HY000) at line 4567: Can't create table './ecom/tAddress.frm' (errno: 150)
Posted by: Mike Wood
Date: October 18, 2005 12:40PM

In case anyone's searching ...

Well I solved my own problem by adding on to the front of the dumped file:
SET FOREIGN_KEY_CHECKS = 0;
and on to it's end
SET FOREIGN_KEY_CHECKS = 1;

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: load from mysqldump fails with ERROR 1005 (HY000) at line 4567: Can't create table './ecom/tAddress.frm' (errno: 150)
12509
October 18, 2005 12:40PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.