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:


-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? You may use our comments section below or email our team at [email protected]

Leave a comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back to top