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
[ Update:<\/b> or you may find error as follows 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. 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: – 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. Take out:$] 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>\nThis software is published under
\nthe GNU GENERAL PUBLIC LICENSE Version 2, June 1991.<\/code><\/p>\nIMPORTANT: 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
\nsh: 1: xtrabackup_55: not found
\ninnobackupex: got a fatal error with the following stacktrace: at \/usr\/bin\/innobackupex line 4482. ]<\/p>\n
\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
\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
\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
\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":{"0":"post-1899","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-mysql","7":"category-mysql-articles","8":"tag-backup","9":"tag-bug","10":"tag-hotbackup","11":"tag-innobackup","12":"tag-mysql","13":"tag-restore","14":"tag-xtrabackup"},"aioseo_notices":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/1899","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/comments?post=1899"}],"version-history":[{"count":16,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/1899\/revisions"}],"predecessor-version":[{"id":1912,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/1899\/revisions\/1912"}],"wp:attachment":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/media?parent=1899"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/categories?post=1899"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/tags?post=1899"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}