Backup Help

[Paul Washbrook]

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