Convert tables to other Engine - 2014-08-14 16:21:00

La ultima vez que trate de convertir todas las tablas de engine a otro fue un dolor de cabeza. Esto lo hace mas facil: SET @DATABASE_NAME = 'name_of_your_db'; SELECT CONCAT('ALTER TABLE ', table_name, ' ENGINE=InnoDB;') AS sql_statements FROM information_schema.tables AS tb WHERE table_schema = @DATABASE_NAME AND `ENGINE` = 'MyISAM' AND `TABLE_TYPE` = 'BASE TABLE' ORDER BY table_name DESC; http://stackoverflow.com/questions/3856435/how-to-convert-all-tables-from-myisam-into-innodb