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

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

dbabertranddbabertrand EntrantLegacy User Role Beginner
We are getting the below error while running innobackup on a mysql 5.0.95 database. Can anybody help please?

Comments

  • dbabertranddbabertrand Entrant Legacy User Role Beginner
    [[email protected] bin]# ./innobackupex-1.5.1 /home/e141027/bkp --defaults-file=/etc/my.cnf --user=root

    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.

    141117 11:28:53 innobackupex-1.5.1: Starting mysql with options: --defaults-file='/etc/my.cnf' --user='root' --unbuffered --
    141117 11:28:53 innobackupex-1.5.1: Connected to database with mysql child process (pid=24226)
    141117 11:29:00 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.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

    sh: xtrabackup_51: command not found
    innobackupex-1.5.1: fatal error: no 'mysqld' group in MySQL options
    [[email protected] bin]# innobackupex-1.5.1: fatal error: no 'mysqld'
    -bash: innobackupex-1.5.1:: command not found
    [[email protected] bin]#
    [[email protected] bin]# innobackupex-1.5.1: fatal error: no 'mysqld' group in MySQL options
  • mirfanmirfan Database Administrator Inactive User Role Beginner
    As per documentation described here http://www.percona.com/doc/percona-xtrabackup/2.2/

    "It can back up data from InnoDB, XtraDB, and MyISAM tables on MySQL 5.1 [1], 5.5 and 5.6 servers"

    So you will require atleast MySQL 5.1
  • dbabertranddbabertrand Entrant Legacy User Role Beginner
    Sorry Xtrabackup can works fine on Mysql 5.0, the issue was that the binaries was not present in the PATH. After changing everything works well.
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.