7.7 Example: Making an Incremental Backup of InnoDB and MyISAM tables

In this example, we use the mysqlbackup command to make an incremental backup of a database that includes both InnoDB tables and MyISAM tables. We specify --lsn 2654255716 on the command line because the previous backup displayed this line near the end of the output:

ibbackup: Scanned log up to lsn 2654255716.

The test/ subdirectory within the backup directory includes several .frm files:

$ mysqlbackup --incremental --lsn 2654255716 /home/pekka/.my.cnf /incr-backup
mysqlbackup: Starting mysqlbackup with following arguments:
mysqlbackup --incremental --lsn 2654255716 /home/pekka/.my.cnf /incr-backup  
mysqlbackup: The unique backup id generated for the current backup operation is 12918212880165500 

mysqlbackup: IMPORTANT: Please check that backup run completes successfully.
            At the end of a successful 'backup' run mysqlbackup
            prints "mysqlbackup completed OK!".

mysqlbackup: Created backup directory '/incr-backup/2010-12-08_17-14-48'
mysqlbackup: Using ibbackup version 3.5.2 MySQL Enterprise Backup 3.5.2
mysqlbackup: Using MySQL client version: 5.1.47
mysqlbackup: Checking a connection to MySQL Server with parameters:
mysqlbackup: port=3308, socket=/home/pekka/mysql/MySQL.socket 
mysqlbackup: Using MySQL server version: 5.1.37

101208 17:14:48 mysqlbackup: Starting ibbackup binary with args:

./ibbackup --suspend-at-end --incremental 2654255716 /home/pekka/.my.cnf /incr-backup/2010-12-08_17-14-48/backup-my.cnf 
ibbackup version 3.5.2 MySQL Enterprise Backup 3.5.2
Copyright (c) 2002, 2010, Oracle and/or its affiliates.
Run 'ibbackup --help' for help and 'ibbackup --version' for version info.

Note: Uses posix_fadvise() for performance optimization.

Contents of /home/pekka/.my.cnf:
innodb_data_home_dir got value /sqldata/mts
innodb_data_file_path got value ibdata1:10M;ibdata2:20M;ibdata3:50M:autoextend
datadir got value /sqldata/mts
innodb_log_group_home_dir got value /sqldata/mts
innodb_log_files_in_group got value 3
innodb_log_file_size got value 10485760

Contents of /incr-backup/2010-12-08_17-14-48/backup-my.cnf:
innodb_data_home_dir got value /incr-backup/2010-12-08_17-14-48
innodb_data_file_path got value ibdata1:10M;ibdata2:20M;ibdata3:50M:autoextend
datadir got value /incr-backup/2010-12-08_17-14-48
innodb_log_group_home_dir got value /incr-backup/2010-12-08_17-14-48
innodb_log_files_in_group got value 3
innodb_log_file_size got value 10485760

ibbackup: System tablespace file format is Barracuda.
ibbackup: Found checkpoint at lsn 2666733462.
ibbackup: Starting log scan from lsn 2666733056.
101208 17:14:48  ibbackup: Copying log...
mysqlbackup: Waiting for ibbackup process to suspend
mysqlbackup: Suspend file '/incr-backup/2010-12-08_17-14-48/ibbackup_suspended'
101208 17:14:48  ibbackup: Log copied, lsn 2666733462.
ibbackup: We wait 1 second before starting copying the data files...
101208 17:14:49  ibbackup: Copying /sqldata/mts/ibdata1 (Barracuda file format).
101208 17:14:49  ibbackup: Copying /sqldata/mts/ibdata2 (Barracuda file format).
101208 17:14:50  ibbackup: Copying /sqldata/mts/ibdata3 (Barracuda file format).
101208 17:14:53  ibbackup: Copying /sqldata/mts/test/alex1.ibd (Antelope file format).
101208 17:14:54  ibbackup: Copying /sqldata/mts/test/alex2.ibd (Antelope file format).
101208 17:14:54  ibbackup: Copying /sqldata/mts/test/alex3.ibd (Antelope file format).
101208 17:14:54  ibbackup: Copying /sqldata/mts/test/blobt3.ibd (Antelope file format).
101208 17:14:55  ibbackup: Copying /sqldata/mts/test/ibstest0.ibd (Antelope file format).
101208 17:14:56  ibbackup: Copying /sqldata/mts/test/ibtest09.ibd (Antelope file format).

