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]