/usr/bin/innobackupex --no-lock --defaults-file=/etc/my.cnf --stream=tar ./ |gzip -|ssh root@192.168.0.11 cat ">" /root/databasebackup/date +%Y-%m-%d
.tar.gz备份到远程192.168.0.11时在复制数据时出错如下:
innobackupex: Created backup directory /root/mysql-databasebackup
120611 00:33:38 innobackupex: Starting mysql with options: --defaults-file='/etc/my.cnf' --user='root' --unbuffered --
120611 00:33:38 innobackupex: Connected to database with mysql child process (pid=9047)
120611 00:33:40 innobackupex: Connection to database server closed
120611 00:33:40 innobackupex: Starting ibbackup with command: xtrabackup_51 --defaults-file="/etc/my.cnf" --backup --suspend-at-end --target-dir=/tmp --stream=tar
innobackupex: Waiting for ibbackup (pid=9054) to suspend
innobackupex: Suspend file '/tmp/xtrabackup_suspended'
xtrabackup_51 version 2.0.0 for MySQL server 5.1.59 unknown-linux-gnu (x86_64) (revision id: undefined)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /data/mysql-slave
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_data_home_dir = /data/mysql-slave
xtrabackup: innodb_data_file_path = ibdata1:2000M;ibdata2:2000M;ibdata3:2000M;ibdata4:1000M:autoextend
xtrabackup: innodb_log_group_home_dir = /data/mysql-slave
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 5242880
>> log scanned up to (0 84975)
[01] Streaming /data/mysql-slave/ibdata1
innobackupex: Error: ibbackup child process has died at /usr/bin/innobackupex line 371.
似乎是版本太老的问题,请看官网论坛上的一个帖子 http://forum.percona.com/index.php?t=msg&goto=8201&######
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。