innobackupex备份到远程服务器

2019独角兽企业重金招聘Python工程师标准>>>

1.免密

2.备份

innobackupex --defaults-file=/etc/3306.cnf --user=root --password=`cat /etc/sqlpass` --host=127.0.0.1 --port=3306 --stream=tar ./ | ssh root@10.0.0.70 -p14573 \ "cat - > /data/dbbackup/backup.tar"

PS：tar xvf backup.tar.gz -C /path/to/

 

参考

https://www.percona.com/doc/percona-xtrabackup/LATEST/innobackupex/streaming_backups_innobackupex.html

转载于:https://my.oschina.net/longquan/blog/1801459