在備份的時候出現(xiàn)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 解決方法如下：原因是沒有找到my.cnf配置，指定--default-file參數(shù)即可 innobackupex-1.5.1 --user root --pass 123456 /tmp/backup --defaults-file=/etc/my.cnf

?

轉載于:https://blog.51cto.com/chlotte/376248

總結

以上是生活随笔為你收集整理的xtrabackup 9.0备份出错的解决方法的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。