MySQL Forums
Forum List  »  MyISAM

Re: Mysql not allowing change of engine
Posted by: Rick James
Date: May 31, 2014 07:54AM

Apparently you have something a FOREIGN KEY that wants to do ON DELETE CASCADE?

DROP the FOREIGN KEYS before moving to an ENGINE that does not handle FOREIGN KEYs (such as MyISAM).

Why are you moving _to_ MyISAM? These days, that is ill-advised.

Options: ReplyQuote

Written By
Re: Mysql not allowing change of engine
May 31, 2014 07:54AM

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.