Knowledge Base Hub

Browse through our helpful how-to guides to get the fastest solutions to your technical issues.

Home  >  MySQL  >  Steps to change the Database Engine of a MySQL Database Table
Top Scroll

Steps to change the Database Engine of a MySQL Database Table

 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 :

How To Create Backup Of A MySQL Database?

How to Optimize a MySQL Database Using SSH?

For our Knowledge Base visitors only
Get 10% OFF on Hosting
Special Offer!
30
MINS
59
SECS
Claim the discount before it’s too late. Use the coupon code:
STORYSAVER
Note: Copy the coupon code and apply it on checkout.