开发者社区> 问答> 正文

xtrabackup远程备份问题?? 400 请求报错 

/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.

展开
收起
kun坤 2020-05-29 18:00:52 628 0
1 条回答
写回答
取消 提交回答
问答排行榜
最热
最新

相关电子书

更多
数据库异地备份及不还原快速查询备份集最佳实践 立即下载
微信SQLite数据库损坏恢复实践 立即下载
低代码开发师(初级)实战教程 立即下载