how to change storage engine of database in phpmyadmin? [duplicate]

Question

I have a MySQL database. The default storage engine is MyISAM.

I want to change it to InnoDB.

I can change it table by table , but i want to change it one time that affect all the tables .

How can I change the database storage engine? I tried it but seems there is no option in phpmyadmin.

Answer 1

The easiest way to change the default engine is to log on phpMyAdmin and then go to Variables >> storage engine

click edit and type InnoDB.

the default storage engine is now InnoDB

http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_storage_engine

Answer 2

When logged in go to the table you want to change then click the operations tab. From there you can change the storage type, as well as a few other options

Online Doc