Convert all MyISAM tables in all databases on a server to InnoDB

mysql-convert-myisam-to-innodb.sh

#!/bin/bash

for t in $(mysql --batch --column-names=false -e "select concat(TABLE_SCHEMA, '.', TABLE_NAME) from INFORMATION_SCHEMA.TABLES where ENGINE = 'MyISAM' and TABLE_TYPE = 'BASE TABLE' and TABLE_SCHEMA <> 'mysql'" mysql); do
	mysql -e "alter table $t type=InnoDB";
done