Changing the MySQL Database Table Engine to InnoDB

  1. Portal Home
  2. Knowledgebase
  3. Changing the MySQL Database Table Engine to InnoDB
  •   23/05/2018 9:48 AM
  •  

1) Login to cPanel and click on phpMyAdmin



2) Select the database . In this example, I'll be using "joshipro_wptest1"



3) Click on the SQL Tab


4) Run the query as below. 


ALTER TABLE TableName ENGINE = InnoDB;

Note:  
TableName: database table name



5) Click Go button to confirm the final changes.
 

  Print