[hs221732@fimafeng10]/export/home2/tmp/mysql-5.1-ihb: perl innobackup hema-inno.cnf mysql-test/backup/ --socket=/export/home2/tmp/mysql-5.1-ihb/mysql-test/var/tmp/mysqld.1.sock --user=root --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 backup run completes successfully. At the end of a successful backup run innobackup prints "innobackup completed OK!". innobackup: Using mysql Ver 14.12 Distrib 5.0.22, for redhat-linux-gnu (x86_64) using readline 5.0 innobackup: Using mysql server version 5.1.46-debug-log innobackup: Using InnoDB Hot Backup 3.5-beta7 innobackup: Created backup directory mysql-test/backup//2010-04-20_17-34-37 100420 17:34:37 innobackup: Starting mysql with options: --unbuffered --user=root --socket=/export/home2/tmp/mysql-5.1-ihb/mysql-test/var/tmp/mysqld.1.sock 100420 17:34:37 innobackup: Connected to database with mysql child process (pid=12021) 100420 17:34:41 innobackup: Connection to database server closed 100420 17:34:41 innobackup: Starting ibbackup with command: /export/home2/tmp/mysql-5.1-ihb/ibbackup --suspend-at-end hema-inno.cnf mysql-test/backup//2010-04-20_17-34-37/backup-my.cnf innobackup: Waiting for ibbackup (pid=12028) to suspend innobackup: Suspend file 'mysql-test/backup//2010-04-20_17-34-37/ibbackup_suspended' 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 hema-inno.cnf: innodb_data_home_dir got value /export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data innodb_data_file_path got value ibdata1:10M:autoextend datadir got value /export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data innodb_log_group_home_dir got value /export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data innodb_log_files_in_group got value 2 innodb_log_file_size got value 5242880 Contents of 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 ibbackup: System tablespace file format is Antelope. ibbackup: Found checkpoint at lsn 50462. ibbackup: Starting log scan from lsn 50176. 100420 17:34:41 ibbackup: Copying log... 100420 17:34:41 ibbackup: Log copied, lsn 50462. ibbackup: We wait 1 second before starting copying the data files... 100420 17:34:42 ibbackup: Copying /export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data/ibdata1 (Antelope file format). 100420 17:34:42 ibbackup: Copying /export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data/db1/t1.ibd (Antelope file format). 100420 17:34:42 ibbackup: Copying /export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data/db2/t2.ibd (Antelope file format). ibbackup: You specified the option --suspend-at-end. 100420 17:34:42 ibbackup: Suspending the backup procedure to wait ibbackup: until you delete the marker file mysql-test/backup//2010-04-20_17-34-37/ibbackup_suspended. 100420 17:34:43 innobackup: Continuing after ibbackup has suspended 100420 17:34:43 innobackup: Starting mysql with options: --unbuffered --user=root --socket=/export/home2/tmp/mysql-5.1-ihb/mysql-test/var/tmp/mysqld.1.sock 100420 17:34:43 innobackup: Connected to database with mysql child process (pid=12029) 100420 17:34:47 innobackup: Starting to lock all tables... 100420 17:35:03 innobackup: All tables locked and flushed to disk 100420 17:35:03 innobackup: Starting to backup all files in innobackup: subdirectories of '/export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data' innobackup: Backing up file '/export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data/db1/db.opt' innobackup: Backing up file '/export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data/db1/t1.frm' innobackup: Backing up file '/export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data/db2/db.opt' innobackup: Backing up file '/export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data/db2/t2.frm' innobackup: Backing up files '/export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data/mysql/*' (70 files) innobackup: Backing up files '/export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data/mtr/*' (11 files) 100420 17:35:03 innobackup: Finished backing up all files in database subdirectories innobackup: Resuming ibbackup 100420 17:35:03 ibbackup: Suspension ends. Continuing the backup procedure. 100420 17:35:03 ibbackup: Copying of the last data file is close to ending... ibbackup: We still once copy the latest flushed log to ibbackup_logfile. 100420 17:35:03 ibbackup: Copying /export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data/mysql/ibbackup_binlog_marker.ibd (Antelope file format). ibbackup: A copied database page was modified at 53480. ibbackup: Scanned log up to lsn 53486. ibbackup: Was able to parse the log up to lsn 53486. ibbackup: Maximum page number for a log record 45 100420 17:35:04 ibbackup: Full backup completed! 100420 17:35:08 innobackup: All tables unlocked 100420 17:35:08 innobackup: Connection to database server closed innobackup: Backup created in directory 'mysql-test/backup//2010-04-20_17-34-37' innobackup: MySQL binlog position: filename '', position 100420 17:35:08 innobackup: innobackup completed OK! ========================================================================================= The datadir contents ls -laR `pwd` /export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data: total 20548 drwxr-xr-x 7 hs221732 wheel 4096 Apr 20 17:23 . drwxr-xr-x 3 hs221732 wheel 4096 Apr 20 17:21 .. drwxrwx--- 2 hs221732 wheel 4096 Apr 20 17:24 db1 drwxrwx--- 2 hs221732 wheel 4096 Apr 20 17:24 db2 -rw-rw---- 1 hs221732 wheel 10485760 Apr 20 17:35 ibdata1 -rw-rw---- 1 hs221732 wheel 5242880 Apr 20 17:35 ib_logfile0 -rw-rw---- 1 hs221732 wheel 5242880 Apr 20 17:21 ib_logfile1 drwxr-xr-x 2 hs221732 wheel 4096 Apr 20 17:21 mtr drwxr-xr-x 2 hs221732 wheel 4096 Apr 20 17:35 mysql drwxr-xr-x 2 hs221732 wheel 4096 Apr 20 17:21 test /export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data/db1: total 124 drwxrwx--- 2 hs221732 wheel 4096 Apr 20 17:24 . drwxr-xr-x 7 hs221732 wheel 4096 Apr 20 17:23 .. -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-rw---- 1 hs221732 wheel 98304 Apr 20 17:24 t1.ibd /export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data/db2: total 124 drwxrwx--- 2 hs221732 wheel 4096 Apr 20 17:24 . drwxr-xr-x 7 hs221732 wheel 4096 Apr 20 17:23 .. -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-rw---- 1 hs221732 wheel 98304 Apr 20 17:25 t2.ibd /export/home2/tmp/mysql-5.1-ihb/mysql-test/var/mysqld.1/data/mtr: total 68 drwxr-xr-x 2 hs221732 wheel 4096 Apr 20 17:21 . drwxr-xr-x 7 hs221732 wheel 4096 Apr 20 17:23 .. -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 -rw-r--r-- 1 hs221732 wheel 1024 Apr 20 17:21 test_suppressions.MYI -rw-r--r-- 1 hs221732 wheel 334 Apr 20 17:21 test_suppressions.TRG -rw-r--r-- 1 hs221732 wheel 49 Apr 20 17:21 ts_insert.TRN ... ... ...