1. Home
  2. Knowledge Base
  3. cPanel
  4. MySQL Databases
  5. How to change the database engine of a MySQL database table

How to change the database engine of a MySQL database table

Step 1: Login to cPanel
Step 2: Go to phpmyadmin
Step 3: Select the database table called my_table using MyISAM engine and you wish to change the engine from MyISAM to InnoDB.
Step 4: Then click the SQL tab, place the following query and click the Go button:

++
ALTER TABLE my_table ENGINE = InnoDB;
++

Step 5: Now the database engine of the table will be changed to InnoDB.

Related Articles

Need Support?
Can't find the answer you're looking for?
Contact Support