Convert MyISAM to InnoDB

A quick and simple way to convert it.

SELECT CONCAT(  'ALTER TABLE ', table_schema,  '.', table_name,  ' engine=InnoDB;' ) FROM information_schema.tables WHERE ENGINE =  'MyISAM' AND table_schema =  'xxx' LIMIT 0 , 200

xxx is the database name. Then show it in myphpAdmin in full text. Then copy and paste the generated SQL query again to SQL field to run it again.

Advertisements