mysql -u root -p dbName -e
"show table status where Engine='MyISAM';" | awk
'NR>1 {print "ALTER TABLE "$1" ENGINE = InnoDB;"}' |
mysql -u root -p dbName
https://stackoverflow.com/questions/3856435/how-to-convert-all-tables-from-myisam-into-innodb
