Converting from MyISAM to InnoDB
January 15th, 2007
The innodb engine is not enabled in MySQL by default (in my dist at least), so it first has to be enabled in the configuration file. Just commenting out “skip-innodb” didn’t work for me, I had to explicitly add “innodb” to configuration to enable the engine.
Some basic configuration options and a shell script for converting a bunch of tables at once might also come in handy.
Sorry, comments are closed for this article.