I created a mysqldump with --quote-names option, but I get this
error:C:\xampp\xampp\mysql\bin>mysql -uroot db2 < test5.txtERROR 1005 at
line 54: Can't create table '.\db2\shift.frm' (errno:
150)C:\xampp\xampp\mysql\bin>Line 54 is the CREATE TABLE... line of the following
bit of SQL from the file, and the original database created on the same server works
fine.How is it that mysqldump can successfully create the sql file, but the code it has
generated fails to create a new database. Can any one say what might be wrong with the
foreign key format (err 150) or mysqldump.exe
I have MySQL 4.0.18 and mysqldump Ver 9.10 Distrib 4.0.17, for Win95/Win98 (i32) as
supplied to me.Andrew HCREATE TABLE `shift` ( `staff` char(20) NOT NULL default '',
`shift` char(1) NOT NULL default '', `client` char(20) default NULL, `role` char(1)
default NULL, `on` date NOT NULL default '0000-00-00', PRIMARY KEY
(`staff`,`shift`,`on`), KEY `staff` (`staff`,`role`), KEY `shift` (`shift`), KEY
`client` (`client`), KEY `role` (`role`), CONSTRAINT `shift_ibfk_1` FOREIGN KEY
(`staff`, `role`) REFERENCES `staffrole` (`uniquename`, `role`), CONSTRAINT
`shift_ibfk_2` FOREIGN KEY (`shift`) REFERENCES `shifttype` (`shift`), CONSTRAINT
`shift_ibfk_3` FOREIGN KEY (`client`) REFERENCES `client` (`uniquename`), CONSTRAINT
`shift_ibfk_4` FOREIGN KEY (`staff`) REFERENCES `staff` (`uniquename`), CONSTRAINT
`shift_ibfk_5` FOREIGN KEY (`role`) REFERENCES `roletype` (`role`)) TYPE=InnoDB;
