這是一套mysql的備份軟體 zrm for mysql
可以對innodb做 hotcopy

1.先安裝cpan
2.安裝所有的perl-xml-*
3.下載
http://www.zmanda.com/backup-mysql.html
4.設定
/etc/mysql-zrm/mysql-zrm.conf
# mysql-zrm-backup –backup-set dailybackup
dailybackup 是名稱
完整備份
mysql-zrm-scheduler –now –backup-set db1 –backup-level 0
增量備份
mysql-zrm-scheduler –now –backup-set db1 –backup-level 1
0是完整備份 1是增量備份 增量備份需要開啟binlog
完整備份回復
mysql-zrm –action restore –backup-set db1 \
–source-directory /mnt/sdg/dbbackup/db1/20110304022219
如果要指定回復某一個資料庫 用
–databases
增量備份回復
mysql-zrm –action restore –backup-set db1 \
–start-date=”20110304064500″ –stop-datetime “20110304064500” \
–source-directory /mnt/sdg/dbbackup/db1/20110304064500
另一個增量備份的回復方式
mysql-zrm –action restore –bin-logs /var/lib/mysql-zrm/backupset1/20060818121532/mysql-bin.[0-9]* /var/lib/mysql-zrm/backupset1/20060819121532/mysql-bin.[0-9]*
連結
http://wiki.zmanda.com/index.php/How_do_I_recover_data_when_there_is_a_failure_or_data_loss%3F