convert-myisam-tables-to-innodb.sh

#!/bin/bash

# Variables definitions
DBNAME="tony_local_test"
MYSQL_COMMON="-uroot -D$DBNAME"
SQL_QUERY="SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = '$DBNAME' AND ENGINE='MyISAM';"
ALTER_TABLE_QUERY=""

# Build up one giant SQL string.
for i in `mysql $MYSQL_COMMON --skip-column-names -s -e "$SQL_QUERY"`; do
  ALTER_TABLE_QUERY=$ALTER_TABLE_QUERY"ALTER TABLE $i ENGINE=InnoDB;"
done

# Execute that long-ass query.
mysql $MYSQL_COMMON -e "$ALTER_TABLE_QUERY";