MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:naveen Date:February 11 2004 1:06pm
Subject:Re: ERROR 1005 at line 12: Can't create table
View as plain text  
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" <victoria.reznichenko@stripped>
To: <mysql@stripped>
Sent: Wednesday, February 11, 2004 4:25 PM
Subject: Re: ERROR 1005 at line 12: Can't create table


> "naveen" <naveen_akn@stripped> 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
>  / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@stripped
> /_/  /_/\_, /___/\___\_\___/   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/mysql?unsub=1
>
>
Thread
ERROR 1005 at line 12: Can't create tablenaveen11 Feb
  • Re: ERROR 1005 at line 12: Can't create tableAleksandar Bradaric11 Feb
  • Re: ERROR 1005 at line 12: Can't create tableVictoria Reznichenko11 Feb
  • Re: ERROR 1005 at line 12: Can't create tablenaveen11 Feb
    • Re: ERROR 1005 at line 12: Can't create tableVictoria Reznichenko11 Feb