View Change Table Storage Engine Phpmyadmin
Pictures. I tried it but seems there is no option in phpmyadmin. Access phpmyadmin and select your database.
Click on the structure tab; Is there a way to change the default storage engine? Now it displays a successful message.
You can change table engine with the help of alter command.
For mysql 5.5 and later, the default storage engine is innodb. Access phpmyadmin and select your database. Be careful changing certain aspects of table columns, because it is possible to lose data. How to change a database table prefix.