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.
Last Updated on