eXtreme Development

MySQL - converter tabela myISAM em innoDB

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


SourceForge BootStrap