InnoDB Hot Backup is non-free. A 1-year license costs 390 euros + VAT,
and a perpetual license 990 euros + VAT.
The Perl script innobackup can be used to make consistent backups of
MyISAM tables also, but those backup require the locking of MyISAM
tables, and are not in that sense 'hot' or 'online'.
InnoDB Hot Backup works with all MySQL versions up to 5.1.
Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL
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
On 2/23/07, Juan Eduardo Moreno <juaneduardomc@stripped> 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
> > recovery stratergy for MyISAM and INNODB in mysql.
> > regards
> > anandkl