PDA

View Full Version : Can Zmanda backup running MYSQL ?



leiw
November 15th, 2008, 10:37 AM
Hello,

I means no need stop mysqld for backup by Zmanda.

THx

leiw
November 16th, 2008, 07:36 PM
Could anyone help me ?

kulkarni_mangesh
November 16th, 2008, 10:01 PM
Yes, Zmanda Recovery Manager for MySQL can take care of this. Following are some of the methods, through which we can take backup of Running MySQL server.

Backup type logical: Logical backup locks database for a moment while taking backups.

Backup type Raw: By following ways we can take raw backups of running MySQL server.


Snapshot based backup.
“mysqlhotcopy” based backups if DataBase contains only MyISAM based tables.
If Database contains MyISAM and Innodb tables then should perform Snapshot based backup.

leiw
November 17th, 2008, 05:12 PM
Thank a lot