I was Converting my Database Engine from Innodb to MyISAM and i got the following error

“Cannot delete or update a parent row: a foreign key constraint fails”

Solution:

I took the entire backup of the DB and edited the file and changed the  ”ENGINE=MyISAM” and restored it to a new DB.

Post By Gishore J Kallarackal (2,121 Posts)

Gishore J Kallarackal is the founder of techgurulive. The purpose of this site is to share information about free resources that techies can use for reference. You can follow me on the social web, subscribe to the RSS Feed or sign up for the email newsletter for your daily dose of tech tips & tutorials. You can content me via @twitter or e-mail.

Website: → Techgurulive

Connect