How To Alter/Change InnoDB to MyISAM

Last update: •Date posted:
COMMENTS•0 Comments/in /Posted by MIKE DALISAY

"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. :)

Hi! I'm Mike Dalisay, the co-founder of codeofaninja.com, a site that helps you build web applications with PHP and JavaScript. Need support? Comment below or contact [email protected]

I'm also passionate about technology and enjoy sharing my experience and learnings online. Connect with me on LinkedIn, Twitter, Facebook, and Instagram.