Hello everyone,
Even i facing similar kind of problem
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Ireland Ltd 2009-2012. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
130628 20:12:59 innobackupex-1.5.1: Starting mysql with options: --unbuffered –
130628 20:12:59 innobackupex-1.5.1: Connected to database with mysql child process (pid=1480)
130628 20:13:05 innobackupex-1.5.1: Connection to database server closed
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex-1.5.1
prints “completed OK!”.
innobackupex-1.5.1: Using mysql Ver 14.14 Distrib 5.1.68, for unknown-linux-gnu (x86_64) using readline 5.1
innobackupex-1.5.1: Using mysql server version Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
xtrabackup_51: ambiguous option ‘–log=/var/log/general_query.log’ (log-copy-interval, log-stream)
innobackupex-1.5.1: fatal error: no ‘mysqld’ group in MySQL options
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Ireland Ltd 2009-2012. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
option_ibbackup_binary is autodetect, trying to connect to MySQL
Connected to MySQL with pid 1509
130628 20:13:06 innobackupex-1.5.1: Connection to database server closed
Connected successfully
130628 20:13:06 innobackupex-1.5.1: Starting mysql with options: --unbuffered –
130628 20:13:06 innobackupex-1.5.1: Connected to database with mysql child process (pid=1514)
130628 20:13:12 innobackupex-1.5.1: Connection to database server closed
IMPORTANT: Please check that the apply-log run completes successfully.
At the end of a successful apply-log run innobackupex-1.5.1
prints “completed OK!”.
Could not open required defaults file: /home/mirror/mysql/backup-my.cnf
Fatal error in defaults handling. Program aborted
130628 20:13:12 innobackupex-1.5.1: Starting ibbackup with command: xtrabackup_51 --defaults-file=“/home/mirror/mysql/backup-my.cnf” --defaults-group=“mysqld” --prepare --target-dir=/home/mirror/mysql --use-memory=2G --tmpdir=/tmp
Could not open required defaults file: /home/mirror/mysql/backup-my.cnf
Fatal error in defaults handling. Program aborted
xtrabackup_51 version 2.0.7 for MySQL server 5.1.59 unknown-linux-gnu (x86_64) (revision id: 552)
xtrabackup_51: Can’t change dir to ‘/home/mirror/mysql’ (Errcode: 2)
xtrabackup: cannot my_setwd /home/mirror/mysql
innobackupex-1.5.1: Error:
innobackupex-1.5.1: ibbackup failed at /usr/bin/innobackupex-1.5.1 line 386.
root@ecslave2 [~]# rpm -qa |grep percona
percona-xtrabackup-2.0.7-552.rhel6.x86_64
percona-release-0.0-1.x86_64
percona-toolkit-2.2.3-1.noarch
root@ecslave2 [~]
-Percona Xtrabackup latest version doesnt support hence installed older version.
-CentOS release 6.4 (Final)= 2.6.32-220.23.1.el6.x86_64
-Mysql 5.1.68
If any have solve or know the fix , please let us know.
-Kunal Modi