Whats wrong with using the --single-transaction switch for backing up InnoDB tables? What does the Hot Backup product do that this doesn't?

Thanks,
-Ryan


Juan Eduardo Moreno wrote:
Ananda,

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).

Regards,
Juan Eduardo


On 2/23/07, Ananda Kumar <[EMAIL PROTECTED]> 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.

regards
anandkl



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to