What's the best way to convert from MyIASM to INNODB?

[Velvet Elvis]

OK, after five years my forum as grown to the point where MyIASM is no longer cutting it. Both traffic and the total number of posts has increased to the point where a table lock or search can lead hitting cache hard.. I've been regularly throwing more RAM at it for years but that's not going to cut it, plus I want to use Sphinx.

I know how to convert it one table at a time but I'm looking for suggestions on how to script it so I can convert the whole db at once.

Any ideas?

[phinsup]

ALTER TABLE tablename ENGINE = INNODB;

[ensoph]

ALTER TABLE tablename ENGINE = INNODB;

I know how to convert it one table at a time but I'm looking for suggestions on how to script it so I can convert the whole db at once.

[Martin A.]

http://highervisibilitywebsites.com/convert-your-mysql-database-myisam-innodb-and-get-ready-drupal-7-same-time
First hit on Google.

My test showed that the "perl" part of the script wasn't needed.