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

Newbie installing percona xtrabackup

vjunior1981vjunior1981 EntrantInactive User Role Beginner
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 (c) 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! :)

Comments

  • vjunior1981vjunior1981 Entrant Inactive User Role Beginner
    I got this, after put the datadir parameter on /etc/my.cnf file.

    Thanks! :)
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.