How to convert MyISAM to InnoDB

Question

I'm using MySQL 5, and my database experienced some corruption last week. The technicians at my web host managed to save it, but the tables are all converted from the original InnoDB to MyISAM. Currently, some functions in my eCommerce application does not work.

Is there a easy way for me to convert them back to InnoDB again? I can't find anything in phpMyAdmin. Do I need to write a PHP script?

Thanks.

Answer 1

You can run this query:

ALTER TABLE table_name ENGINE = InnoDB;

on all tables

Answer 2

If you want do this By Mysql application you can use MySQLQueryBrowser.exe or SQLYoq.exe in both of them you can alter Table and choose DB Engine