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.

  • 0 Користувачі, які знайшли це корисним
Ця відповідь Вам допомогла?

Схожі статті

What is the default mysql port?

3306 is the default mysql port.

How to connect to PostgreSQL from PHP?

For connecting to a PostgreSQL database from PHP you can use the standard pg_Connect() function.

How to import an .sql file into a Postgre database?

Log in to your cPanel and open the phpPgAdmin tool. Then click on the PostgreSQL link at the left...

How to create a Postgre user?

In order to create a PostgreSQL user you should go to your cPanel -> PostgreSQL Databases...

How to create a Postgre database?

Creating a PostgreSQL database is a straight-forward process. All you need to do is log in to...