"naveen" <[EMAIL PROTECTED]> wrote:
> thanks Victoria Reznichenko
>
> for your help
> where will i put this parameter
> SET FOREIGN_KEY_CHECKS = 0;
> in the dump file or under mysql pormpt.I added through mysql but still the
> same error comes.
You should put
SET FOREIGN_KEY_CHECKS = 0;
at the
toria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 11, 2004 4:25 PM
Subject: Re: ERROR 1005 at line 12: Can't create table
> "naveen" <[EMAIL PROTECTED]> wrote:
> > Hi
> > when i try to put the data(xyz.s
"naveen" <[EMAIL PROTECTED]> wrote:
> Hi
> when i try to put the data(xyz.sql) taken using mysqldump commant
>
> bin/mysql --user=root --password=secret xyz < xyz.sql
>
> ERROR 1005 at line 12: Can't create table './XYZ/Bcl.frm' (errno: 150)
Hi,
C:\mysql\bin>perror 150
Error code 150: Unknown error
150 = Foreign key constraint is incorrectly formed
Take care,
Aleksandar
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi
when i try to put the data(xyz.sql) taken using mysqldump commant
bin/mysql --user=root --password=secret xyz < xyz.sql
ERROR 1005 at line 12: Can't create table './XYZ/Bcl.frm' (errno: 150)
what is this comming,why is it comming.
with regards
naveen
