List:General Discussion« Previous MessageNext Message »
From:Machiel Richards Date:November 22 2010 9:59am
Subject:Changing database tables to different storage engine.
View as plain text  
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
database.

            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?


         Regards
Machiel

Thread
Changing database tables to different storage engine.Machiel Richards22 Nov
  • Re: Changing database tables to different storage engine.Machiel Richards22 Nov
    • Re: Changing database tables to different storage engine.John Daisley22 Nov
      • Re: Changing database tables to different storage engine.Machiel Richards22 Nov
        • Re: Changing database tables to different storage engine.Johan De Meersman22 Nov
        • Re: Changing database tables to different storage engine.Tyler Poland22 Nov
          • Re: Changing database tables to different storage engine.Johan De Meersman22 Nov
            • Re: Changing database tables to different storage engine.Kyong Kim22 Nov