MySQL Forums
Forum List  »  MyISAM

Mysql not allowing change of engine
Posted by: Jorge Hernandez
Date: May 30, 2014 08:17AM

Hey guys,

I'm trying to do a:

ALTER TABLE `my_table` ENGINE=MyISAM;

But I keep getting this:

"cannot delete or update a parent row: a foreign key constraint fails"

How can I change the engine of my table(s) if I'm getting that?

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql not allowing change of engine
2429
May 30, 2014 08:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.