How to change Mysql database storage engine

The default Mysql database storage engine is MyISAM. But if you want to implement foreign key constraints you should have the InnoDB storage engine. Lets see how we can change it. I will use the phpMyAdmin to do the operation.



Select the table you want and press the "Operations" tab.






Now select a Storage Engine you like from the drop down menu and press "Go" button.