All geek questions in one place

What is the safest way to convert a table from InnoDB to MyISAM?

My database currently uses the InnoDB engine. Now I want to add a full-text search function, so I want to convert my tables to MyISAM. But this violates all foreign keys. How can I safely change my table engines to MyISAM?

How can I use SELECT ... JOIN after I change my tables to the MyISAM engine?

ALTER TABLE jobs ENGINE = MyISAM; Cannot delete or update a parent row: a foreign key constraint fails
+6
source share
2 answers

I would recommend you dump db, change all text from this file from InnoDB to MyISAM, and then upload the modified file

+6
source

As I know, MyISAM does not support foreign keys (compare the functions offered by InnoDB compared to the functions of MyISAM ). MySQL is trying to tell you that you need to remove every foreign key constraint that references the jobs table before changing your engine to MyISAM.

+4
source

Source: https://habr.com/ru/post/904057/

More articles:


All Articles