Search our database

How to change database table engine types in phpMyAdmin

1.) First log into your hosting control panel if you do not know how to access to the mysql database phpMyAdmin page.

(a) For plesk user, log into the control panel and go into ‘Database’ under category ‘Applications & Services’, then you come to the page as below, select the small icon as underline for the selected mysql database.

(b) For DirectAdmin user, log into the control panel and select the phpMyAdmin under category ‘Advanced Features’.

2.) Access into the phpMyAdmin using existed database user of the database.

3.) On the phpMyAdmin main page, you may click on the database to view the database tables contains inside the database.

4.) You can view the database table engine type from the list. Click on the ‘sql’ tab in order to run queries.

5.) Run the query by insert the query below into the blank space, replace the TableName to the database table name that you wish to change, then click on ‘Go’.

ALTER TABLE TableName ENGINE = InnoDB;

Or

ALTER TABLE TableName ENGINE = MyISam;

6.) The database table engine type will changed if the query run successfully. Therefore done with the changing.

Tags: ,