innobackupex error on Centos 6.2

[Kevin Cao]

I'm getting this error when running innobackupex on a minimal Centos 6.2 install.

innobackupex: fatal error: no 'mysqld' group in MySQL options

innobackupex: fatal error: OR no 'datadir' option in group 'mysqld' in MySQL options

I ran these commands to install Percona.

1. rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm

2. yum -y install Percona-Server-client-51 Percona-Server-server-51 Percona-Server-shared-compat

3. yum -y install xtrabackup

4. cp /usr/share/mysql/my-huge.cnf /etc/my.cnf

When I run "innobackupex-1.5.1 --defaults-file=/etc/my.cnf /backup" I get an error.

...

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy

and Percona Inc 2009-2011.  All Rights Reserved.

This software is published under

the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

120127 21:59:46  innobackupex-1.5.1: Starting mysql with options:  --defaults-file='/etc/my.cnf' --unbuffered --

120127 21:59:46  innobackupex-1.5.1: Connected to database with mysql child process (pid=5711)

120127 21:59:52  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.60, for unknown-linux-gnu (x86_64) using readline 5.1

innobackupex-1.5.1: Using mysql server version Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

sh: --: invalid option

Usage: sh [GNU long option] [option] ...

sh [GNU long option] [option] script-file ...

GNU long options:

--debug

--debugger

--dump-po-strings

--dump-strings

--help

--init-file

--login

--noediting

--noprofile

--norc

--posix

--protected

--rcfile

--rpm-requires

--restricted

--verbose

--version

Shell options:

-irsD or -c command or -O shopt_option (invocation only)

-abefhkmnptuvxBCHP or -o option

innobackupex-1.5.1: fatal error: no 'mysqld' group in MySQL options

innobackupex-1.5.1: fatal error: OR no 'datadir' option in group 'mysqld' in MySQL options

root@ops3:/root# 

I also made sure that "datadir = /var/lib/mysql" was in /etc/my.cnf.

Any ideas? Thanks!

Kuiggie

[Jervin R]

This is a known bug https://bugs.launchpad.net/percona-xtrabackup/+bug/910206

A workaround is to specify the ibbackup option explicitly i.e. --
ibbackup=xtrabackup

On Jan 28, 2:13 pm, Kevin Cao <kui....@gmail.com> wrote:
> I'm getting this error when running innobackupex on a minimal Centos 6.2 install.
>
> innobackupex: fatal error: no 'mysqld' group in MySQL options
> innobackupex: fatal error: OR no 'datadir' option in group 'mysqld' in MySQL options
>
> I ran these commands to install Percona.
>

> 1. rpm -Uhvhttp://www.percona.com/downloads/percona-release/percona-release-0.0-...