[hs221732@fimafeng10]/export/home2/tmp/mysql-5.1-ihb: perl innobackup --apply-log hema-inno.cnf /export/home2/tmp/mysql-5.1-ihb/mysql-test/backup/2010-04-20_17-34-37/ --ibbackup=/export/home2/tmp/mysql-5.1-ihb/ibbackup InnoDB Backup Utility v1.7-beta1; Copyright 2003, 2009 Innobase Oy. All Rights Reserved. This software is published under the GNU GENERAL PUBLIC LICENSE Version 2, June 1991. IMPORTANT: Please check that the apply-log run completes successfully. At the end of a successful apply-log run innobackup prints "innobackup completed OK!". innobackup: Using InnoDB Hot Backup 3.5-beta7 100420 17:47:24 innobackup: Starting ibbackup with command: /export/home2/tmp/mysql-5.1-ihb/ibbackup --restore /export/home2/tmp/mysql-5.1-ihb/mysql-test/backup/2010-04-20_17-34-37//backup-my.cnf InnoDB Hot Backup 3.5-beta7; Copyright 2002-2009 Innobase Oy License A00001 is granted to Innobase Oy Run ibbackup --license for detailed license terms, --help for help Contents of /export/home2/tmp/mysql-5.1-ihb/mysql-test/backup/2010-04-20_17-34-37//backup-my.cnf: innodb_data_home_dir got value mysql-test/backup//2010-04-20_17-34-37 innodb_data_file_path got value ibdata1:10M:autoextend datadir got value mysql-test/backup//2010-04-20_17-34-37 innodb_log_group_home_dir got value mysql-test/backup//2010-04-20_17-34-37 innodb_log_files_in_group got value 2 innodb_log_file_size got value 5242880 100420 17:47:24 ibbackup: ibbackup_logfile's creation parameters: ibbackup: start lsn 50176, end lsn 53486, ibbackup: start checkpoint 50462. InnoDB: Doing recovery: scanned up to log sequence number 53486 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 Setting log file size to 0 5242880 Setting log file size to 0 5242880 ibbackup: We were able to parse ibbackup_logfile up to ibbackup: lsn 53486. ibbackup: The first data file is 'mysql-test/backup//2010-04-20_17-34-37/ibdata1' ibbackup: and the new created log files are at 'mysql-test/backup//2010-04-20_17-34-37/' ibbackup: System tablespace file format is Antelope. 100420 17:47:25 ibbackup: Full backup prepared for recovery successfully! 100420 17:47:25 innobackup: innobackup completed OK! ========================================================================================================================================================== The backupdir contents after executing apply-log shows, ls -laR `pwd` /export/home2/tmp/mysql-5.1-ihb/mysql-test/backup: total 12 drwxr-xr-x 3 hs221732 wheel 4096 Apr 20 17:48 . drwxr-xr-x 12 hs221732 wheel 4096 Apr 20 17:45 .. drwxr-xr-x 7 hs221732 wheel 4096 Apr 20 17:47 2010-04-20_17-34-37 /export/home2/tmp/mysql-5.1-ihb/mysql-test/backup/2010-04-20_17-34-37: total 20564 drwxr-xr-x 7 hs221732 wheel 4096 Apr 20 17:47 . drwxr-xr-x 3 hs221732 wheel 4096 Apr 20 17:48 .. -rw-r--r-- 1 hs221732 wheel 358 Apr 20 17:34 backup-my.cnf drwxr-x--- 2 hs221732 wheel 4096 Apr 20 17:35 db1 drwxr-x--- 2 hs221732 wheel 4096 Apr 20 17:35 db2 -rw-r--r-- 1 hs221732 wheel 1 Apr 20 17:35 ibbackup_binlog_info -rw-r----- 1 hs221732 wheel 4096 Apr 20 17:35 ibbackup_logfile -rw-r----- 1 hs221732 wheel 10485760 Apr 20 17:47 ibdata1 -rw-r----- 1 hs221732 wheel 5242880 Apr 20 17:47 ib_logfile0 -rw-r----- 1 hs221732 wheel 5242880 Apr 20 17:47 ib_logfile1 drwxr-xr-x 2 hs221732 wheel 4096 Apr 20 17:35 mtr drwxr-xr-x 2 hs221732 wheel 4096 Apr 20 17:35 mysql -rw-r--r-- 1 hs221732 wheel 0 Apr 20 17:34 mysql-stderr -rw-r--r-- 1 hs221732 wheel 466 Apr 20 17:35 mysql-stdout drwxr-xr-x 2 hs221732 wheel 4096 Apr 20 17:35 test /export/home2/tmp/mysql-5.1-ihb/mysql-test/backup/2010-04-20_17-34-37/db1: total 124 drwxr-x--- 2 hs221732 wheel 4096 Apr 20 17:35 . drwxr-xr-x 7 hs221732 wheel 4096 Apr 20 17:47 .. -rw-rw---- 1 hs221732 wheel 65 Apr 20 17:22 db.opt -rw-rw---- 1 hs221732 wheel 8556 Apr 20 17:24 t1.frm -rw-r----- 1 hs221732 wheel 98304 Apr 20 17:34 t1.ibd /export/home2/tmp/mysql-5.1-ihb/mysql-test/backup/2010-04-20_17-34-37/db2: total 124 drwxr-x--- 2 hs221732 wheel 4096 Apr 20 17:35 . drwxr-xr-x 7 hs221732 wheel 4096 Apr 20 17:47 .. -rw-rw---- 1 hs221732 wheel 65 Apr 20 17:23 db.opt -rw-rw---- 1 hs221732 wheel 8554 Apr 20 17:24 t2.frm -rw-r----- 1 hs221732 wheel 98304 Apr 20 17:34 t2.ibd /export/home2/tmp/mysql-5.1-ihb/mysql-test/backup/2010-04-20_17-34-37/mtr: total 68 drwxr-xr-x 2 hs221732 wheel 4096 Apr 20 17:35 . drwxr-xr-x 7 hs221732 wheel 4096 Apr 20 17:47 .. -rw-r--r-- 1 hs221732 wheel 65 Apr 20 17:21 db.opt -rw-r--r-- 1 hs221732 wheel 8566 Apr 20 17:21 global_suppressions.frm -rw-r--r-- 1 hs221732 wheel 4440 Apr 20 17:21 global_suppressions.MYD -rw-r--r-- 1 hs221732 wheel 1024 Apr 20 17:21 global_suppressions.MYI -rw-r--r-- 1 hs221732 wheel 336 Apr 20 17:21 global_suppressions.TRG -rw-r--r-- 1 hs221732 wheel 51 Apr 20 17:21 gs_insert.TRN -rw-r--r-- 1 hs221732 wheel 8566 Apr 20 17:21 test_suppressions.frm -rw-r--r-- 1 hs221732 wheel 0 Apr 20 17:21 test_suppressions.MYD