ibbackup: You specified the option --suspend-at-end.

101208 17:14:56 mysqlbackup: Continuing after ibbackup has suspended

101208 17:14:56 mysqlbackup: Starting to lock all the tables....

101208 17:14:56 mysqlbackup: All tables are locked and flushed to disk
mysqlbackup: Opening backup source directory '/sqldata/mts'

101208 17:14:56 mysqlbackup: Starting to backup all files in subdirectories of '/sqldata/mts'
mysqlbackup: Backing up the database directory 'mysql'
mysqlbackup: Backing up the database directory 'test'
mysqlbackup: Resuming ibbackup

101208 17:14:56  ibbackup: Suspending the backup procedure to wait
ibbackup: until you delete the marker file /incr-backup/2010-12-08_17-14-48/ibbackup_suspended.
101208 17:14:57  ibbackup: Suspension ends. Continuing the backup procedure.

101208 17:14:57  ibbackup: Copying of the last data file is close to ending...
ibbackup: We still once copy the latest flushed log to ibbackup_logfile.
101208 17:14:57  ibbackup: Copying /sqldata/mts/mysql/ibbackup_binlog_marker.ibd (Antelope file format).
ibbackup: A copied database page was modified at 2666733462.
ibbackup: Scanned log up to lsn 2666736714.
ibbackup: Was able to parse the log up to lsn 2666736714.
ibbackup: Maximum page number for a log record 51
ibbackup: Backup contains changes from lsn 2654255717 to lsn 2666736714
101208 17:14:57  ibbackup: Incremental backup completed!

101208 17:14:57 mysqlbackup: All tables unlocked
mysqlbackup: All MySQL tables were locked for 1.023 seconds
mysqlbackup: Backup created in directory '/incr-backup/2010-12-08_17-14-48'
mysqlbackup: start_lsn: 2654255717
mysqlbackup: incremental_base_lsn: 2666733462
mysqlbackup: end_lsn: 2666736714

101208 17:14:58 mysqlbackup: mysqlbackup completed OK!

The incremental backup directory also contains these .frm files:

$ ls -l /full-backup/2010-12-08_17-14-11/{.,test}
/full-backup/2010-12-08_17-14-11/.:
total 106540
-rw-r--r-- 1 pekka pekka      359 2010-12-08 17:14 backup-my.cnf
-rw-r--r-- 1 pekka pekka       18 2010-12-08 17:14 ibbackup_binlog_info
-rw-r--r-- 1 pekka pekka      155 2010-12-08 17:14 ibbackup_export_variables.txt
-rw-r----- 1 pekka pekka     4608 2010-12-08 17:14 ibbackup_logfile
-rw-r----- 1 pekka pekka 10485760 2010-12-08 17:14 ibdata1
-rw-r----- 1 pekka pekka 20971520 2010-12-08 17:14 ibdata2
-rw-r----- 1 pekka pekka 77594624 2010-12-08 17:14 ibdata3
drwx------ 2 pekka pekka     4096 2010-12-08 17:14 mysql
drwxr-x--- 2 pekka pekka     4096 2010-12-08 17:14 test

/full-backup/2010-12-08_17-14-11/test:
total 74216
-rw-r----- 1 pekka pekka     9076 2010-12-08 17:14 alex1.frm
-rw-r----- 1 pekka pekka 24117248 2010-12-08 17:14 alex1.ibd
-rw-r----- 1 pekka pekka     9076 2010-12-08 17:14 alex2.frm
-rw-r----- 1 pekka pekka   245760 2010-12-08 17:14 alex2.ibd
-rw-r----- 1 pekka pekka     9076 2010-12-08 17:14 alex3.frm
-rw-r----- 1 pekka pekka   245760 2010-12-08 17:14 alex3.ibd
-rw-r----- 1 pekka pekka     8626 2010-12-08 17:14 blobt3.frm
-rw-r----- 1 pekka pekka 24117248 2010-12-08 17:14 blobt3.ibd
-rw-r----- 1 pekka pekka     8626 2010-12-08 17:14 ibstest0.frm
-rw-r----- 1 pekka pekka 26214400 2010-12-08 17:14 ibstest0.ibd
-rw-r----- 1 pekka pekka     8722 2010-12-08 17:14 ibtest09.frm
-rw-r----- 1 pekka pekka   933888 2010-12-08 17:14 ibtest09.ibd
-rw-r----- 1 pekka pekka     8626 2010-12-08 17:14 ibtest11a.frm
-rw-r----- 1 pekka pekka     8626 2010-12-08 17:14 ibtest11b.frm
-rw-r----- 1 pekka pekka     8626 2010-12-08 17:14 ibtest11c.frm
-rw-r----- 1 pekka pekka     8626 2010-12-08 17:14 ibtest11d.frm

