How To Alter/Change InnoDB to MyISAM

“What? MySQL Fulltext Search is not working!”
Well, this is what I thought before. I used to have MyISAM tables when developing an application. I never thought about table types.

I then realized that I was using InnoDB table type where MySQL Fulltext search is not working.  So I had to alter the table from InnoDB to MyISAM.


Here’s the code:

ALTER TABLE table_name ENGINE = MyISAM;

table_name
-It is the name of your table.

And that solved my problem! :)

In case that you want to get it back to InnoDB, here’s the code:

ALTER TABLE table_name ENGINE = InnoDB;

If you have any inquiries/comments/questions/suggestions, just comment to this post. :)

By Mike Dalisay

I'm Mike Dalisay, a pro web developer since 2010. I love web development. Improving our tutorials and source codes makes me happy. Do you want to suggest an edit to our tutorial? Got something to ask about our source codes? Email our team at [email protected]