Hey!
I am trying to use
Percona XtraBackup for creating backups of mysql with InnoDB tables.
First I start to create backup from slave server:
sudo innobackupex --defaults-file=/etc/my.cnf --parallel=4 --password='mypass' --slave-info --safe-slave-backup --compress --compress-threads=4 --rsync --throttle=30 /backups/test/
Some InnoDB info:
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 = 1073741824
After 15 minutes I recieve message
innobackupex: completed OK!
I see files:
backup-my.cnf
mysql
xtrabackup_checkpoints
zabbix
ibdata1
performance_schema
xtrabackup_info
ibdata1.qp
test
xtrabackup_slave_info
Then, if I understood everything correctly, I must re-create log files. So I do
sudo innobackupex --apply-log --redo-only --defaults-file=/etc/my.cnf --parallel=4 --password='mypass' --no-timestamp --slave-info --safe-slave-backup --compress --compress-threads=4 --rsync --throttle=30 /backups/test/2015-02-17_09-26-12
And I see:
xtrabackup version 2.2.6 based on MySQL server 5.6.21 Linux (x86_64) (revision id: )
xtrabackup: cd to /backups/test/2015-02-17_09-26-12
xtrabackup: This target seems to be not prepared yet.
2015-02-17 12:56:25 7ff58bdc8720 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
xtrabackup: Warning: cannot open ./xtrabackup_logfile. will try to find.
xtrabackup: Fatal error: cannot find ./xtrabackup_logfile.
xtrabackup: Error: xtrabackup_init_temp_log() failed.
innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 2632
main::apply_log() called at /usr/bin/innobackupex line 1561
innobackupex: Error:
innobackupex: ibbackup failed at /usr/bin/innobackupex line 2632.
For some reason I do not have "xtrabackup_logfile", although backup creation was completed successfully.
Do you have any ideas about what am I doing wrong?
Thanks in advance, Viktor.