"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]
