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/

Your my.cnf/defaults file file needs:

datadir = /path/to/data
  • Thanks for responding ... It is there (datadir) ... But I doubt on the am I issuing the correct options for MyIsam tables ....? – arn Jun 2 '12 at 5: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 8 '12 at 10:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.