Changing the storage engine of a MySQL table
To dispatch a recovery, DBOD uses binary logs to replay
operations and bring the database back to a point in time. To guarantee
a consistent state of the database after a recovery, we strongly
recommend the use of the InnoDB
storage engine. Users having MyISAM
tables in their databases will receive a weekly email warning them about
the situation and advising them to change the engine to InnoDB
. To do
this, the following query must be executed per table:
ALTER TABLE table_name ENGINE = InnoDB;
For more information, please refer to the official MySQL documentation