## Convert ALL InnoDB tables in ALL databases to MyISAM
# This command will continue even if an individual table fails to convert.
# output is saved to convert-to-myisam.log
mysql -Bse 'SELECT CONCAT("ALTER TABLE ",table_schema,".",table_name," ENGINE=MyISAM;") FROM information_schema.tables WHERE table_schema NOT IN ("mysql","information_schema","performance_schema") AND Engine = "InnoDB";' | while read -r i; do echo $i; mysql -e "$i"; done | tee convert-to-myisam.log