How to change the database engine of a MySQL database table?

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

Let's assume that you have a database table called my_table using MyISAM engine and you wish to change the engine from MyISAM to InnoDB.

The MySQL query that should be used is:
ALTER TABLE my_table ENGINE = InnoDB;

The easiest way to make this change is through phpMyAdmin:

Open your phpMyAdmin tool and select the database which contains my_table. Then click the SQL tab, paste the above query there and click the Go button.

If the query is executed properly, the database engine of the table will be changed to InnoDB.

Was this answer helpful?

 Print this Article

Also Read

What is MySQL?

MySQL is a Database Management System. A relational database adds speed and flexibility, by...

What is the mysql host name?

Refer to your setup email to find the IP of your MySQL server. You can also use...

Change collation for all MySQL tables to UTF-8?

Changing the collation for all tables in a MySQL database can be time consuming depending on how...

How to repair a MySQL database?

In this article we will show you two ways to repair a MySQL database. 1) Through cPanel: Log in...

MS Access database support

MS Access can be used with windows based personal hosting and resller plans. Since this is...