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;
>
>
>> Original Message
>
e`)
) TYPE=InnoDB;
> Original Message
> From: [EMAIL PROTECTED]
> Date: 30/04/2005 13:52
> To: mysql@lists.mysql.com
> Subj: Re: mysqldump generates invalid code
>
> Hello.
>
> Make the dump using --quote-names option for mysqldump. Does it solve
>
Hello.
Make the dump using --quote-names option for mysqldump. Does it solve
the problem? You have an old MySQL version. I strongly recommend you to
upgrade.
>I backup a db using mysqldump, but when I come to execute the sql file
>on an empty db I
>get this
>C:\xampp\xampp\mysql\b
I backup a db using mysqldump, but when I come to execute the sql file on an
empty db I get this
C:\xampp\xampp\mysql\bin>mysql -uroot db2 < test3.txtERROR 1005 at line
54: Can't create table '.\db2\shift.frm' (errno: 150)
C:\xampp\xampp\mysql\bin>
I have tried to fix the foreign key constraint (