Once again, we apply to the full backup any changes that occurred while the backup was running:

$ mysqlbackup --apply-log /home/pekka/.my.cnf /full-backup/2010-12-08_17-14-11
mysqlbackup: Starting mysqlbackup with following arguments:
mysqlbackup --apply-log /home/pekka/.my.cnf /full-backup/2010-12-08_17-14-11  
mysqlbackup: IMPORTANT: Please check that apply-log run completes successfully.
            At the end of a successful 'apply-log' run mysqlbackup
            prints "mysqlbackup completed OK!".

mysqlbackup: Using ibbackup version 3.5.2 MySQL Enterprise Backup 3.5.2
mysqlbackup: Starting ibbackup binary with args:

./ibbackup --apply-log /full-backup/2010-12-08_17-14-11/backup-my.cnf 
ibbackup version 3.5.2 MySQL Enterprise Backup 3.5.2
Copyright (c) 2002, 2010, Oracle and/or its affiliates.
Run 'ibbackup --help' for help and 'ibbackup --version' for version info.

Note: Uses posix_fadvise() for performance optimization.

Contents of /full-backup/2010-12-08_17-14-11/backup-my.cnf:
innodb_data_home_dir got value /full-backup/2010-12-08_17-14-11
innodb_data_file_path got value ibdata1:10M;ibdata2:20M;ibdata3:50M:autoextend
datadir got value /full-backup/2010-12-08_17-14-11
innodb_log_group_home_dir got value /full-backup/2010-12-08_17-14-11
innodb_log_files_in_group got value 3
innodb_log_file_size got value 10485760

101208 17:15:08  ibbackup: ibbackup_logfile's creation parameters:
ibbackup: start lsn 2654252032, end lsn 2654255716,
ibbackup: start checkpoint 2654252464.
InnoDB: Doing recovery: scanned up to log sequence number 2654255716
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 10485760
Setting log file size to 0 10485760
Setting log file size to 0 10485760
ibbackup: We were able to parse ibbackup_logfile up to
ibbackup: lsn 2654255716.
ibbackup: Last MySQL binlog file position 0 538, file name ./MySQL-bin.000046
ibbackup: The first data file is '/full-backup/2010-12-08_17-14-11/ibdata1'
ibbackup: and the new created log files are at '/full-backup/2010-12-08_17-14-11/'
ibbackup: System tablespace file format is Barracuda.
101208 17:15:10  ibbackup: Full backup prepared for recovery successfully!

101208 17:15:10 mysqlbackup: mysqlbackup completed OK!

Then, we apply the changes from the incremental backup:

$ mysqlbackup --apply-log --incremental /incr-backup/2010-12-08_17-14-48/backup-my.cnf /full-backup/2010-12-08_17-14-11/backup-my.cnf
mysqlbackup: Starting mysqlbackup with following arguments:
mysqlbackup --apply-log --incremental /incr-backup/2010-12-08_17-14-48/backup-my.cnf /full-backup/2010-12-08_17-14-11/backup-my.cnf  
mysqlbackup: IMPORTANT: Please check that apply-log run completes successfully.
            At the end of a successful 'apply-log' run mysqlbackup
            prints "mysqlbackup completed OK!".

mysqlbackup: Using ibbackup version 3.5.2 MySQL Enterprise Backup 3.5.2

