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.

  • 27 Users Found This Useful
這篇文章有幫助嗎?

相關文章

What type of databases do you support? PGSQL and MySQL?

All our servers support MySQL and PostgreSQL databases. Also with any of our hosting packages...

How to repair a MySQL database?

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

How to optimize a MySQL database using phpMyAdmin?

It is always a good idea to keep your databases' tables optimized. Fortunately, making this...

I get an error 'ACCESS DENIED CREATE DATABASE db_name' when I try to import a database

In order to solve this issue follow these steps: Open the MySQL dump with a text editor on...

I have problems accessing my MySQL database remotely

If you have problems accessing your database at your web hosting account remotely please make...