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

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

WHMCS Complete Billing and Support

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.

Posted in Web Hosting.

Leave a Reply

Your email address will not be published. Required fields are marked *