Comments on MySQL Backup And Recovery With mysql-zrm On Debian Sarge

MySQL Backup And Recovery With mysql-zrm On Debian Sarge This guide describes how to back up and recover your MySQL databases with mysql-zrm on a Debian Sarge system. mysql-zrm is short for Zmanda Recovery Manager for MySQL, it is a new tool that lets you create full logical or raw backups of your databases (regardless of your storage engine and MySQL configuration), generate reports about the backups, verify the integrity of the backups, and recover your databases. It can also send email notifcations about the backup status, and you can implement multiple backup policies (based on your applications and based on time (e.g. daily, weekly, etc.)).

3 Comment(s)

Add comment

Please register in our forum first to comment.

Comments

By: Bluedog

Great how-to.  I'm boomarking this to share with all my DBAs.

By: curx

Hi,

precreated debian package can be found at http://debian.systs.org/

Regards,
Thorsten 

By:

Packages are available at:

http://www.zmanda.com/download-zrm.php

(Debian) I found that after installing the version 1.2 .deb package, I got errors like this:

/etc/cron.daily/man-db:
gzip: /usr/share/man/man5/mysql-zrm-reporter.conf.5.gz: Permission denied
mandb: command '/bin/gzip -dc /usr/share/man/man5/mysql-zrm-reporter.conf.5.gz'
failed with exit status 256
mandb: warning: /usr/share/man/man5/mysql-zrm-reporter.conf.5.gz: bad symlink or
ROFF `.so' request

So, try this to correct it:

chown root:root /usr/share/man/man5/mysql-zrm*
chown root:root /usr/share/man/man1/mysql-zrm*
chmod 644 /usr/share/man/man5/mysql-zrm*
chmod 644 /usr/share/man/man1/mysql-zrm*