17、xtrabackup 常用备份功能与选项

# tar格式流备份innobackupex -p123123 --stream=tar /backupinnobackupex -p123123 --stream=tar /backup > /backup/back.tartar -ixvf /backup/back.tarinnobackupex -p123123 --stream=tar /backup | gzip > /backup/fullback.tar.gzinnobackupex -p123123 --stream=tar /tmp | ssh root@192.168.1.120 \ "cat - > /backup/bak.tar"# 备份到远程主机- [1] 免密登录- [2] innobackupex -p123123 --stream=tar /tmp | ssh root@192.168.1.120 \ "cat - > /backup/bak.tar"- [3] innobackupex -p123123 --stream=tar /tmp | ssh root@192.168.1.120 \ "gzip > /backup/dateFullBak.tar.gz";# xbstream格式流备份innobackupex -p123123 --stream=xbstream ./ > /backup/fullbak.xbstreaminnobackupex -p123123 --stream=xbstream --compress ./ > /backup/fullbak.xbstreamxbstream -x < bakup.xbstreamxbstream -x -C /backup/zsythink/ < fullbak.xbstream备份到远程主机> innobackupex -p123123 --stream=xbstream --compress /tmp | ssh root@192.168.1.120 "xbstream -x -C /backup/datafull"