can't drop innodb table
Hello, I've got an innodb that I try to drop: drop table markets; ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails Ok, I check with show innodb status : 050401 11:13:41 Cannot drop table `dabase/markets` because it is referenced by `dabase/last` then : drop table last; ERROR 1051 (42S02): Unknown table 'last' I'm a bit lost there, how can I drop this table ? (I want to recreate it with innodb_file_per_table option afterwards) -- Philippe Poelvoorde COS Trading Ltd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: can't drop innodb table
Hello. I think that SET FOREIGN_KEY_CHECKS = 0; could help you. Philippe Poelvoorde [EMAIL PROTECTED] wrote: Hello, I've got an innodb that I try to drop: drop table markets; ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails Ok, I check with show innodb status : 050401 11:13:41 Cannot drop table `dabase/markets` because it is referenced by `dabase/last` then : drop table last; ERROR 1051 (42S02): Unknown table 'last' I'm a bit lost there, how can I drop this table ? (I want to recreate it with innodb_file_per_table option afterwards) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [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]
Re: can't drop innodb table
Gleb Paharenko wrote: Hello. I think that SET FOREIGN_KEY_CHECKS = 0; could help you. Thanks, I didn't think about it. I've I dumped the DB and recreate it instead. Philippe Poelvoorde [EMAIL PROTECTED] wrote: Hello, I've got an innodb that I try to drop: drop table markets; ERROR 1217 (23000): Cannot delete or update a parent row: a foreign key constraint fails Ok, I check with show innodb status : 050401 11:13:41 Cannot drop table `dabase/markets` because it is referenced by `dabase/last` then : drop table last; ERROR 1051 (42S02): Unknown table 'last' I'm a bit lost there, how can I drop this table ? (I want to recreate it with innodb_file_per_table option afterwards) -- Philippe Poelvoorde COS Trading Ltd. +44.(0)20.7376.2401 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]