MySQL Forums
Forum List  »  Merge Storage Engine

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

Hi,

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

Paul

Options: ReplyQuote


Subject
Views
Written By
Posted
Backup Help
10038
September 30, 2009 02:03AM
4318
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.