在备份的时候出现innobackupex: fatal error: no 'mysqld' group in MySQL options错误
[root@db 110 bin]# ./innobackupex-1.5.1 /tmp/backup --defaults-file=/etc/my.cnf --user=root --password=123456
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.14 Distrib 5.1.24-rc, for redhat-linux-gnu (x86_64) using readline 5.1
innobackupex: Using mysql server version 5.1.24-rc-community-log
innobackupex:: Warning: Ignored unrecognized line 2 in options : 'xtrabackup: Error: Please set parameter 'datadir'
'
innobackupex: fatal error: no 'mysqld' group in MySQL options
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.14 Distrib 5.1.24-rc, for redhat-linux-gnu (x86_64) using readline 5.1
innobackupex: Using mysql server version 5.1.24-rc-community-log
innobackupex:: Warning: Ignored unrecognized line 2 in options : 'xtrabackup: Error: Please set parameter 'datadir'
'
innobackupex: fatal error: no 'mysqld' group in MySQL options
解决方法如下:原因是没有找到my.cnf配置,指定--default-file参数即可
innobackupex-1.5.1 --user root --pass 123456 /tmp/backup --defaults-file=/etc/my.cnf
转载于:https://blog.51cto.com/chlotte/376248