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]