GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Newbie installing percona xtrabackup

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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 (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!

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

    Thanks!

    Comment

    Working...
    X