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.