Good day all
Hope all is well.
I have something to ask as someone might have done this as
well and may have a good solution on how to fix this.
During a database migration this weekend to move a MySQL
database from windows to linux, we created a backup and restore of the
However, form my part I made a mistake by overlooking the
fact that the windows database was configured to use default storage
engine as Innodb.
On the new server, the default was set to MyIsam.
This resulted in all the tables being restored to the new
system as MyIsam instead of Innodb.
In order to fix this, I know you can use alter table to
change the storage engine, however I need to know the following:
1. this is a production system and can't afford any
downtime or as little performance degration as possible.
What is the best way to do this in order to
have the least amount of effect on the database and it's performance?