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.

آیا این پاسخ به شما کمک کرد؟ 0 کاربر این را مفید یافتند (0 نظرات)

Powered by WHMCompleteSolution