NewsForge: MySQL Migration: MyISAM to InnoDB

“The MySQL database is unique in that it offers multiple storage
engines. The SQL parser and front end interfaces are separate from
the storage engines, so you can choose among nine low-level table
formats the one that suits your application best. I recently needed
to convert a production application from the default indexed
sequential format, MyISAM, to InnoDB. Here’s my no-hassle guide to
performing the conversion.

“Why would you want to convert an existing MySQL database from
MyISAM to InnoDB? While the MyISAM format has low overhead and
generally the fastest performance among MySQL storage engines, it
does not have advanced features like transactions, rollbacks, and
row-level locking…”

Complete
Story