Changed innodb_log_file_size = 512M to loose-innodb_log_file_size = 512M sudo innobackupex /tmp 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. 120926 17:45:33 innobackupex: Starting mysql with options: --unbuffered -- 120926 17:45:33 innobackupex: Connected to database with mysql child process (pid=3355) 120926 17:45:39 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.27, 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. innobackupex: Created backup directory /tmp/2012-09-26_17-45-39 120926 17:45:39 innobackupex: Starting mysql with options: --unbuffered -- 120926 17:45:39 innobackupex: Connected to database with mysql child process (pid=3382) 120926 17:45:41 innobackupex: Connection to database server closed 120926 17:45:41 innobackupex: Starting ibbackup with command: xtrabackup_55 --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/tmp/2012-09-26_17-45-39 innobackupex: Waiting for ibbackup (pid=3389) to suspend innobackupex: Suspend file '/tmp/2012-09-26_17-45-39/xtrabackup_suspended' xtrabackup_55 version 2.0.2 for Percona Server 5.5.16 Linux (x86_64) (revision id: 461) xtrabackup: uses posix_fadvise(). xtrabackup: cd to /var/lib/mysql xtrabackup: Target instance is assumed as followings. xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 5242880 120926 17:45:41 InnoDB: Using Linux native AIO 120926 17:45:41 InnoDB: Warning: allocated tablespace 10, old maximum was 9 InnoDB: Error: log file ./ib_logfile0 is of different size 0 536870912 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! innobackupex: Error: ibbackup child process has died at /usr/bin/innobackupex line 374. ====================================================================================== Reverted that change back and now it worked raghu archie:~ [92:2]% sudo innobackupex /tmp 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. 120926 17:47:03 innobackupex: Starting mysql with options: --unbuffered -- 120926 17:47:03 innobackupex: Connected to database with mysql child process (pid=3406) 120926 17:47:09 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.27, 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. innobackupex: Created backup directory /tmp/2012-09-26_17-47-09 120926 17:47:09 innobackupex: Starting mysql with options: --unbuffered -- 120926 17:47:09 innobackupex: Connected to database with mysql child process (pid=3432) 120926 17:47:11 innobackupex: Connection to database server closed 120926 17:47:11 innobackupex: Starting ibbackup with command: xtrabackup_55 --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/tmp/2012-09-26_17-47-09 innobackupex: Waiting for ibbackup (pid=3439) to suspend innobackupex: Suspend file '/tmp/2012-09-26_17-47-09/xtrabackup_suspended' xtrabackup_55 version 2.0.2 for Percona Server 5.5.16 Linux (x86_64) (revision id: 461) xtrabackup: uses posix_fadvise(). xtrabackup: cd to /var/lib/mysql xtrabackup: Target instance is assumed as followings. xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 2 xtrabackup: innodb_log_file_size = 536870912 120926 17:47:11 InnoDB: Using Linux native AIO 120926 17:47:11 InnoDB: Warning: allocated tablespace 10, old maximum was 9 >> log scanned up to (1602118) [01] Copying ./ibdata1 to /tmp/2012-09-26_17-47-09/ibdata1 [01] ...done [01] Copying ./test/t1.ibd to /tmp/2012-09-26_17-47-09/./test/t1.ibd [01] ...done 120926 17:47:15 innobackupex: Continuing after ibbackup has suspended 120926 17:47:15 innobackupex: Starting mysql with options: --unbuffered -- 120926 17:47:15 innobackupex: Connected to database with mysql child process (pid=3453) >> log scanned up to (1602118) 120926 17:47:17 innobackupex: Starting to lock all tables... >> log scanned up to (1602118) >> log scanned up to (1602118) 120926 17:47:27 innobackupex: All tables locked and flushed to disk 120926 17:47:27 innobackupex: Starting to backup .frm, .MRG, .MYD, .MYI, innobackupex: .TRG, .TRN, .ARM, .ARZ, .CSM, .CSV and .opt files in innobackupex: subdirectories of '/var/lib/mysql' innobackupex: Backing up file '/var/lib/mysql/sbtest/db.opt' innobackupex: Backing up file '/var/lib/mysql/test/t.MYD' innobackupex: Backing up file '/var/lib/mysql/test/t1.frm' innobackupex: Backing up file '/var/lib/mysql/test/t.frm' innobackupex: Backing up file '/var/lib/mysql/test/t.MYI' innobackupex: Backing up files '/var/lib/mysql/performance_schema/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (18 files) innobackupex: Backing up files '/var/lib/mysql/mysql/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (72 files) 120926 17:47:28 innobackupex: Finished backing up .frm, .MRG, .MYD, .MYI, .TRG, .TRN, .ARM, .ARZ, .CSV, .CSM and .opt files innobackupex: Resuming ibbackup xtrabackup: The latest check point (for incremental): '1602118' xtrabackup: Stopping log copying thread. .>> log scanned up to (1602118) xtrabackup: Transaction log of lsn (1602118) to (1602118) was copied. 120926 17:47:30 innobackupex: All tables unlocked 120926 17:47:30 innobackupex: Connection to database server closed innobackupex: Backup created in directory '/tmp/2012-09-26_17-47-09' innobackupex: MySQL binlog position: filename 'mysql-bin.000004', position 107 120926 17:47:30 innobackupex: completed OK!