1

I am trying to implement hot backup for MyIsam tables with "percona-xtrabackup-2.0.0" and getting the following error? As the all tables are MyIsam I doubt am I using the correct package ?

  Backup :
    ./innobackupex --user="root" --password=*** --defaults-file="<path>/my.cnf" --ibbackup="<path>/percona-xtrabackup-2.0.0/bin/xtrabackup" <path>/backup/

    innobackupex: fatal error: no 'mysqld' group in MySQL options
    innobackupex: fatal error: OR no 'datadir' option in group 'mysqld' in MySQL options

    apply-log :

    ./innobackupex-1.5.1 --apply-log --defaults-file=<path>/backup/2012-06-02_09-59-30/backup-my.cnf --ibbackup=<path>/percona-xtrabackup-2.0.0/bin/xtrabackup <path>/backup/2012-06-02_09-59-30/
quanta
  • 50,327
  • 19
  • 152
  • 213
arn
  • 91
  • 2
  • 7

1 Answers1

0

Your my.cnf/defaults file file needs:

[mysqld]
datadir = /path/to/data
thinice
  • 4,676
  • 20
  • 38
  • Thanks for responding ... It is there (datadir) ... But I doubt on the am I issuing the correct options for MyIsam tables ....? – arn Jun 02 '12 at 05:51
  • This issue has resolved the replacing the current percona-xtrabackup-2.0.0 binary for centos. But Now I am facing the following error : – arn Jun 08 '12 at 10:03