101208 17:15:10 mysqlbackup: Copying all non-InnoDB files in subdirectories of 
mysqlbackup: '/incr-backup/2010-12-08_17-14-48'
mysqlbackup: to the corresponding subdirectories in
mysqlbackup: '/full-backup/2010-12-08_17-14-11'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/backup_history.CSM'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/backup_history.CSV'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/backup_history.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/backup_progress.CSM'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/backup_progress.CSV'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/backup_progress.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/columns_priv.MYD'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/columns_priv.MYI'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/columns_priv.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/db.MYD'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/db.MYI'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/db.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/event.MYD'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/event.MYI'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/event.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/func.MYD'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/func.MYI'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/func.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/general_log.CSM'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/general_log.CSV'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/general_log.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/help_category.MYD'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/help_category.MYI'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/help_category.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/help_keyword.MYD'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/help_keyword.MYI'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/help_keyword.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/help_relation.MYD'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/help_relation.MYI'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/help_relation.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/help_topic.MYD'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/help_topic.MYI'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/help_topic.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/host.MYD'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/host.MYI'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/host.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/ibbackup_binlog_marker.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/ndb_binlog_index.MYD'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/ndb_binlog_index.MYI'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/ndb_binlog_index.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/plugin.MYD'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/plugin.MYI'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/plugin.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/proc.MYD'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/proc.MYI'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/proc.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/procs_priv.MYD'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/procs_priv.MYI'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/procs_priv.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/servers.MYD'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/servers.MYI'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/servers.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/slow_log.CSM'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/slow_log.CSV'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/slow_log.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/tables_priv.MYD'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/tables_priv.MYI'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/tables_priv.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/time_zone.MYD'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/time_zone.MYI'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/time_zone.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/time_zone_leap_second.MYD'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/time_zone_leap_second.MYI'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/time_zone_leap_second.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/time_zone_name.MYD'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/time_zone_name.MYI'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/time_zone_name.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/time_zone_transition.MYD'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/time_zone_transition.MYI'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/time_zone_transition.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/time_zone_transition_type.MYD'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/time_zone_transition_type.MYI'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/time_zone_transition_type.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/user.MYD'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/user.MYI'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/mysql/user.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/test/alex1.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/test/alex2.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/test/alex3.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/test/blobt3.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/test/ibstest0.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/test/ibtest09.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/test/ibtest11a.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/test/ibtest11b.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/test/ibtest11c.frm'
mysqlbackup: Copying file '/incr-backup/2010-12-08_17-14-48/test/ibtest11d.frm'
mysqlbackup: Checking for deleted databases and non-InnoDB files in them

101208 17:15:10 mysqlbackup: Finished copying all non-InnoDB files from the 
mysqlbackup: incremental backup to the full backup.

mysqlbackup: Starting ibbackup binary with args:

./ibbackup --apply-log --incremental /incr-backup/2010-12-08_17-14-48/backup-my.cnf /full-backup/2010-12-08_17-14-11/backup-my.cnf 
ibbackup version 3.5.2 MySQL Enterprise Backup 3.5.2
Copyright (c) 2002, 2010, Oracle and/or its affiliates.
Run 'ibbackup --help' for help and 'ibbackup --version' for version info.

Note: Uses posix_fadvise() for performance optimization.

Contents of /incr-backup/2010-12-08_17-14-48/backup-my.cnf:
innodb_data_home_dir got value /incr-backup/2010-12-08_17-14-48
innodb_data_file_path got value ibdata1:10M;ibdata2:20M;ibdata3:50M:autoextend
datadir got value /incr-backup/2010-12-08_17-14-48
innodb_log_group_home_dir got value /incr-backup/2010-12-08_17-14-48
innodb_log_files_in_group got value 3
innodb_log_file_size got value 10485760

Contents of /full-backup/2010-12-08_17-14-11/backup-my.cnf:
innodb_data_home_dir got value /full-backup/2010-12-08_17-14-11
innodb_data_file_path got value ibdata1:10M;ibdata2:20M;ibdata3:50M:autoextend
datadir got value /full-backup/2010-12-08_17-14-11
innodb_log_group_home_dir got value /full-backup/2010-12-08_17-14-11
innodb_log_files_in_group got value 3
innodb_log_file_size got value 10485760

