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 Корисниците го најдоа ова како корисно
Дали Ви помогна овој одговор?

Понудени резултати

How to create a MySQL database in cPanel

Your browser does not support the video tag. How to create a MySQL database in cPanelThis...

How to delete a MySQL database in cPanel

Your browser does not support the video tag. How to delete a MySQL database in cPanelThis...

How to create a MySQL database user in cPanel

Your browser does not support the video tag. How to create a MySQL database user in...

How to assign a user to a MySQL database in cPanel

Your browser does not support the video tag. How to assign a user to a MySQL database in...

How to change a MySQL database users password in cPanel

Your browser does not support the video tag. How to change a MySQL database users password...