Not the answer you need?
Register and ask your own question!

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

chanyipiaomiaochanyipiaomiao EntrantCurrent User Role Beginner
percona-xtrabackup-2.1.3
mysql 5.1.28-rc
Red Hat Enterprise Linux AS release 4 (Nahant)

17:24:41 [email protected] [/usr/local/percona-xtrabackup-2.1.3/bin] # innobackupex /mysql_backup/mysql_backup

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

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

130620 17:24:48 innobackupex: Starting mysql with options: --unbuffered --
130620 17:24:48 innobackupex: Connected to database with mysql child process (pid=411)
130620 17:24:54 innobackupex: Connection to database server closed
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints "completed OK!".

innobackupex: Using mysql Ver 14.14 Distrib 5.1.28-rc, for redhat-linux-gnu (i686) using readline 5.1
innobackupex: Using mysql server version Copyright (C) 2000-2008 MySQL AB

innobackupex: fatal error: no 'mysqld' group in MySQL options
innobackupex: fatal error: OR no 'datadir' option in group 'mysqld' in MySQL options
17:24:54 [email protected] [/usr/local/percona-xtrabackup-2.1.3/bin] #



/etc/my.cnf
[mysqld]
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data

Why? Please suggest

Comments

  • mirfanmirfan Database Administrator Inactive User Role Beginner
    There shouldn't be any problem. Can you please show me the output of

    mysql> show variables like 'datadir';

    Did you tried innobackupex with --defaults-file option ? e.g. --defaults-file=/etc/my.cnf
  • chanyipiaomiaochanyipiaomiao Entrant Current User Role Beginner
    Hi,

    12:18:19 [email protected] [~] # mysql
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 1660
    Server version: 5.1.28-rc-log MySQL Community Server (GPL)

    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

    mysql> show variables like 'datadir';
    +
    +
    +
    | Variable_name | Value |
    +
    +
    +
    | datadir | /usr/local/mysql/data/ |
    +
    +
    +
    1 row in set (0.00 sec)

    mysql>


    12:34:02 [email protected] [~] # innobackupex --defaults-file=/etc/my.cnf /mysql_backup/mysql_backup

    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.

    130621 12:34:18 innobackupex: Starting mysql with options: --defaults-file='/etc/my.cnf' --unbuffered --
    130621 12:34:18 innobackupex: Connected to database with mysql child process (pid=5851)
    130621 12:34:24 innobackupex: Connection to database server closed
    IMPORTANT: Please check that the backup run completes successfully.
    At the end of a successful backup run innobackupex
    prints "completed OK!".

    innobackupex: Using mysql Ver 14.14 Distrib 5.1.28-rc, for redhat-linux-gnu (i686) using readline 5.1
    innobackupex: Using mysql server version Copyright (C) 2000-2008 MySQL AB

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


    mysql> show plugins;
    +
    +
    +
    +
    +
    +
    | Name | Status | Type | Library | License |
    +
    +
    +
    +
    +
    +
    | binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | partition | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | InnoDB | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
    | MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
    +
    +
    +
    +
    +
    +
    9 rows in set (0.01 sec)
  • mirfanmirfan Database Administrator Inactive User Role Beginner
    I think i figured it out. From the Xtrabackup 2.1 documentation.
    "Support for InnoDB 5.0 and InnoDB 5.1 builtin has been removed from Percona XtraBackup"

    Can you try it with xtrabackup 2.0 or upgrade MySQL version ?
  • chanyipiaomiaochanyipiaomiao Entrant Current User Role Beginner
    yes ,i try xtrabackup-2.0.7 ,The problem is still
    i try Mysql 5.1.62 ,is OK.
  • revinrevin Contributor Current User Role Beginner
    @chanyipiaomiao,

    Check that this error is valid "innobackupex: fatal error: no 'mysqld' group in MySQL options", do you have a mysqld section on /etc/my.cnf?

    Another reason innobackupex would fail with this error is that it cannot find the proper xtrabackup binary. What does `which xtrabackup` give you? What MySQL server are you running ? Try specifying the full path to the correct xtrabackup binary with the --ibbackup option to innobackupex.
  • exaexa Entrant Current User Role Beginner
    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.
    ====

    [email protected] [~]# 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
    [email protected] [~]

    -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
  • mirfanmirfan Database Administrator Inactive User Role Beginner
    Hi,
    Can you please paste my.cnf and detailed steps which you tried along with mysql version.
  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    Hi,

    After backup is completed, can you check where exactly it stored? As per your command line, it should be at /home/mirror/mysql but as per error log, innobackupex can't able to find there.
    [B]Could not open required defaults file: /home/mirror/mysql/backup-my.cnf[/B]
    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)
    [B]xtrabackup_51: Can't change dir to '/home/mirror/mysql' (Errcode: 2)[/B]
    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.
    
    $ perror 2
    OS error code 2: No such file or directory
    $
    

    Can you provide the command line for --apply-log, output of "ls -al /home/mirror/mysql " and confirm that backup is completed successfully?
  • exaexa Entrant Current User Role Beginner
    Hi

    Backup doesnt start and we get below error " innobackupex-1.5.1: fatal error: no 'mysqld' group in MySQL options "
    Mysql,percona version is already mentioned in previous post.

    ===
    [email protected] [~]#
    [email protected] [~]# /usr/bin/innobackupex-1.5.1 --databases="<database_name>" /home/mirror/mysql --no-timestamp --defaults-file="/etc/my.cnf" --user=root --password='XX' --socket=/var/lib/mysql/mysql.sock

    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.

    130702 18:47:47 innobackupex-1.5.1: Starting mysql with options: --defaults-file='/etc/my.cnf' --password=xxxxxxxx --user='root' --socket='/var/lib/mysql/mysql.sock' --unbuffered --
    130702 18:47:47 innobackupex-1.5.1: Connected to database with mysql child process (pid=6643)
    130702 18:47:53 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.69, 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
    [email protected] [~]#
    [email protected] [~]#
    [email protected] [~]# ls -al /home/mirror/mysql
    total 8
    drwxr-xr-x 2 root root 4096 Jul 2 18:50 ./
    drwxr-xr-x. 3 root root 4096 Jul 2 18:50 ../
    [email protected] [~]#
    ====


    O/P of apply logs

    ===
    [email protected] [~]#
    [email protected] [~]# /usr/bin/innobackupex-1.5.1 --use-memory=2G --apply-log /home/mirror/mysql

    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 7004
    130702 18:52:26 innobackupex-1.5.1: Connection to database server closed
    Connected successfully
    130702 18:52:26 innobackupex-1.5.1: Starting mysql with options: --unbuffered --
    130702 18:52:26 innobackupex-1.5.1: Connected to database with mysql child process (pid=7008)
    130702 18:52:32 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

    130702 18:52:32 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: cd to /home/mirror/mysql
    xtrabackup: Error: cannot open ./xtrabackup_checkpoints
    xtrabackup: error: xtrabackup_read_metadata()
    xtrabackup: This target seems not to have correct metadata...
    130702 18:52:32 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.
    130702 18:52:32 InnoDB: Operating system error number 2 in a file operation.
    InnoDB: The error means the system cannot find the path specified.
    xtrabackup: Fatal error: cannot find ./xtrabackup_logfile.
    xtrabackup: Error: xtrabackup_init_temp_log() failed.
    innobackupex-1.5.1: Error:
    innobackupex-1.5.1: ibbackup failed at /usr/bin/innobackupex-1.5.1 line 386.
    [email protected] [~]#
    ====

    Please let me know if you wanted any other information.

    -Regards
    Kunal
  • niljoshiniljoshi MySQL Sage Inactive User Role Beginner
    Hi,

    Looks like root cause of this error is, "xtrabackup_51: ambiguous option '--log=/var/log/general_query.log' (log-copy-interval, log-stream)" . Deprecate log option is specified in my.cnf which is confusing xtrabackup. Can you replace "log" with "general-log" in my.cnf and try?

    Btw: when backup is not completed successfully, there is no use to prepare it by --apply-log.

    Regards,
    Nil
  • chethanjasichethanjasi Entrant Legacy User Role Beginner
    Hi,

    I need to create the incremental backups and restore them back. this is what I did

    1) Successfully Created incremental backups with innobackupex --folder names- BASEDIR, INCRDIR1, INCRDIR2, INCRDIR3

    2) Now I want to restore .. I believe the following steps are right
    step1: innobackupex --apply-log --redo-only BASEDIR
    step2: innobackupex --apply-log --redo-only BASEDIR --incremental-dir=INCRDIR1
    step3: innobackupex --apply-log --redo-only BASEDIR --incremental-dir=INCRDIR2

    and so on

    Issue:
    But when I run the first step I get the following error

    Cound not open required default files /root/Downloads/<BASEDIR>/backup-my.cnf
    fatal error in defaults handling. program aborted

    below is the stack trace:
    got fatal error with the following stack trace @/usr/bin/innobackupipex line 4545...

    We have given all the permission for the folder <BASEDIR> and <INCRDIR1> etc

    could some one help me pls
  • chethanjasichethanjasi Entrant Legacy User Role Beginner
    Hi,

    I need to create the incremental backups and restore them back. this is what I did

    1) Successfully Created incremental backups with innobackupex --folder names- BASEDIR, INCRDIR1, INCRDIR2, INCRDIR3

    2) Now I want to restore .. I believe the following steps are right
    step1: innobackupex --apply-log --redo-only BASEDIR
    step2: innobackupex --apply-log --redo-only BASEDIR --incremental-dir=INCRDIR1
    step3: innobackupex --apply-log --redo-only BASEDIR --incremental-dir=INCRDIR2

    and so on

    Issue:
    But when I run the first step I get the following error

    Cound not open required default files /root/Downloads/<BASEDIR>/backup-my.cnf
    fatal error in defaults handling. program aborted

    below is the stack trace:
    got fatal error with the following stack trace @/usr/bin/innobackupipex line 4545...

    We have given all the permission for the folder <BASEDIR> and <INCRDIR1> etc

    could some one help me pls
  • chethanjasichethanjasi Entrant Legacy User Role Beginner
    Hi,

    I need to create the incremental backups and restore them back. this is what I did

    1) Successfully Created incremental backups with innobackupex --folder names- BASEDIR, INCRDIR1, INCRDIR2, INCRDIR3

    2) Now I want to restore .. I believe the following steps are right
    step1: innobackupex --apply-log --redo-only BASEDIR
    step2: innobackupex --apply-log --redo-only BASEDIR --incremental-dir=INCRDIR1
    step3: innobackupex --apply-log --redo-only BASEDIR --incremental-dir=INCRDIR2

    and so on

    Issue:
    But when I run the first step I get the following error

    Cound not open required default files /root/Downloads/<BASEDIR>/backup-my.cnf
    fatal error in defaults handling. program aborted

    below is the stack trace:
    got fatal error with the following stack trace /usr/bin/innobackupipex line 4545...

    We have given all the permission for the folder <BASEDIR> and <INCRDIR1> etc

    could some one help me pls
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.