If you need to convert all tables of a database from MyISAM (or somewhat else) to InnoDB, you can use the following Shell-Skript (Download-Link ):

#!/bin/sh

for tbl in `cat tables`
do
echo “ALTER TABLE \`$tbl\`  ENGINE = InnoDB ”
done

Please take care! Backup your database first!

Now we want to create a list containing all Tables of a specified database. At shell prompt, execute the following line:

mysql -uUSER -pPASSWD -D DATABASE_NAME -e ‘SHOW TABLES’ > tables

To process all tables, type in the following command into shell prompt:

mysql -uuser -ppasswd -D database < `convert_to_innodb.sh`

Thats all.