MySQL Forums
Forum List  »  Merge Storage Engine

Backup Help
Posted by: Paul Washbrook
Date: September 30, 2009 02:03AM


We are currently undergoing a system redevelopment during which time we will be converting our main tables from MyISAM to INNODB. Part of our current backup strategy for MySQL includes copying the .frm, .myi and .myd files to a backup location, having used all of the relevent flush / lock commands recommended by MySQL. This method allows us to perform individual table restores, however it is my understanding (wrong as it might be!) that this method isn't possible for INNODB tables. So, what would be the best approach for giving me the ability to perform individual table restores, given that the tables will be INNODB and the backup could be performed from either the Master server or a replication slave.

Hope this is reasonably clear as to what i want to achieve.

Many Thanks


Options: ReplyQuote

Written By
Backup Help
September 30, 2009 02:03AM
September 30, 2009 02:16AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.