Steps to change the Database Engine of a MySQL Database Table

• 15 October 2021
• in: MySQL

In this article you will understand how to change the Database engine of a MySQL database table.

The database engine is a component of the Database Management System (DBMS) and it can create, read, update and delete data from a database.

Follow the below steps to change the database engine :

Method 1 :

1) Log in to the cPanel account.

2) Then Open phpMyAdmin.

3) Select the database table, from the left-hand column whose search engine you want to change.

4) After that click on the Operations tab.

5) There is a drop-down of the Storage Engine Under Table options.

6) As per your choice Select the Storage Engine.

7) After everything is completed, click on Go.

Method 2 :

In the second method, you just need to run the subsequent SQL query on the SQL tab after choosing the specified database from phpMyAdmin.

ALTER TABLE table_name ENGINE = MyISAM

After this query gets executed, the database engine of the selected database will get changed to MyISAM.

That’s all !

In this way you can successfully change the storage engine for the table.