echo "SELECT concat('ALTER TABLE `',TABLE_NAME,'` ENGINE=InnoDB;') FROM Information_schema.TABLES WHERE ENGINE != 'InnoDB' AND TABLE_TYPE='BASE TABLE' AND TABLE_SCHEMA='name-of-database'" | mysql > convert.sql