# Conversation from innodb engine to myiasm engine

**URL:** <https://forums.percona.com/t/conversation-from-innodb-engine-to-myiasm-engine/4057>\
**Category:** Other MySQL® Questions\
**Created:** [February 16, 2015, 4:26am UTC](https://forums.percona.com/t/conversation-from-innodb-engine-to-myiasm-engine/4057 "2015-02-16T04:26:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![malakari](https://avatars.discourse-cdn.com/v4/letter/m/f04885/32.png) [@malakari](https://forums.percona.com/u/malakari)\
**Post date:** [February 16, 2015, 4:26am UTC](https://forums.percona.com/t/conversation-from-innodb-engine-to-myiasm-engine/4057/1 "2015-02-16T04:26:11Z")

</div>

The following error I am getting while converting from innodb engine to myiasm engine please let me know resolution  
Cannot delete or update a parent row: a foreign key constraint fails

---

<div class="post-metadata">

**Author:** ![scott.nemes](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/scott.nemes/32/5_2.png) [@scott.nemes](https://forums.percona.com/u/scott.nemes)\
**Post date:** [February 16, 2015, 11:27am UTC](https://forums.percona.com/t/conversation-from-innodb-engine-to-myiasm-engine/4057/2 "2015-02-16T11:27:10Z")

</div>

Hi malakari;

MyISAM does not support foreign keys. If you want to convert your tables to MyISAM, you will need to drop the foreign key constraints first and then do the conversion.

[URL][http://dev.mysql.com/doc/refman/5.5/en/alter-table.html[/URL]](http://dev.mysql.com/doc/refman/5.5/en/alter-table.html%5B/URL%5D)

-Scott