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.

  • 3 Users Found This Useful
Was this answer helpful?

Related Articles

How do I add a mysql database in Cpanel?

To create a MySQL database: - Go to 'Manage Mysql' under the database header in Cpanel - In the...

How can I backup a database using phpmyadmin?

Backing up your database in Phpmyadmin is accomplished by doing the following: 1) Once you have...

How do I backup a database via SSH?

First, you'll need to log into your account via a secure shell client like Putty or SecureCRT....

How do I restore a database using PHPMyadmin?

You can restore a database backup in PHPMyadmin by doing the following: 1) After entering...

What is Mysql?

MySQL is a Relational Database Management System. A relational database adds speed and...