Knowledge Base
MilesWeb / MySQL

Steps to change the Database Engine of a MySQL Database Table

Approx. read time : 2 min

This article will guide you on how to change the Database engine of a MySQL database table.

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

Perform the following steps to change the database engine :

Method 1 :

1) Log in to the cPanel account.

2) Open phpMyAdmin.

database_engine 1

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

4) Now, click on the Operations tab.

database_engine 2

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

database_engine 3

6) Select the Storage Engine as per your choice.

7) After everything is done, click on Go.

Method 2 :

In the second method, you simply need to run the following SQL query on the SQL tab after selecting the desired database from phpMyAdmin.

ALTER TABLE table_name ENGINE = MyISAM

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

It’s done.

This way you can successfully change the storage engine for the table.

Also Read :

1) How To Create Backup Of A MySQL Database?

2) How to Optimize a MySQL Database Using SSH?

Sonam Wagh
With an interest in doing something creative daily, Sonam works as a Digital Marketing Executive. She likes to write technical blogs related to web hosting, digital marketing, and other IT topics. She also likes to spend her leisure time on social media to find different strategies for client engagement.
Need help? We’re always here for you.