Convert all databases and tables to InnoDB

convert-to-innodb.sh

#!/bin/sh
MYSQL="mysql --skip-column-names --batch"
for DB in $($MYSQL -e "show databases" \
            | grep -v ^information_schema$ \
            | grep -v ^mysql$
            )
do
    for TABLE in $($MYSQL --database $DB -e "show tables")
    do
        echo -n "$DB.$TABLE | $(du -sm /var/lib/mysql) | "
        $MYSQL --database $DB -e "ALTER TABLE $TABLE ENGINE=InnoDB"
        du -sm /var/lib/mysql
    done
done