##### for download and installing zrm recovery tools:
for downloading the zrm-recovery toos
wget http://www.zmanda.com/downloads/community/ZRM-MySQL/2.2/RPM/MySQL-zrm-2.2.0-1.noarch.rpm
installing the rpm packages as follows:
rpm 0-ivh -zrm-2.2.0-1.noarch.rpm
check for rpm packages
ls -lh /usr/bin/mysql-zrm*
-rwxr-x--- 1 mysql mysql 3.5K Feb 4 2010 /usr/bin/mysql-zrm
-rwxr-x--- 1 mysql mysql 1.8K Feb 4 2010 /usr/bin/mysql-zrm-abort-backup
-rwxr-x--- 1 mysql mysql 70K Feb 4 2010 /usr/bin/mysql-zrm-backup
-rwxr-x--- 1 mysql mysql 1.6K Feb 4 2010 /usr/bin/mysql-zrm-check
-rwxr-x--- 1 mysql mysql 2.9K Feb 4 2010 /usr/bin/mysql-zrm-extract-backup
-rwxr-x--- 1 mysql mysql 1.8K Feb 4 2010 /usr/bin/mysql-zrm-getconf
-rwxr-x--- 1 mysql mysql 4.4K Feb 4 2010 /usr/bin/mysql-zrm-list
-rwxr-x--- 1 mysql mysql 12K Feb 4 2010 /usr/bin/mysql-zrm-manage-backup
-rwxr-x--- 1 mysql mysql 2.7K Feb 4 2010 /usr/bin/mysql-zrm-migrate-file-ownership
-rwxr-x--- 1 mysql mysql 13K Feb 4 2010 /usr/bin/mysql-zrm-parse-binlogs
-rwxr-x--- 1 mysql mysql 4.9K Feb 4 2010 /usr/bin/mysql-zrm-purge
-rwxr-x--- 1 mysql mysql 29K Feb 4 2010 /usr/bin/mysql-zrm-reporter
-rwxr-x--- 1 mysql mysql 31K Feb 4 2010 /usr/bin/mysql-zrm-restore
-rwxr-x--- 1 mysql mysql 13K Feb 4 2010 /usr/bin/mysql-zrm-scheduler
-rwxr-x--- 1 mysql mysql 8.1K Feb 4 2010 /usr/bin/mysql-zrm-verify-backup
The configuration files are located on
ls -lh /etc/mysql-zrm/
-rwxrwx--- 1 mysql mysql 12K Feb 4 2010 mysql-zrm.conf
-rwxrwx--- 1 mysql mysql 48 Feb 4 2010 mysql-zrm-release
-rwxrwx--- 1 mysql mysql 3.2K Feb 4 2010 mysql-zrm-reporter.conf
-rw-rw---- 1 mysql mysql 596 Feb 4 2010 RSS.header
After sucessfull configuration and installation
we want to take the full backup using ZRM Tools:
cd /etc/mysql-zrm
mkdir fullbackup
cp mysql-zrm.conf fullbackup/
cd fullbackup
ls -lh
-rwxr-x--- 1 mysql mysq 9.0k Feb 4 2010 mysql-zrm.conf
change the configuration file on mysql-zrm.conf
The changes are as follows:
backup-level=0
backup-mode=logical
user="user1"
password="user1"
destination=/var/lib/mysql-zrm
steps for taking the backup (full backup)
mysql-zrm-scheduler --now --backup-set fullbackup
for more options for mysq-zrm are as follows:
mysql-zrm --action --help
USAGE:
--action <backup|restore|schedule-backup|report|list|getconf|setconf|purge|parse-binlogs|check|manage-backup|verify-backup|extract-backup|abort-backup>
Help on individual action items can be obtained by specifying --help with the required action.
For example: 'mysql-zrm --action backup --help'
mysql-zrm --action --help
1) restoring the full backup
mysql-zrm --action restore --backup-set fullbackup --source-directory /var/lib/mysql-zrm/fullbackup/20120215114946/
2) steps for restoing the individual database from full backup.
first go to the index file
then change the logical-databses (db1 db2) etc
vi index
backup-set=fullbackup
backup-date=20120215114946
mysql-server-os=Linux/Unix
backup-type=regular
host=localhost
backup-date-epoch=1329286786
mysql-zrm-version=ZRM for MySQL Community Edition - version 2.2.0
mysql-version=5.5.19-log
backup-directory=/var/lib/mysql-zrm/fullbackup/20120215114946
backup-level=0
logical-databases=db1 db2
next-binlog=mysql-bin.000004
backup-size=478.09 MB
read-locks-time=00:00:19
flush-logs-time=00:00:00
backup-time=00:00:19
backup-status=Backup succeeded
mysql-zrm --action restore --backup-set fullbackup --source-directory /var/lib/mysql-zrm/fullbackup/20120215114946/ --databases "db1"
More about the zrm utilities:
The url is as follows:
http://www.zmanda.com/quick-mysql-backup.html
for downloading the zrm-recovery toos
wget http://www.zmanda.com/downloads/community/ZRM-MySQL/2.2/RPM/MySQL-zrm-2.2.0-1.noarch.rpm
installing the rpm packages as follows:
rpm 0-ivh -zrm-2.2.0-1.noarch.rpm
check for rpm packages
ls -lh /usr/bin/mysql-zrm*
-rwxr-x--- 1 mysql mysql 3.5K Feb 4 2010 /usr/bin/mysql-zrm
-rwxr-x--- 1 mysql mysql 1.8K Feb 4 2010 /usr/bin/mysql-zrm-abort-backup
-rwxr-x--- 1 mysql mysql 70K Feb 4 2010 /usr/bin/mysql-zrm-backup
-rwxr-x--- 1 mysql mysql 1.6K Feb 4 2010 /usr/bin/mysql-zrm-check
-rwxr-x--- 1 mysql mysql 2.9K Feb 4 2010 /usr/bin/mysql-zrm-extract-backup
-rwxr-x--- 1 mysql mysql 1.8K Feb 4 2010 /usr/bin/mysql-zrm-getconf
-rwxr-x--- 1 mysql mysql 4.4K Feb 4 2010 /usr/bin/mysql-zrm-list
-rwxr-x--- 1 mysql mysql 12K Feb 4 2010 /usr/bin/mysql-zrm-manage-backup
-rwxr-x--- 1 mysql mysql 2.7K Feb 4 2010 /usr/bin/mysql-zrm-migrate-file-ownership
-rwxr-x--- 1 mysql mysql 13K Feb 4 2010 /usr/bin/mysql-zrm-parse-binlogs
-rwxr-x--- 1 mysql mysql 4.9K Feb 4 2010 /usr/bin/mysql-zrm-purge
-rwxr-x--- 1 mysql mysql 29K Feb 4 2010 /usr/bin/mysql-zrm-reporter
-rwxr-x--- 1 mysql mysql 31K Feb 4 2010 /usr/bin/mysql-zrm-restore
-rwxr-x--- 1 mysql mysql 13K Feb 4 2010 /usr/bin/mysql-zrm-scheduler
-rwxr-x--- 1 mysql mysql 8.1K Feb 4 2010 /usr/bin/mysql-zrm-verify-backup
The configuration files are located on
ls -lh /etc/mysql-zrm/
-rwxrwx--- 1 mysql mysql 12K Feb 4 2010 mysql-zrm.conf
-rwxrwx--- 1 mysql mysql 48 Feb 4 2010 mysql-zrm-release
-rwxrwx--- 1 mysql mysql 3.2K Feb 4 2010 mysql-zrm-reporter.conf
-rw-rw---- 1 mysql mysql 596 Feb 4 2010 RSS.header
After sucessfull configuration and installation
we want to take the full backup using ZRM Tools:
cd /etc/mysql-zrm
mkdir fullbackup
cp mysql-zrm.conf fullbackup/
cd fullbackup
ls -lh
-rwxr-x--- 1 mysql mysq 9.0k Feb 4 2010 mysql-zrm.conf
change the configuration file on mysql-zrm.conf
The changes are as follows:
backup-level=0
backup-mode=logical
user="user1"
password="user1"
destination=/var/lib/mysql-zrm
steps for taking the backup (full backup)
mysql-zrm-scheduler --now --backup-set fullbackup
for more options for mysq-zrm are as follows:
mysql-zrm --action --help
USAGE:
--action <backup|restore|schedule-backup|report|list|getconf|setconf|purge|parse-binlogs|check|manage-backup|verify-backup|extract-backup|abort-backup>
Help on individual action items can be obtained by specifying --help with the required action.
For example: 'mysql-zrm --action backup --help'
mysql-zrm --action --help
1) restoring the full backup
mysql-zrm --action restore --backup-set fullbackup --source-directory /var/lib/mysql-zrm/fullbackup/20120215114946/
2) steps for restoing the individual database from full backup.
first go to the index file
then change the logical-databses (db1 db2) etc
vi index
backup-set=fullbackup
backup-date=20120215114946
mysql-server-os=Linux/Unix
backup-type=regular
host=localhost
backup-date-epoch=1329286786
mysql-zrm-version=ZRM for MySQL Community Edition - version 2.2.0
mysql-version=5.5.19-log
backup-directory=/var/lib/mysql-zrm/fullbackup/20120215114946
backup-level=0
logical-databases=db1 db2
next-binlog=mysql-bin.000004
backup-size=478.09 MB
read-locks-time=00:00:19
flush-logs-time=00:00:00
backup-time=00:00:19
backup-status=Backup succeeded
mysql-zrm --action restore --backup-set fullbackup --source-directory /var/lib/mysql-zrm/fullbackup/20120215114946/ --databases "db1"
More about the zrm utilities:
The url is as follows:
http://www.zmanda.com/quick-mysql-backup.html

No comments:
Post a Comment