MySQL Forums
Forum List  »  Backup

Advanced Search
New Topic

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;

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
load from mysqldump fails with ERROR 1005 (HY000) at line 4567: Can't create table './ecom/tAddress.frm' (errno: 150)
18073
Mike Wood
October 17, 2005 06:15PM
Re: load from mysqldump fails with ERROR 1005 (HY000) at line 4567: Can't create table './ecom/tAddress.frm' (errno: 150)
12514
Mike Wood
October 18, 2005 12:40PM
Re: load from mysqldump fails with ERROR 1005 (HY000) at line 4567: Can't create table './ecom/tAddress.frm' (errno: 150)
7224
wod wod
April 22, 2006 12:52PM


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.