xavodim

I recently needed to convert a MySQL table in a blog database from InnoDB to the engine MyISAM. This was needed because InnoDB doesn’t support the FULLTEXT, which is required to run ‘WordPress Related Entries 2.0‘. I was getting frustrated at first, but I finally found a quick explanation on what SQL statement could easily convert a table into whatever database engine you prefer. Here’s the code I found on MySQL Developer’s website:

ALTER TABLE myTable ENGINE=MYISAM

Of course you could replace MYISAM with whataver engine you want you table to run in (InnoDB, ISAM, HEAP, etc.).

Here’s a better better explanation of the differences between the various MySQL database engines from Builder.com. I only changed the posts table in the Wordpress database, as I don’t really see a need to switch any of the other tables yet. Since MyISAM is the fastest engine for multiple reads I might change my mind later, but at this point I don’t think its necessary.

Technorati Tags: MySQL, database, engines, InnoDB, MyISAM, tools, Wordpress, plugins

Bookmarking: Del.icio.us | Digg | reddit | Furl | Spurl

Responses are currently closed, but you can trackback from your own site.