Whats wrong with using the --single-transaction switch for backing up
InnoDB tables? What does the Hot Backup product do that this doesn't?
Juan Eduardo Moreno wrote:
> For Innodb the best is Innodb Hot Backup ( www.innodb.com (US$) )
> For MyISAM you can use a simple backup ( copy/paste) of your files. Also,
> you can do snapshots using mysqldump.
> Also, you can use Zmanda ( www.zmanda.com).
> Juan Eduardo
> On 2/23/07, Ananda Kumar <anandkl@stripped> wrote:
>> Hi All,
>> Can you please direct me to any good documentation for a good backup and
>> recovery stratergy for MyISAM and INNODB in mysql.