{"id":1899,"date":"2013-05-27T05:46:14","date_gmt":"2013-05-27T05:46:14","guid":{"rendered":"http:\/\/kedar.nitty-witty.com\/?p=1899"},"modified":"2015-02-26T14:07:33","modified_gmt":"2015-02-26T14:07:33","slug":"innobackupex-1-5-1-fatal-error-no-mysqld-group-in-mysql-options","status":"publish","type":"post","link":"https:\/\/kedar.nitty-witty.com\/blog\/innobackupex-1-5-1-fatal-error-no-mysqld-group-in-mysql-options","title":{"rendered":"xtrabackup_51: not found & no ‘mysqld’ group in MySQL options"},"content":{"rendered":"

Recently I happen to setup a new MySQL instance with my tools – a standard MySQL 5.1+, xtrabackup setup and last-hotbackup.tar.gz.<\/p>\n

To restore from the backup we used xtrabackup binaries and ran into issues following standard commands (assuming no changes):<\/p>\n

To prepare the backup I used apply-log as follows:<\/p>\n

$] innobackupex-1.5.1 --defaults-file=\/usr\/local\/mysql\/data\/backup-my.cnf --apply-log\u00a0 \/usr\/local\/mysql\/data --ibbackup xtrabackup_51<\/code><\/p>\n


\nInnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
\nand Percona Ireland Ltd 2009-2012.\u00a0 All Rights Reserved.<\/code><\/p>\n

This software is published under
\nthe GNU GENERAL PUBLIC LICENSE Version 2, June 1991.<\/code><\/p>\n

IMPORTANT: Please check that the apply-log run completes successfully.
\nAt the end of a successful apply-log run innobackupex-1.5.1
\nprints \"completed OK!\".<\/code><\/p>\n


\nsh: 1: xtrabackup_51: not found
\ninnobackupex-1.5.1: fatal error: no 'mysqld' group in MySQL options<\/code><\/p>\n

[ Update:<\/b> or you may find error as follows
\nsh: 1: xtrabackup_55: not found
\ninnobackupex: got a fatal error with the following stacktrace: at \/usr\/bin\/innobackupex line 4482. ]<\/p>\n

To my surprise I really didn’t find xtrabackup_51 under path – Later I verified the version for Xtrabackup is 2.1.1 & learnt that xtrabackup_51 is absent with percona-xtrabackup 2.1.1 binaries.
\n~\/bin$ ls -lhtr
\ntotal 157M
\ndrwxr-xr-x 4 kedar kedar 4.0K May 13 21:24 percona-xtrabackup-2.1.1
\n-rwxr-xr-x 1 kedar kedar 16M May 13 21:30 xtrabackup_55
\n-rwxr-xr-x 1 kedar kedar 78M May 13 21:36 xtrabackup_56
\n-rwxr-xr-x 1 kedar kedar 13M May 13 21:42 xtrabackup
\n-rwxr-xr-x 1 kedar kedar 2.2M May 13 21:42 xbstream
\n-rwxr-xr-x 1 kedar kedar 2.2M May 13 21:42 xbcrypt
\nlrwxrwxrwx 1 kedar kedar 12 May 13 21:42 innobackupex-1.5.1 -> innobackupex
\n-rwxr-xr-x 1 kedar kedar 108K May 13 21:42 innobackupex
\n-rw-rw-r-- 1 kedar kedar 47M May 13 21:44 percona-xtrabackup-2.1.1-600.tar.gz<\/code><\/p>\n

That’s not cool, I thought until I read an important release note: “Support for InnoDB 5.0 and InnoDB 5.1 builtin has been removed from Percona XtraBackup.” [Release notes: http:\/\/www.percona.com\/doc\/percona-xtrabackup\/2.1\/release-notes\/2.1\/2.1.1.html] .<\/p>\n

Options with me were:
\n1. Disable built-in Innodb and enable Innodb plugin or use Percona’s MySQL build
\n2. Use –ibbbackup xtarbackup (not xtrabackup_51)
\n3. Use XtraBackup 2.0 series for default built-in Innodb<\/p>\n

– I upgraded the MySQL to use Percona’s build and executed –apply-logs specifying –ibbackup xtrabackup<\/p>\n

The bug report [https:\/\/bugs.launchpad.net\/percona-xtrabackup\/+bug\/1180905] is already in place and the issue has been resolved in the later version 2.1.2. Fixes: “innobackupex automatic version detection did not work correctly for latest Percona Server and MySQL 5.1 releases which could cause innobackupex to fail.”<\/p>\n

For using MySQL 5.1+ with built-in support we can use Percona XtraBackup 2.0.
\nSupport for MySQL 5.1 with builtin InnoDB (not the plugin) was removed in Percona XtraBackup 2.1. The last version to support MySQL 5.1 with builtin InnoDB was Percona XtraBackup 2.0. – conveyed @productiondba<\/p>\n

Take out:
\n– Upgrade your xtrabackup to latest Percona XtraBackup Version (Yep, today it’s 2.1.3, not 2.1.2)
\n– Make sure we read release notes before using the latest build \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"Recently I happen to setup a new MySQL instance with my tools – a standard MySQL 5.1+, xtrabackup setup and last-hotbackup.tar.gz. To restore from the backup we used xtrabackup binaries…\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[8,377],"tags":[15,370,368,367,427,366,369],"class_list":["post-1899","post","type-post","status-publish","format-standard","category-mysql","category-mysql-articles","tag-backup","tag-bug","tag-hotbackup","tag-innobackup","tag-mysql","tag-restore","tag-xtrabackup"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t