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

[ernesto_vargas]

Attach is my copy of my.cnf

[root@pr2db2 ~]# innobackupex-1.5.1 --slave-info --stream=tar /tmp/ | gzip -> backup.tar.gz | ssh sr10.DOMIANNAME.com "cat -> backup.tar" | nc
usage: nc [-46DdhklnrStUuvzC] [-i interval] [-p source_port]
   [-s source_ip_address] [-T ToS] [-w timeout] [-X proxy_version]
   [-x proxy_address[:port]] [hostname] [port[s]]

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

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

IMPORTANT: Please check that the backup run completes successfully.
           At the end of a successful backup run innobackup
           prints "innobackup completed OK!".

innobackupex: Using mysql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (x86_64) using readline 5.0
innobackupex: Using mysql server version 5.0.45-log

innobackupex: fatal error: no 'mysqld' group in MySQL options
[root@pr2db2 ~]#

[xiaowei (xinmeng1124)]

HOW TO SLOVE THE QUESTION？

[tianma (tianma-1473)]

I also want to know id .

[Стас Агарков (stas-agarkov)]

I have this problem too.
I use command:
./innobackupex-1.5.1 --stream=tar . --databases=mysql --defaults-file=/etc/mysql/my.cnf --user=root --password=xxx --datadir=/var/lib/mysql> backup

[Стас Агарков (stas-agarkov)]

[gidra:~/xtrabackup-0.9] % ./innobackupex-1.5.1 --stream=tar . --databases=mysql --defaults-file=/etc/mysql/my.cnf --user=root --password=xxx> backup [11:59]
Version string '' contains invalid data; ignoring: '' at ./innobackupex-1.5.1 line 1590.

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

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

IMPORTANT: Please check that the backup run completes successfully.
           At the end of a successful backup run innobackup
           prints "innobackup completed OK!".

innobackupex: Using mysql Ver 14.12 Distrib 5.0.75, for debian-linux-gnu (i486) using readline 5.2
innobackupex: Using mysql server version 5.0.75-0ubuntu10.2-log

/usr/bin/xtrabackup: 1: Syntax error: "(" unexpected
innobackupex: fatal error: no 'mysqld' group in MySQL options

[Yasufumi Kinoshita (yasufumi-kinoshita)]

Please set parameter 'datadir' for 'mysqld' group...

[Yasufumi Kinoshita (yasufumi-kinoshita)]

Стас Агарков,

I cannot reproduce your problem only from your my.cnf.
Please check also cnf file in /etc/mysql/conf.d/...

[Yasufumi Kinoshita (yasufumi-kinoshita)]

exact message was added.

@@ -2067,6 +2067,7 @@
     if (!exists $config{$group}) {
         # no group
         print STDERR "$prefix fatal error: no '$group' group in MySQL options\n";
+ print STDERR "$prefix fatal error: OR no 'datadir' option in group '$group' in MySQL options\n";
         exit(1);
     }

[Стас Агарков (stas-agarkov)]

I have 'datadir' option. Directory /etc/mysql/conf.d/ is empty:
[gidra:~] % ll /etc/mysql/conf.d/
[gidra:~] %
'datadir' option is:
datadir = /var/lib/mysql
In there ibdata* files.
What else can you do?

[Yasufumi Kinoshita (yasufumi-kinoshita)]

Please check the following output.

> xtrabackup --defaults-file=/etc/mysql/my.cnf --print-param

[Стас Агарков (stas-agarkov)]

Oh, shit! I have 64-bit binary! I downloaded from the directory deb. Where can I get binaries for Ubuntu 9.04 32-bit?

[gidra:~/ibbackup] % xtrabackup --defaults-file=/etc/mysql/my.cnf --print-param [17:28]
zsh: exec format error: xtrabackup
[gidra:~/ibbackup] %

[Aleksandr Kuzminsky (akuzminsky)]

Stas,

32bit platform isn't officially supported but you can try the
following package:
http://www.percona.com/mysql/TESTING/xtrabackup-0.9/binary/xtrabackup-0.9-i386.tar.gz
Unfortunately there is no .deb package for debian 32 bit.

Best regadrs,
Aleksandr

[Стас Агарков (stas-agarkov)]

Thank you very much! Marvelous program! I would also like compression support:)

[Vadim Tkachenko (vadim-tk)]

