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

You may require changing MySQL database storage engine for your table.

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

You can change the storage engine using the following MySQL query:

ALTER TABLE your_table ENGINE = InnoDB;

If you have phpMyAdmin, you can execute the above query from there.

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

Leave a Reply