Home
/
Database Support
/
Database Management
/
How to change the database engine of a MySQL database table?
How to change the database engine of a MySQL database table?
To change the database engine of a MySQL database table, go to your phpMyAdmin available in Site Tools.
For example, if you have a database table called my_table using MyISAM engine and you wish to change the engine from MyISAM to InnoDB you have to:
Access phpMyAdmin and select your database. Then click on SQL, place the following query and click on Go:
ALTER TABLE my_table ENGINE = InnoDB;
If the query is executed properly, the database engine of the table will be changed to InnoDB.
