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 bac
Juan,
InnoDB Hot Backup is non-free. A 1-year license costs 390 euros + VAT,
and a perpetual license 990 euros + VAT.
http://www.innodb.com/order.php
The Perl script innobackup can be used to make consistent backups of
MyISAM tables also, but those backup require the locking of MyISAM
table
Hi Juan,
Thanks a lot for the quick reply. Any idea how much it would cost for
ibbackup for innodb. Will mysql be providing this with any of their new
release.
regards
anandkl
On 2/23/07, Juan Eduardo Moreno <[EMAIL PROTECTED]> wrote:
Ananda,
For Innodb the best is Innodb Hot Backup ( www.i
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 PROTECT
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
