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?

Improve this question
1
  • You should at least consider Aria as an alternative that has crash safety. What are you hoping to achieve with these changes? Commented Aug 4, 2022 at 23:02

1 Answer 1

Reset to default
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.

Improve this answer

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.