Use Innobackupex for database backup to report the following error:
Innobackupex--compress--parallel=4--user=root--password=yoon/export/backup/
xtrabackup_56 version 2.1.9 for MySQL server 5.6.17 Linux (x86_64) (revision id:744)
Xtrabackup:uses posix_fadvise ().
XTRABACKUP:CD To/var/lib/mysql
Xtrabackup:open files limit requested 0, set to 1024
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
2016-01-21 21:41:29 7f343333b720 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 had died At/usr/bin/innobackupex line 2622.
In the production library backup is no problem, the virtual machine backup is a problem!
Percona says modify Profile path permissions:
Https://www.percona.com/forums/questions-discussions/percona-xtrabackup/13396-file-name-ib_ logfile0-innodb-file-operation-call-open-returned-os-error-71
[Email protected] mysql]# ls-ltr
Total 180
-rw-r--r--. 1 root root 2496 Jul
-rw-r--r--. 1 root root 17987 Jul COPYING
-rw-r--r--. 1 root root 104897 Jul install-binary
Drwxr-xr-x. 2 root root 4096 Dec 18:39 docs
Drwxr-xr-x. 3 root root 4096 Dec 18:39 include
Drwxr-xr-x. 4 root root 4096 Dec 18:39 man
Drwxr-xr-x. 3 root root 4096 Dec 18:39 data
Drwxr-xr-x. 3 root root 4096 Dec 18:39 Lib
Drwxr-xr-x. 2 root root 4096 Dec 18:39 scripts
Drwxr-xr-x. 2 root root 4096 Dec 18:39 bin
Drwxr-xr-x. Root root 4096 Dec 18:39 mysql-test
Drwxr-xr-x. 2 root root 4096 Dec 18:39 support-files
Drwxr-xr-x. Root root 4096 Dec 18:39 share
Drwxr-xr-x. 4 root root 4096 Dec 18:39 sql-bench
-rw-r--r--. 1 root root 943 Dec 18:39 my.cnf
Drwxr-xr-x. 2 root root 4096 Dec 18:40 etc
[[email protected] mysql]# chown-r mysql.mysql etc/problem still!
Error always prompt Ib_logfile0, in the configuration file Ib_logfile parameter is present:
Innodb:file./IB_LOGFILE0: ' Open ' returned OS error 71. Cannot continue operation
To back up the specified parameter file:
[Email protected] backup]# Innobackupex--compress--parallel=4--defaults-file=/export/servers/mysql/etc/my.cnf-- User=root--password=yoon/export/backup/
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All rights Reserved.
This software is published under
The GNU general public LICENSE Version 2, June 1991.
Get the latest version of Percona Xtrabackup, documentation, and help resources:
http://www.percona.com/xb/p
160121 22:12:52 innobackupex:connecting to MySQL server with DSN ' dbi:mysql:;mysql_read_default_file=/export/servers/ Mysql/etc/my.cnf;mysql_read_default_group=xtrabackup ' as ' root ' (using Password:yes).
160121 22:12:52 innobackupex:connected to MySQL server
160121 22:12:52 innobackupex:executing A version check against the server ...
160121 22:12:52 Innobackupex:done.
Important:please Check that the backup run completes successfully.
At the end of a successful backup run Innobackupex
Prints "completed ok!".
innobackupex:using MySQL server version 5.6.26-log
innobackupex:created Backup directory/export/backup/2016-01-21_22-12-52
160121 22:12:52 innobackupex:starting ibbackup with command:xtrabackup_56--defaults-file= "/export/servers/mysql/etc /my.cnf "--defaults-group=" mysqld "--backup--suspend-at-end--target-dir=/export/backup/2016-01-21_22-12-52-- Tmpdir=/export/data/mysql/tmp--compress--compress-threads=1--parallel=4
Innobackupex:waiting for Ibbackup (pid=5476) to suspend
Innobackupex:suspend file '/export/backup/2016-01-21_22-12-52/xtrabackup_suspended_2 '
xtrabackup_56 version 2.1.9 for MySQL server 5.6.17 Linux (x86_64) (revision id:744)
Xtrabackup:uses posix_fadvise ().
XTRABACKUP:CD to/export/data/mysql/data/
Xtrabackup:open files limit requested 65535, set to 65535
Xtrabackup:using the following InnoDB configuration:
Xtrabackup:innodb_data_home_dir =/export/data/mysql/data
Xtrabackup:innodb_data_file_path = Ibdata1:2g;ibdata2:2g:autoextend
Xtrabackup:innodb_log_group_home_dir =/export/data/mysql/data
Xtrabackup:innodb_log_files_in_group = 3
Xtrabackup:innodb_log_file_size = 268435456
2016-01-21 22:12:52 7fa03bee9720 innodb:using Linux native AIO
Xtrabackup:using O_direct
>> Log scanned up to (1510934)
innodb:opened 4 undo Tablespaces
Xtrabackup:starting 4 threads for parallel data files transfer
[Compressing/export/data/mysql/data/ibdata1] To/export/backup/2016-01-21_22-12-52/ibdata1.qp
[Compressing/export/data/mysql/data/ibdata2] To/export/backup/2016-01-21_22-12-52/ibdata2.qp
[Compressing/export/data/mysql/undo/undo001 TO/EXPORT/BACKUP/2016-01-21_22-12-52/UNDO001.QP]
[Compressing/export/data/mysql/undo/undo002 TO/EXPORT/BACKUP/2016-01-21_22-12-52/UNDO002.QP]
[From] ... done
[... done]
>> Log scanned up to (1510934)
[Compressing/export/data/mysql/undo/undo003 TO/EXPORT/BACKUP/2016-01-21_22-12-52/UNDO003.QP]
[Compressing/export/data/mysql/undo/undo004 TO/EXPORT/BACKUP/2016-01-21_22-12-52/UNDO004.QP]
[From] ... done
[... done]
[Compressing]/mysql/innodb_index_stats.ibd to/export/backup/2016-01-21_22-12-52/mysql/innodb_index_ Stats.ibd.qp
[From] ... done
[Compressing]/mysql/innodb_table_stats.ibd To/export/backup/2016-01-21_22-12-52/mysql/innodb_table_ Stats.ibd.qp
[... done]
[Compressing]/mysql/slave_master_info.ibd to/export/backup/2016-01-21_22-12-52/mysql/slave_master_ Info.ibd.qp
[From] ... done
>> Log scanned up to (1510934)
[Compressing]/mysql/slave_relay_log_info.ibd To/export/backup/2016-01-21_22-12-52/mysql/slave_relay_log_ Info.ibd.qp
[... done]
[Compressing]/mysql/slave_worker_info.ibd to/export/backup/2016-01-21_22-12-52/mysql/slave_worker_ Info.ibd.qp
[From] ... done
>> Log scanned up to (1510934)
>> Log scanned up to (1510934)
>> Log scanned up to (1510934)
>> Log scanned up to (1510934)
[... done]
[[] ... done
xtrabackup:creating suspend file '/export/backup/2016-01-21_22-12-52/xtrabackup_suspended_2 ' with PID ' 5476 '
160121 22:12:59 innobackupex:continuing after ibbackup have suspended
160121 22:12:59 innobackupex:starting to lock all tables ...
160121 22:12:59 innobackupex:all tables locked and flushed to disk
160121 22:12:59 innobackupex:starting to backup Non-innodb tables and files
Innobackupex:in subdirectories of '/export/data/mysql/data/'
innobackupex:backing up files '/export/data/mysql/data//mysql/*. {Frm,isl,myd,myi,mad,mai,mrg,trg,trn,arm,arz,csm,csv,opt,par} ' (*)
>> Log scanned up to (1510934)
innobackupex:backing up files '/export/data/mysql/data//performance_schema/*. {Frm,isl,myd,myi,mad,mai,mrg,trg,trn,arm,arz,csm,csv,opt,par} ' (All files)
160121 22:13:00 innobackupex:finished backing up non-innodb tables and files
160121 22:13:00 innobackupex:waiting for log copying to finish
Xtrabackup:the Latest Check Point (for incremental): ' 1510934 '
xtrabackup:stopping log copying thread.
.>> Log scanned up to (1510934)
xtrabackup:creating suspend file '/export/backup/2016-01-21_22-12-52/xtrabackup_log_copied ' with PID ' 5476 '
Xtrabackup:transaction Log of LSN (1510934) to (1510934) was copied.
160121 22:13:01 innobackupex:all Tables Unlocked
Innobackupex:backup created in directory '/export/backup/2016-01-21_22-12-52 '
Innobackupex:mysql binlog position:filename ' mysql-bin.000007 ', position 120
160121 22:13:01 innobackupex:connection to database server closed
160121 22:13:01 innobackupex:completed ok!
Innobackupex:Error:xtrabackup child process has died At/usr/bin/innobackupex