How to change the engline type from InnoDb to MyISAM of an existing db?

All we need is an easy explanation of the problem, so here it is.

I have a MariaDb database which consists of 2 tables and which is around 10Gb of the size. One is dependendant on the other via a foreign key.

How can I change the engine type of that particular db from InnoDb to MyISAM?

How to solve :

I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.

Method 1

To simply answer your question, I would turn off foreign key checks and unique checks, then convert it


You should remove the foreign key afterwards.

Why you do want to change it to MyISAM is another story.

Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂

All methods was sourced from or, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply