MySQL Forums
Forum List  »  MyISAM

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Mysql not allowing change of engine
2486
Jorge Hernandez
May 30, 2014 08:17AM
Re: Mysql not allowing change of engine
1504
Rick James
May 31, 2014 07:54AM
Re: Mysql not allowing change of engine
1458
Jorge Hernandez
June 02, 2014 03:17PM
Re: Mysql not allowing change of engine
1504
Rick James
June 04, 2014 04:16PM


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.