Bash Shell Script to Convert All MySQL Tables to use the Innodb Engine

The following, when run in the Bash shell, will convert the engine for all of your MySQL tables to InnoDB. mysql -B -N -e “SHOW TABLES” -u –password= | while read table; \ do \ echo “+ Converting Table $table”; \ mysql -B -N -e “alter table $table engine=innodb” -u –password= ; \ done; Often,… Continue reading Bash Shell Script to Convert All MySQL Tables to use the Innodb Engine