Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
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?
To simply answer your question, I would turn off foreign key checks and unique checks, then convert it
SET FOREIGN_KEY_CHECKS = 0;
SET UNIQUE_CHECKS = 0;
ALTER TABLE tblname ENGINE=MyISAM;
You should remove the foreign key afterwards.
Why you do want to change it to MyISAM is another story.
Required, but never shown