1、进入备份目录/OL/backup/mysql/pwbbs/2011*****
2、mv backup-data.gz data.gz
3、gzip -d data.gz
4、解压出来的就是相当于用mysqldump导出的数据文件,进入测试机,
scp user@fromhost:/OL/backup/mysql/pwbbs/20110808043002/data.gz /OL/db/mysql/3306/data
tar zxvf data.gz
5、mysql > source /OL/db/mysql/3306/data/data
1、修改配置文件
/etc/mysql-zrm/pwbbs/mysql-zrm.conf
backup-level=0
backup-mode=logical
backup-type=regular
destination=/OL/backup/mysql
retention-policy=10D
compress=1
compress-plugin=/usr/bin/gzip
host="host"
port="3306"
user="backup"
databases=dbname
password="******"
socket=/tmp/mysql.3306.sock
mysql-binpath="/usr/bin/"
mysql-binlog-path="/OL/mysql/3306/data"
2、/OL/backup/mysql/pwbbs/20110806043002/index中的host修改成104
3、mysql-zrm --action restore --backup-set pwbbs --source-directory /OL/backup/mysql/pwbbs/20110806043002,即可将8.6的数据库备份恢复到104测试机上
4、用
http://domainname.com/phpmyadmin/index.php可对104测试机上的数据进行导出导入等操作