#!/bin/bash

DIR=$( dirname "$0" )

echo "SELECT CONCAT('ALTER TABLE \`', TABLE_SCHEMA,'\`.\`',TABLE_NAME, '\` ENGINE = InnoDB;') FROM information_schema.TABLES WHERE ENGINE='MyISAM' AND TABLE_SCHEMA NOT IN('mysql','information_schema','performance_schema');" | mysql > "$DIR"/convert.sql
mysql < "$DIR"/convert.sql
rm "$DIR"/convert.sql