where the flamingcow roams

Convert all tables to InnoDB

Here’s a little bit of SQL to convert all tables in the current database to the InnoDB storage engine. It’s written for MySQL 5.0, and relies on the column count of SHOW TABLE STATUS, so it might take tweaking to work on other versions.