How to change the database engine of a MySQL database table?

The easiest way to change the database engine of a MySQL database table is through phpMyAdmin available in cPanel.

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 will need to:

Access phpMyAdmin and select your database. Then click the SQL tab, place the following query and click the Go button:

ALTER TABLE my_table ENGINE = InnoDB;

If the query is executed properly, the database engine of the table will be changed to InnoDB.

Was this answer helpful? 0 Users Found This Useful (0 Votes)

Powered by WHMCompleteSolution