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: 

ALERT 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.

  • 0 Utenti hanno trovato utile questa risposta
Hai trovato utile questa risposta?

Articoli Correlati

Can I change the name of a MySQL database?

The name of a MySQL database consists of a prefix, which is your cPanel username, followed by a...

How can I change my MySQL database collation?

Usually you will be interested in changing your MySQL collation in order to solve problems with...

How can I empty a MySQL database?

The easiest way to empty a MySQL database is through phpMyAdmin.  Once in phpMyAdmin, select the...

How to change the MySQL timezone

When you develop your website, you may have to compare a certain date/time with the current...

How to change the password of a Mysql user in cPanel?

If you have already created a MySQL user through the cPanel -> Mysql Databases tool you may...