Following article describes the steps to change storage engine of a MySQL database table. Assume that you want to change storage engine of a database table from MyISAM to InnoDB .
Method 1
- Login to phpMyAdmin.
- Navigate to database table whose storage engine you wish to change.
- Click on SQL tab, paste this query "ALTER TABLE tablename ENGINE = InnoDB ;" in query box and click on Go button.
Method 2
- Login to phpMyAdmin.
- Navigate to database table whose storage engine you wish to change.
- Click on Operations tab, under Table options you would find drop down called Storage Engine.
- Select storage engine of your choice from the Storage Engine drop down and click on Go button.
Article ID: 2217, Created: April 5, 2022 at 5:47 AM, Modified: April 5, 2022 at 5:47 AM