Stas,

What kind of compression you would like ?

We have stream which allows you to compress via pipe.

--
Vadim Tkachenko, CTO, Percona Inc.
Phone [phone], ICQ: 369-510-335, Skype: vadimtk153,

2009/9/20 Стас Агарков <email address hidden>:
> Thank you very much! Marvelous program! I would also like compression
> support:)
>
> --
> innobackupex: fatal error: no 'mysqld' group in MySQL options
> https://bugs.launchpad.net/bugs/385359
> You received this bug notification because you are a member of Percona
> developers, which is the registrant for Percona-XtraBackup.
>
> Status in Open source backup tool for InnoDB and XtraDB: Fix Committed
>
> Bug description:
> Attach is my copy of my.cnf
>
> [root@pr2db2 ~]# innobackupex-1.5.1 --slave-info --stream=tar /tmp/ | gzip -> backup.tar.gz | ssh sr10.DOMIANNAME.com "cat -> backup.tar" | nc
> usage: nc [-46DdhklnrStUuvzC] [-i interval] [-p source_port]
>          [-s source_ip_address] [-T ToS] [-w timeout] [-X proxy_version]
>          [-x proxy_address[:port]] [hostname] [port[s]]
>
> InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy.
> All Rights Reserved.
>
> This software is published under
> the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
>
> IMPORTANT: Please check that the backup run completes successfully.
>           At the end of a successful backup run innobackup
>           prints "innobackup completed OK!".
>
> innobackupex: Using mysql  Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (x86_64) using readline 5.0
> innobackupex: Using mysql server version 5.0.45-log
>
> innobackupex: fatal error: no 'mysqld' group in MySQL options
> [root@pr2db2 ~]#
>

[Стас Агарков (stas-agarkov)]

I'm talking about the option --compress.
Now I compress after the creation of backup command tar czf, but it would be a built-in option:)

[Shamu (shahmatd)]

I had also encountered this error, when using the downloaded Linux binary format (tarball)

As it turns out you'd need to have the xtrabackup file be copied into any of the directory that you may have defined under $PATH

The innobackupex-1.5.1 (perl script) will attempt to execute the xtrabackup (which is a binary file)

Scenario: xtrabackup-1.2.tar.gz was extracted under the root's home directory and extracted under ~/xtrabackup-1.2

[root@db01 bin]# cd ~/xtrabackup
[root@db01 bin]# ./innobackupex-1.5.1 /db/backup/

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

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

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.12 Distrib 5.0.77, for redhat-linux-gnu (x86_64) using readline 5.1
innobackupex-1.5.1: Using mysql server version Copyright (C) 2000-2008 MySQL AB

Can't exec "xtrabackup": No such file or directory at ./innobackupex-1.5.1 line 2054.
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@db01 bin]# export PATH=$PATH:.

[root@db01 bin]# ./innobackupex-1.5.1 /db/backup --user=root --password=lagoon --socket=/db/mysql.sock

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

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

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.12 Distrib 5.0.77, for redhat-linux-gnu (x86_64) using readline 5.1
innobackupex-1.5.1: Using mysql server version Copyright (C) 2000-2008 MySQL AB

innobackupex-1.5.1: Created backup directory /db/backup/2010-10-20_14-58-45
101020 14:58:45 innobackupex-1.5.1: Starting mysql with options: --password=lagoon --user=root --socket=/db/mysql.sock --unbuffered --
101020 14:58:45 innobackupex-1.5.1: Connected to database with mysql child process (pid=15064)
101020 14:58:49 innobackupex-1.5.1: Connection to database server closed

101020 14:58:49 innobackupex-1.5.1: Starting ibbackup with command: xtrabackup --backup --suspend-at-end --target-dir=/db/backup/2010-10-20_14-58-45
innobackupex-1.5.1: Waiting for ibbackup (pid=15071) to suspend
innobackupex-1.5.1: Suspend file '/db/backup/2010-10-20_14-58-45/xtrabackup_suspended'

xtrabackup Ver 1.2 Rev undefined for 5.1.45 unknown-linux-gnu (x86_64)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /db/data
xtrabackup: Target instance is assumed as followings.
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 = 5242880
>> log scanned up to (76432)
Copying ./ibdata1
     to /db/backup/2010-10-20_14-58-45/ibda...

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-1052