Newbie installing percona xtrabackup

Hi there, first of all, sorry for my pour english. I’m a Oracle DBA and i’m trying MySQL and backup tools.
I’ve installed percona xtrabackup, and the rpm installation it’s ok, but when I try to run a backup I get this on the end:

xtrabackup: Error: Please set parameter ‘datadir’
innobackupex: fatal error: no ‘mysqld’ group in MySQL options
innobackupex: fatal error: OR no ‘datadir’ option in group ‘mysqld’ in MySQL options

More information:

linux-wxmu:/u01/backups # cat /etc/*release
NAME=openSUSE
VERSION = 12.1 (Asparagus)
VERSION_ID=“12.1”
PRETTY_NAME=“openSUSE 12.1 (Asparagus) (x86_64)”
ID=opensuse
openSUSE 12.1 (x86_64)
VERSION = 12.1
CODENAME = Asparagus

linux-wxmu:/u01/backups # uname -a
Linux linux-wxmu 3.1.0-1.2-desktop #1 SMP PREEMPT Thu Nov 3 14:45:45 UTC 2011 (187dde0) x86_64 x86_64 x86_64 GNU/Linux
linux-wxmu:/u01/backups #

linux-wxmu:/u01/backups # whoami
root
linux-wxmu:/u01/backups # innobackupex --user=root --password=password /u01/backups/

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.

120416 14:35:49 innobackupex: Starting mysql with options: --password=xxxxxxxx --user=‘root’ --unbuffered –
120416 14:35:49 innobackupex: Connected to database with mysql child process (pid=9373)
120416 14:35:55 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.5.23, for Linux (x86_64) using readline 5.1
innobackupex: Using mysql server version Copyright © 2000, 2011, Oracle and/or its affiliates. All rights reserved.

xtrabackup: Error: Please set parameter ‘datadir’
innobackupex: fatal error: no ‘mysqld’ group in MySQL options
innobackupex: fatal error: OR no ‘datadir’ option in group ‘mysqld’ in MySQL options
linux-wxmu:/u01/backups # xtrabackup --datadir=/var/lib/mysql/ --print-param

This MySQL options file was generated by XtraBackup.

[mysqld]
datadir = “/var/lib/mysql/”
tmpdir = “/tmp”
innodb_data_home_dir = “/var/lib/mysql/”
innodb_data_file_path = “ibdata1:10M:autoextend”
innodb_log_group_home_dir = “/var/lib/mysql/”
innodb_log_files_in_group = 2
innodb_log_file_size = 5242880
innodb_flush_method = “”
innodb_fast_checksum = 0
innodb_page_size = 16384
innodb_log_block_size = 512
linux-wxmu:/u01/backups #

Any more information I can post here, just say. Thanks! :slight_smile:

I got this, after put the datadir parameter on /etc/my.cnf file.

Thanks! :slight_smile: