Converting MyISAM to INNODB in MySql

[adi501]

Hi everybody.

This is Adi. I am trying to convert MyISAM to INNODB in mysql. I mean i want to convert all the tables in the database to MyISAM to INNODB.

I know that I can do it in two ways.
1) For each and every table and
2) For the whole database.

But i dont know how to do it. Can anyone please let me know how can i do it .

Thanks in Advance.

Regards.
Aditya

[chaosprime]

This is widely discussed stuff (http://www.linux.com/articles/46370). You should probably learn how to use Google.

[demtron]

This is possible in the MySQL table editor available in MySQL Administrator, which is available for download at the MySQL.com website.