101208 17:15:10  ibbackup: ibbackup_logfile's creation parameters:
ibbackup: start lsn 2666733056, end lsn 2666736714,
ibbackup: start checkpoint 2666733462.
InnoDB: Doing recovery: scanned up to log sequence number 2666736714
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 10485760
Setting log file size to 0 10485760
Setting log file size to 0 10485760
ibbackup: We were able to parse ibbackup_logfile up to
ibbackup: lsn 2666736714.
ibbackup: Last MySQL binlog file position 0 538, file name ./MySQL-bin.000046
ibbackup: The first data file is '/full-backup/2010-12-08_17-14-11/ibdata1'
ibbackup: and the new created log files are at '/full-backup/2010-12-08_17-14-11/'
ibbackup: System tablespace file format is Barracuda.
101208 17:15:12  ibbackup: Incremental backup applied successfully!
mysqlbackup: Copying file 'ibbackup_export_variables.txt'
mysqlbackup: Copying file 'ibbackup_binlog_info'

101208 17:15:12 mysqlbackup: mysqlbackup completed OK!

Now, the data files in the full backup directory are fully up-to-date, as of the time of the last incremental backup:

$ ls -l /full-backup/2010-12-08_17-14-11/{.,test}
/full-backup/2010-12-08_17-14-11/.:
total 137260
-rw-r--r-- 1 pekka pekka      359 2010-12-08 17:14 backup-my.cnf
-rw-r--r-- 1 pekka pekka       18 2010-12-08 17:15 ibbackup_binlog_info
-rw-r--r-- 1 pekka pekka      155 2010-12-08 17:15 ibbackup_export_variables.txt
-rw-r----- 1 pekka pekka     4608 2010-12-08 17:15 ibbackup_logfile
-rw-r----- 1 pekka pekka 10485760 2010-12-08 17:15 ibdata1
-rw-r----- 1 pekka pekka 20971520 2010-12-08 17:15 ibdata2
-rw-r----- 1 pekka pekka 77594624 2010-12-08 17:14 ibdata3
-rw-r----- 1 pekka pekka 10485760 2010-12-08 17:15 ib_logfile0
-rw-r----- 1 pekka pekka 10485760 2010-12-08 17:15 ib_logfile1
-rw-r----- 1 pekka pekka 10485760 2010-12-08 17:15 ib_logfile2
drwx------ 2 pekka pekka     4096 2010-12-08 17:14 mysql
drwxr-x--- 2 pekka pekka     4096 2010-12-08 17:14 test

/full-backup/2010-12-08_17-14-11/test:
total 74216
-rw-r----- 1 pekka pekka     9076 2010-12-08 17:15 alex1.frm
-rw-r----- 1 pekka pekka 24117248 2010-12-08 17:14 alex1.ibd
-rw-r----- 1 pekka pekka     9076 2010-12-08 17:15 alex2.frm
-rw-r----- 1 pekka pekka   245760 2010-12-08 17:14 alex2.ibd
-rw-r----- 1 pekka pekka     9076 2010-12-08 17:15 alex3.frm
-rw-r----- 1 pekka pekka   245760 2010-12-08 17:14 alex3.ibd
-rw-r----- 1 pekka pekka     8626 2010-12-08 17:15 blobt3.frm
-rw-r----- 1 pekka pekka 24117248 2010-12-08 17:15 blobt3.ibd
-rw-r----- 1 pekka pekka     8626 2010-12-08 17:15 ibstest0.frm
-rw-r----- 1 pekka pekka 26214400 2010-12-08 17:14 ibstest0.ibd
-rw-r----- 1 pekka pekka     8722 2010-12-08 17:15 ibtest09.frm
-rw-r----- 1 pekka pekka   933888 2010-12-08 17:14 ibtest09.ibd
-rw-r----- 1 pekka pekka     8626 2010-12-08 17:15 ibtest11a.frm
-rw-r----- 1 pekka pekka     8626 2010-12-08 17:15 ibtest11b.frm
-rw-r----- 1 pekka pekka     8626 2010-12-08 17:15 ibtest11c.frm
-rw-r----- 1 pekka pekka     8626 2010-12-08 17:15 ibtest11d.frm