How can I determine type of mysql database : whether it is InnoDB or MyISAM ?

Question

• How can I determine type of mysql database : whether it is InnoDB or MyISAM ?
• How can I convert MyISAM to InnoDB or vice-versa ?

Answer 1

Regarding converting myIsam to Innodb

http://dev.mysql.com/doc/refman/5.0/en/converting-tables-to-innodb.html

Answer 2

To determine the storage engine being used by a table, you can use show table status. The Engine field in the results will show the database engine for the table. Alternately, you can select the engine field from information_schema.tables:

select engine 
from   information_schema.tables 
where  table_schema = 'schema_name'
   and table_name = 'table_name'

You can change between storage engines using alter table:

alter table the_table engine = InnoDB;

Where, of course, you can specify any available storage engine.

Answer 3

How can I determine type of mysql database : whether it is InnoDB or MyISAM?