1

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?

1
  • You should at least consider Aria as an alternative that has crash safety. What are you hoping to achieve with these changes?
    – danblack
    Aug 4 at 23:02

1 Answer 1

0

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.