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.