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.
can you please help me in that with regards Naveen ----- Original Message ----- From: "Victoria 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.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. > > You can use SHOW INNODB STATUS command to see latest InnoDB foreign key error message. > > Most likely in the dump file child table is located before parent table. Use SET FOREIGN_KEY_CHECKS = 0 command to turn off foreign key checks. > > SET FOREIGN_KEY_CHECKS = 0; > SOURCE dump_file; > SET FOREIGN_KEY_CHECKS = 1; > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]