Warning: Using unique option prefix open_files instead of open_files_limit is deprecated and will be removed in a future release. Please use the full name instead.
xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revision id: )
xtrabackup: uses posix_fadvise().
xtrabackup: cd to
xtrabackup: open files limit requested 65535, set to 65535
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = ./
xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 50331648
2014-06-30 09:14:48 7f0abfdd0720 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: File ./ib_logfile0: 'open' returned OS error 71. Cannot continue operation
innobackupex: Error: The xtrabackup child process has died at /usr/bin/innobackupex line 2672
从以上可以看出备份失败，出现文件不能打开错误，因为是编译安装，innobackupex未带参数默认寻找/etc/my.cnf配置文件，/etc/my.cnf文件未指定basedir及datadir
在[mysqld]下面增加
|
1 2 |
|
再重新进行备份，备份成功。(basedir就是mysql安装所在的目录,datadir是数据文件所在的目录)
重新启动 mysql数据库。
service mysqld restart
再次执行：
innobackupex -host=192.168.199.147 --user=jsb --password=jsb --defaults-file=/etc/my.cnf /data/backup