Author: jrussell
Date: 2010-10-18 07:41:36 +0200 (Mon, 18 Oct 2010)
New Revision: 23175
Log:
Found the place for the -5.6 examples, although the 'd'
one doesn't seem to have a corresponding spot in the manual.
Modified:
trunk/mysql-enterprise-backup-3.5/manual.xml
Modified: trunk/mysql-enterprise-backup-3.5/manual.xml
===================================================================
--- trunk/mysql-enterprise-backup-3.5/manual.xml 2010-10-18 05:32:22 UTC (rev 23174)
+++ trunk/mysql-enterprise-backup-3.5/manual.xml 2010-10-18 05:41:36 UTC (rev 23175)
Changed blocks: 8, Lines Added: 241, Lines Deleted: 162; 25997 bytes
@@ -1665,12 +1665,12 @@
<listitem>
<para>
Use the <literal>CHANGE MASTER</literal> SQL command on the
- slave to init it right. For example:
+ slave to initialize it properly. For example:
</para>
<programlisting>
CHANGE MASTER TO
-MASTER_LOG_FILE='hundin-bin.006',
+MASTER_LOG_FILE='hundin-bin.006',
MASTER_LOG_POS=128760128;
</programlisting>
</listitem>
@@ -2681,7 +2681,7 @@
<section remap="h2" id="mysqlbackup.privileges">
- <title>Example: Setting MySQL Privileges for Innobackup</title>
+ <title>Example: Setting MySQL Privileges for &hlbackup;</title>
<para>
When <literal>&hlbackup;</literal> creates a backup, it sends
@@ -2705,21 +2705,23 @@
<literal>dba</literal> connecting from localhost as follows:
</para>
+<!-- JDR: 4.1.1? This would be a good example for Pekka to include in the example suite. -->
+
<programlisting>
$ mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 19 to server version: 4.1.1-alpha-debug-log
-Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
+Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
-mysql> GRANT RELOAD ON *.* TO 'dba'@'localhost';
+mysql> GRANT RELOAD ON *.* TO 'dba'@'localhost';
Query OK, 0 rows affected (0.10 sec)
-mysql> GRANT CREATE, INSERT, DROP ON mysql.ibbackup_binlog_marker
- -> TO 'dba'@'localhost';
+mysql> GRANT CREATE, INSERT, DROP ON mysql.ibbackup_binlog_marker
+ -> TO 'dba'@'localhost';
Query OK, 0 rows affected (0.06 sec)
-mysql> FLUSH PRIVILEGES;
+mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.15 sec)
</programlisting>
@@ -2738,8 +2740,8 @@
output:
</para>
-<programlisting>
-ibbackup: Was able to parse the log up to lsn 2261747124
+<programlisting id="example-5.6a">
+ibbackup: Scanned log up to lsn 2626689439.
</programlisting>
<screen/>
@@ -2749,39 +2751,100 @@
directory includes several <literal>.frm</literal> files:
</para>
-<programlisting>
-$ ls -lh /full-backup/2009-12-14_18-58-36/{.,test}
-/full-backup/2009-12-14_18-58-36/.:
-total 105M
--rw-r--r-- 1 pekka pekka 360 2009-12-14 18:58 backup-my.cnf
--rw-r--r-- 1 pekka pekka 1 2009-12-14 18:59 ibbackup_binlog_info
--rw-r----- 1 pekka pekka 4.0K 2009-12-14 18:59 ibbackup_logfile
--rw-r----- 1 pekka pekka 10M 2009-12-14 18:58 ibdata1
--rw-r----- 1 pekka pekka 20M 2009-12-14 18:58 ibdata2
--rw-r----- 1 pekka pekka 74M 2009-12-14 18:58 ibdata3
-drwxr-xr-x 2 pekka pekka 4.0K 2009-12-14 18:59 mysql
--rw-r--r-- 1 pekka pekka 0 2009-12-14 18:58 mysql-stderr
--rw-r--r-- 1 pekka pekka 466 2009-12-14 18:59 mysql-stdout
-drwxr-x--- 2 pekka pekka 4.0K 2009-12-14 18:59 test
+<programlisting id="example-5.6b">
+$ mysqlbackup --incremental --lsn 2626689439 /home/pekka/.my.cnf /incr-backup
+mysqlbackup: Starting mysqlbackup with following arguments:
+mysqlbackup --incremental --lsn 2626689439 /home/pekka/.my.cnf /incr-backup
-/full-backup/2009-12-14_18-58-36/test:
-total 73M
--rw-rw---- 1 pekka pekka 8.9K 2009-10-27 18:53 alex1.frm
--rw-r----- 1 pekka pekka 23M 2009-12-14 18:58 alex1.ibd
--rw-rw---- 1 pekka pekka 8.9K 2009-09-15 15:53 alex2.frm
--rw-r----- 1 pekka pekka 240K 2009-12-14 18:58 alex2.ibd
--rw-rw---- 1 pekka pekka 8.9K 2009-10-27 18:54 alex3.frm
--rw-r----- 1 pekka pekka 240K 2009-12-14 18:58 alex3.ibd
--rw-rw---- 1 pekka pekka 8.5K 2009-12-14 18:58 blobt3.frm
--rw-r----- 1 pekka pekka 23M 2009-12-14 18:58 blobt3.ibd
--rw-rw---- 1 pekka pekka 8.5K 2009-09-15 15:53 ibstest0.frm
--rw-r----- 1 pekka pekka 25M 2009-12-14 18:58 ibstest0.ibd
--rw-rw---- 1 pekka pekka 8.6K 2009-10-27 18:55 ibtest09.frm
--rw-r----- 1 pekka pekka 912K 2009-12-14 18:58 ibtest09.ibd
--rw-rw---- 1 pekka pekka 8.5K 2009-10-27 19:05 ibtest11a.frm
--rw-rw---- 1 pekka pekka 8.5K 2009-10-27 19:05 ibtest11b.frm
--rw-rw---- 1 pekka pekka 8.5K 2009-10-27 19:05 ibtest11c.frm
--rw-rw---- 1 pekka pekka 8.5K 2009-10-27 19:05 ibtest11d.frm
+mysqlbackup: Unique backup id generated for the current backup operation is 12861866717610270
+
+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-10-04_13-04-31'
+mysqlbackup: Using ibbackup version 3.5.2 MySQL Enterprise Backup 3.5.2
+mysqlbackup: Using MySQL client version: 5.1.47
+mysqlbackup: Using MySQL server version: 5.1.37
+
+101004 13:04:31 mysqlbackup: Starting ibbackup binary with args:
+
+./ibbackup --suspend-at-end --incremental 2626689439 /home/pekka/.my.cnf /incr-backup/2010-10-04_13-04-31/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: Using 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-10-04_13-04-31/backup-my.cnf:
+innodb_data_home_dir got value /incr-backup/2010-10-04_13-04-31
+innodb_data_file_path got value ibdata1:10M;ibdata2:20M;ibdata3:50M:autoextend
+datadir got value /incr-backup/2010-10-04_13-04-31
+innodb_log_group_home_dir got value /incr-backup/2010-10-04_13-04-31
+innodb_log_files_in_group got value 3
+innodb_log_file_size got value 10485760
+mysqlbackup: Waiting for ibbackup process to suspend
+mysqlbackup: Suspend file '/incr-backup/2010-10-04_13-04-31/ibbackup_suspended'
+
+ibbackup: System tablespace file format is Barracuda.
+ibbackup: Found checkpoint at lsn 2638544206.
+ibbackup: Starting log scan from lsn 2638543872.
+101004 13:04:31 ibbackup: Copying log...
+101004 13:04:32 ibbackup: Log copied, lsn 2638544206.
+ibbackup: We wait 1 second before starting copying the data files...
+101004 13:04:33 ibbackup: Copying /sqldata/mts/ibdata1 (Barracuda file format).
+101004 13:04:34 ibbackup: Copying /sqldata/mts/ibdata2 (Barracuda file format).
+101004 13:04:35 ibbackup: Copying /sqldata/mts/ibdata3 (Barracuda file format).
+101004 13:04:38 ibbackup: Copying /sqldata/mts/test/alex1.ibd (Antelope file format).
+101004 13:04:39 ibbackup: Copying /sqldata/mts/test/alex2.ibd (Antelope file format).
+101004 13:04:39 ibbackup: Copying /sqldata/mts/test/alex3.ibd (Antelope file format).
+101004 13:04:40 ibbackup: Copying /sqldata/mts/test/blobt3.ibd (Antelope file format).
+101004 13:04:41 ibbackup: Copying /sqldata/mts/test/ibstest0.ibd (Antelope file format).
+101004 13:04:43 ibbackup: Copying /sqldata/mts/test/ibtest09.ibd (Antelope file format).
+
+ibbackup: You specified the option --suspend-at-end.
+
+101004 13:04:43 mysqlbackup: Continuing after ibbackup has suspended
+
+101004 13:04:43 mysqlbackup: Starting to lock all the tables....
+
+101004 13:04:43 mysqlbackup: All tables are locked and flushed to disk
+mysqlbackup: Opening backup source directory '/sqldata/mts'
+
+101004 13:04:43 mysqlbackup: Starting to backup all files in subdirectories of '/sqldata/mts'
+mysqlbackup: Backing up the database directory 'mysql'
+101004 13:04:43 ibbackup: Suspending the backup procedure to wait
+ibbackup: until you delete the marker file /incr-backup/2010-10-04_13-04-31/ibbackup_suspended.
+mysqlbackup: Backing up the database directory 'test'
+
+101004 13:04:44 mysqlbackup: All tables unlocked
+mysqlbackup: All tables were locked for 1.194 seconds
+mysqlbackup: Resuming ibbackup
+101004 13:04:45 ibbackup: Suspension ends. Continuing the backup procedure.
+
+101004 13:04:45 ibbackup: Copying of the last data file is close to ending...
+ibbackup: We still once copy the latest flushed log to ibbackup_logfile.
+ibbackup: A copied database page was modified at 2638544206.
+ibbackup: Scanned log up to lsn 2638548195.
+ibbackup: Was able to parse the log up to lsn 2638548195.
+ibbackup: Maximum page number for a log record 1208
+ibbackup: Backup contains changes from lsn 2626689440 to lsn 2638548195
+101004 13:04:45 ibbackup: Incremental backup completed!
+mysqlbackup: Backup created in directory '/incr-backup/2010-10-04_13-04-31'
+mysqlbackup: start_lsn: 2626689440
+mysqlbackup: incremental_base_lsn: 2638544206
+mysqlbackup: end_lsn: 2638548195
+
+101004 13:04:46 mysqlbackup: mysqlbackup completed OK!
+
</programlisting>
<para>
@@ -2789,34 +2852,38 @@
<literal>.frm</literal> files:
</para>
-<programlisting>
-$ ls -lh /incr-backup/2009-12-14_18-59-45/{.,test}
-/incr-backup/2009-12-14_18-59-45/.:
-total 2.7M
--rw-r--r-- 1 pekka pekka 360 2009-12-14 18:59 backup-my.cnf
--rw-r--r-- 1 pekka pekka 1 2009-12-14 19:00 ibbackup_binlog_info
--rw-r--r-- 1 pekka pekka 130 2009-12-14 19:00 ibbackup_ibd_files
--rw-r----- 1 pekka pekka 4.5K 2009-12-14 19:00 ibbackup_logfile
--rw-r----- 1 pekka pekka 2.2M 2009-12-14 18:59 ibdata1
--rw-r----- 1 pekka pekka 401K 2009-12-14 18:59 ibdata2
-drwxr-xr-x 2 pekka pekka 4.0K 2009-12-14 19:00 mysql
--rw-r--r-- 1 pekka pekka 0 2009-12-14 18:59 mysql-stderr
--rw-r--r-- 1 pekka pekka 466 2009-12-14 19:00 mysql-stdout
-drwxr-x--- 2 pekka pekka 4.0K 2009-12-14 19:00 test
+<programlisting id="example-5.6c">
+$ ls -lh /full-backup/2010-10-04_13-03-45/{.,test}
+/full-backup/2010-10-04_13-03-45/.:
+total 105M
+-rw-r--r-- 1 pekka pekka 359 2010-10-04 13:03 backup-my.cnf
+-rw-r--r-- 1 pekka pekka 18 2010-10-04 13:04 ibbackup_binlog_info
+-rw-r--r-- 1 pekka pekka 155 2010-10-04 13:04 ibbackup_export_variables.txt
+-rw-r----- 1 pekka pekka 4.5K 2010-10-04 13:04 ibbackup_logfile
+-rw-r----- 1 pekka pekka 10M 2010-10-04 13:03 ibdata1
+-rw-r----- 1 pekka pekka 20M 2010-10-04 13:03 ibdata2
+-rw-r----- 1 pekka pekka 74M 2010-10-04 13:03 ibdata3
+drwx------ 2 pekka pekka 4.0K 2010-10-04 13:04 mysql
+drwxr-x--- 2 pekka pekka 4.0K 2010-10-04 13:04 test
-/incr-backup/2009-12-14_18-59-45/test:
-total 16M
--rw-rw---- 1 pekka pekka 8.9K 2009-10-27 18:53 alex1.frm
--rw-rw---- 1 pekka pekka 8.9K 2009-09-15 15:53 alex2.frm
--rw-rw---- 1 pekka pekka 8.9K 2009-10-27 18:54 alex3.frm
--rw-rw---- 1 pekka pekka 8.5K 2009-12-14 18:59 blobt3.frm
--rw-r----- 1 pekka pekka 16M 2009-12-14 18:59 blobt3.ibd
--rw-rw---- 1 pekka pekka 8.5K 2009-09-15 15:53 ibstest0.frm
--rw-rw---- 1 pekka pekka 8.6K 2009-10-27 18:55 ibtest09.frm
--rw-rw---- 1 pekka pekka 8.5K 2009-10-27 19:05 ibtest11a.frm
--rw-rw---- 1 pekka pekka 8.5K 2009-10-27 19:05 ibtest11b.frm
--rw-rw---- 1 pekka pekka 8.5K 2009-10-27 19:05 ibtest11c.frm
--rw-rw---- 1 pekka pekka 8.5K 2009-10-27 19:05 ibtest11d.frm
+/full-backup/2010-10-04_13-03-45/test:
+total 71M
+-rw-r----- 1 pekka pekka 8.9K 2010-10-04 13:04 alex1.frm
+-rw-r----- 1 pekka pekka 23M 2010-10-04 13:04 alex1.ibd
+-rw-r----- 1 pekka pekka 8.9K 2010-10-04 13:04 alex2.frm
+-rw-r----- 1 pekka pekka 240K 2010-10-04 13:04 alex2.ibd
+-rw-r----- 1 pekka pekka 8.9K 2010-10-04 13:04 alex3.frm
+-rw-r----- 1 pekka pekka 240K 2010-10-04 13:04 alex3.ibd
+-rw-r----- 1 pekka pekka 8.5K 2010-10-04 13:04 blobt3.frm
+-rw-r----- 1 pekka pekka 21M 2010-10-04 13:04 blobt3.ibd
+-rw-r----- 1 pekka pekka 8.5K 2010-10-04 13:04 ibstest0.frm
+-rw-r----- 1 pekka pekka 25M 2010-10-04 13:04 ibstest0.ibd
+-rw-r----- 1 pekka pekka 8.6K 2010-10-04 13:04 ibtest09.frm
+-rw-r----- 1 pekka pekka 912K 2010-10-04 13:04 ibtest09.ibd
+-rw-r----- 1 pekka pekka 8.5K 2010-10-04 13:04 ibtest11a.frm
+-rw-r----- 1 pekka pekka 8.5K 2010-10-04 13:04 ibtest11b.frm
+-rw-r----- 1 pekka pekka 8.5K 2010-10-04 13:04 ibtest11c.frm
+-rw-r----- 1 pekka pekka 8.5K 2010-10-04 13:04 ibtest11d.frm
</programlisting>
<para>
@@ -2824,112 +2891,125 @@
occurred while the backup was running:
</para>
-<programlisting>
-$ mysqlbackup --apply-log /home/pekka/.my.cnf /full-backup/2009-12-14_18-58-36
+<!-- JDR: -5.6d doesn't seem to fit in anywhere. -->
-InnoDB Backup Utility v1.7.2
-Copyright (c) 2003, 2010, Oracle and/or its affiliates. All Rights Reserved.
+<programlisting id="example-5.6e">
+$ mysqlbackup --apply-log /home/pekka/.my.cnf /full-backup/2010-10-04_13-03-45
+mysqlbackup: Starting mysqlbackup with following arguments:
+mysqlbackup --apply-log /home/pekka/.my.cnf /full-backup/2010-10-04_13-03-45
-This software is published under
-the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
+mysqlbackup: IMPORTANT: Please check that apply-log run completes successfully.
+ At the end of a successful 'apply-log' run mysqlbackup
+ prints "mysqlbackup completed OK!".
-IMPORTANT: Please check that the apply-log run completes successfully.
- At the end of a successful apply-log run innobackup
- prints "innobackup completed OK!".
+mysqlbackup: Using ibbackup version 3.5.2 MySQL Enterprise Backup 3.5.2
+mysqlbackup: Starting ibbackup binary with args:
-innobackup: Using MySQL Enterprise Backup 3.5-beta5
+./ibbackup --apply-log /full-backup/2010-10-04_13-03-45/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: Using posix_fadvise() for performance optimization.
-091214 19:00:27 innobackup: Starting ibbackup with command: ibbackup --restore /full-backup/2009-12-14_18-58-36/backup-my.cnf
-
-ibbackup version 3.5.1 MySQL Enterprise Backup 3.5.1
-Copyright (c) 2002, 2010, Oracle and/or its affiliates.
-Run ibbackup --license for detailed license terms, --help for help
-
-Contents of /full-backup/2009-12-14_18-58-36/backup-my.cnf:
-innodb_data_home_dir got value /full-backup/2009-12-14_18-58-36
+Contents of /full-backup/2010-10-04_13-03-45/backup-my.cnf:
+innodb_data_home_dir got value /full-backup/2010-10-04_13-03-45
innodb_data_file_path got value ibdata1:10M;ibdata2:20M;ibdata3:50M:autoextend
-datadir got value /full-backup/2009-12-14_18-58-36
-innodb_log_group_home_dir got value /full-backup/2009-12-14_18-58-36
+datadir got value /full-backup/2010-10-04_13-03-45
+innodb_log_group_home_dir got value /full-backup/2010-10-04_13-03-45
innodb_log_files_in_group got value 3
innodb_log_file_size got value 10485760
-091214 19:00:27 ibbackup: ibbackup_logfile's creation parameters:
-ibbackup: start lsn 2261743616, end lsn 2261747124,
-ibbackup: start checkpoint 2261743775.
-InnoDB: Doing recovery: scanned up to log sequence number 2261747124
+101004 13:04:55 ibbackup: ibbackup_logfile's creation parameters:
+ibbackup: start lsn 2626685440, end lsn 2626689439,
+ibbackup: start checkpoint 2626685456.
+InnoDB: Doing recovery: scanned up to log sequence number 2626689439
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 2261747124.
+ibbackup: lsn 2626689439.
ibbackup: Last MySQL binlog file position 0 538, file name ./MySQL-bin.000046
-ibbackup: The first data file is '/full-backup/2009-12-14_18-58-36/ibdata1'
-ibbackup: and the new created log files are at '/full-backup/2009-12-14_18-58-36/'
+ibbackup: The first data file is '/full-backup/2010-10-04_13-03-45/ibdata1'
+ibbackup: and the new created log files are at '/full-backup/2010-10-04_13-03-45/'
ibbackup: System tablespace file format is Barracuda.
-091214 19:00:28 ibbackup: Full backup prepared for recovery successfully!
-091214 19:00:28 innobackup: innobackup completed OK!
+101004 13:04:57 ibbackup: Full backup prepared for recovery successfully!
+
+101004 13:04:57 mysqlbackup: mysqlbackup completed OK!
+
</programlisting>
<para>
Then, we apply the changes from the incremental backup:
</para>
-<programlisting>
-$ mysqlbackup --apply-log --incremental /incr-backup/2009-12-14_18-59-45/backup-my.cnf /full-backup/2009-12-14_18-58-36/backup-my.cnf
+<programlisting id="example-5.6f">
+$ mysqlbackup --apply-log --incremental /incr-backup/2010-10-04_13-04-31/backup-my.cnf /full-backup/2010-10-04_13-03-45/backup-my.cnf
+mysqlbackup: Starting mysqlbackup with following arguments:
+mysqlbackup --apply-log --incremental /incr-backup/2010-10-04_13-04-31/backup-my.cnf /full-backup/2010-10-04_13-03-45/backup-my.cnf
-InnoDB Backup Utility v1.7.2
-Copyright (c) 2003, 2010, Oracle and/or its affiliates. All Rights Reserved.
+mysqlbackup: IMPORTANT: Please check that apply-log run completes successfully.
+ At the end of a successful 'apply-log' run mysqlbackup
+ prints "mysqlbackup completed OK!".
-This software is published under
-the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
+mysqlbackup: Using ibbackup version 3.5.2 MySQL Enterprise Backup 3.5.2
-IMPORTANT: Please check that the apply-log run completes successfully.
- At the end of a successful apply-log run innobackup
- prints "innobackup completed OK!".
+101004 13:04:57 mysqlbackup: Copying all non-InnoDB files in subdirectories of
+mysqlbackup: '/incr-backup/2010-10-04_13-04-31'
+mysqlbackup: to the corresponding subdirectories in
+mysqlbackup: '/full-backup/2010-10-04_13-03-45'
+mysqlbackup: Copying files '/incr-backup/2010-10-04_13-04-31/mysql/*' (76 files)
+mysqlbackup: Copying files '/incr-backup/2010-10-04_13-04-31/test/*' (10 files)
-innobackup: Using MySQL Enterprise Backup 3.5-beta5
+mysqlbackup: Checking for deleted databases and non-InnoDB files in them
+101004 13:04:57 mysqlbackup: Finished copying all non-InnoDB files from the
+mysqlbackup: incremental backup to the full backup.
-091214 19:00:29 innobackup: Starting ibbackup with command: ibbackup --restore --incremental /incr-backup/2009-12-14_18-59-45/backup-my.cnf /full-backup/2009-12-14_18-58-36/backup-my.cnf
+mysqlbackup: Starting ibbackup binary with args:
-ibbackup version 3.5.1 MySQL Enterprise Backup 3.5.1
+./ibbackup --apply-log --incremental /incr-backup/2010-10-04_13-04-31/backup-my.cnf /full-backup/2010-10-04_13-03-45/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 --license for detailed license terms, --help for help
+Run 'ibbackup --help' for help and 'ibbackup --version' for version info.
-Contents of /incr-backup/2009-12-14_18-59-45/backup-my.cnf:
-innodb_data_home_dir got value /incr-backup/2009-12-14_18-59-45
+Note: Using posix_fadvise() for performance optimization.
+
+Contents of /incr-backup/2010-10-04_13-04-31/backup-my.cnf:
+innodb_data_home_dir got value /incr-backup/2010-10-04_13-04-31
innodb_data_file_path got value ibdata1:10M;ibdata2:20M;ibdata3:50M:autoextend
-datadir got value /incr-backup/2009-12-14_18-59-45
-innodb_log_group_home_dir got value /incr-backup/2009-12-14_18-59-45
+datadir got value /incr-backup/2010-10-04_13-04-31
+innodb_log_group_home_dir got value /incr-backup/2010-10-04_13-04-31
innodb_log_files_in_group got value 3
innodb_log_file_size got value 10485760
-Contents of /full-backup/2009-12-14_18-58-36/backup-my.cnf:
-innodb_data_home_dir got value /full-backup/2009-12-14_18-58-36
+Contents of /full-backup/2010-10-04_13-03-45/backup-my.cnf:
+innodb_data_home_dir got value /full-backup/2010-10-04_13-03-45
innodb_data_file_path got value ibdata1:10M;ibdata2:20M;ibdata3:50M:autoextend
-datadir got value /full-backup/2009-12-14_18-58-36
-innodb_log_group_home_dir got value /full-backup/2009-12-14_18-58-36
+datadir got value /full-backup/2010-10-04_13-03-45
+innodb_log_group_home_dir got value /full-backup/2010-10-04_13-03-45
innodb_log_files_in_group got value 3
innodb_log_file_size got value 10485760
-091214 19:00:29 ibbackup: ibbackup_logfile's creation parameters:
-ibbackup: start lsn 2282876416, end lsn 2282880219,
-ibbackup: start checkpoint 2282876864.
-InnoDB: Doing recovery: scanned up to log sequence number 2282880219
+101004 13:04:58 ibbackup: ibbackup_logfile's creation parameters:
+ibbackup: start lsn 2638543872, end lsn 2638548195,
+ibbackup: start checkpoint 2638544206.
+InnoDB: Doing recovery: scanned up to log sequence number 2638548195
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 2282880219.
+ibbackup: lsn 2638548195.
ibbackup: Last MySQL binlog file position 0 538, file name ./MySQL-bin.000046
-ibbackup: The first data file is '/full-backup/2009-12-14_18-58-36/ibdata1'
-ibbackup: and the new created log files are at '/full-backup/2009-12-14_18-58-36/'
+ibbackup: The first data file is '/full-backup/2010-10-04_13-03-45/ibdata1'
+ibbackup: and the new created log files are at '/full-backup/2010-10-04_13-03-45/'
ibbackup: System tablespace file format is Barracuda.
-091214 19:00:31 ibbackup: Incremental backup applied successfully!
-091214 19:00:31 innobackup: innobackup completed OK!
+101004 13:05:00 ibbackup: Incremental backup applied successfully!
+
+101004 13:05:00 mysqlbackup: mysqlbackup completed OK!
+
</programlisting>
<para>
@@ -2937,42 +3017,41 @@
up-to-date, as of the time of the last incremental backup:
</para>
-<programlisting>
-$ ls -lh /full-backup/2009-12-14_18-58-36/{.,test}
-/full-backup/2009-12-14_18-58-36/.:
+<programlisting id="example-5.6g">
+$ ls -lh /full-backup/2010-10-04_13-03-45/{.,test}
+/full-backup/2010-10-04_13-03-45/.:
total 135M
--rw-r--r-- 1 pekka pekka 360 2009-12-14 18:58 backup-my.cnf
--rw-r--r-- 1 pekka pekka 1 2009-12-14 18:59 ibbackup_binlog_info
--rw-r----- 1 pekka pekka 4.5K 2009-12-14 19:00 ibbackup_logfile
--rw-r----- 1 pekka pekka 10M 2009-12-14 19:00 ibdata1
--rw-r----- 1 pekka pekka 20M 2009-12-14 19:00 ibdata2
--rw-r----- 1 pekka pekka 74M 2009-12-14 18:58 ibdata3
--rw-r----- 1 pekka pekka 10M 2009-12-14 19:00 ib_logfile0
--rw-r----- 1 pekka pekka 10M 2009-12-14 19:00 ib_logfile1
--rw-r----- 1 pekka pekka 10M 2009-12-14 19:00 ib_logfile2
-drwxr-xr-x 2 pekka pekka 4.0K 2009-12-14 18:59 mysql
--rw-r--r-- 1 pekka pekka 0 2009-12-14 18:58 mysql-stderr
--rw-r--r-- 1 pekka pekka 466 2009-12-14 18:59 mysql-stdout
-drwxr-x--- 2 pekka pekka 4.0K 2009-12-14 18:59 test
+-rw-r--r-- 1 pekka pekka 359 2010-10-04 13:03 backup-my.cnf
+-rw-r--r-- 1 pekka pekka 18 2010-10-04 13:04 ibbackup_binlog_info
+-rw-r--r-- 1 pekka pekka 155 2010-10-04 13:04 ibbackup_export_variables.txt
+-rw-r----- 1 pekka pekka 5.0K 2010-10-04 13:04 ibbackup_logfile
+-rw-r----- 1 pekka pekka 10M 2010-10-04 13:04 ibdata1
+-rw-r----- 1 pekka pekka 20M 2010-10-04 13:04 ibdata2
+-rw-r----- 1 pekka pekka 74M 2010-10-04 13:03 ibdata3
+-rw-r----- 1 pekka pekka 10M 2010-10-04 13:05 ib_logfile0
+-rw-r----- 1 pekka pekka 10M 2010-10-04 13:04 ib_logfile1
+-rw-r----- 1 pekka pekka 10M 2010-10-04 13:05 ib_logfile2
+drwx------ 2 pekka pekka 4.0K 2010-10-04 13:04 mysql
+drwxr-x--- 2 pekka pekka 4.0K 2010-10-04 13:04 test
-/full-backup/2009-12-14_18-58-36/test:
-total 75M
--rw-rw---- 1 pekka pekka 8.9K 2009-10-27 18:53 alex1.frm
--rw-r----- 1 pekka pekka 23M 2009-12-14 18:58 alex1.ibd
--rw-rw---- 1 pekka pekka 8.9K 2009-09-15 15:53 alex2.frm
--rw-r----- 1 pekka pekka 240K 2009-12-14 18:58 alex2.ibd
--rw-rw---- 1 pekka pekka 8.9K 2009-10-27 18:54 alex3.frm
--rw-r----- 1 pekka pekka 240K 2009-12-14 18:58 alex3.ibd
--rw-rw---- 1 pekka pekka 8.5K 2009-12-14 18:58 blobt3.frm
--rw-r----- 1 pekka pekka 25M 2009-12-14 19:00 blobt3.ibd
--rw-rw---- 1 pekka pekka 8.5K 2009-09-15 15:53 ibstest0.frm
--rw-r----- 1 pekka pekka 25M 2009-12-14 18:58 ibstest0.ibd
--rw-rw---- 1 pekka pekka 8.6K 2009-10-27 18:55 ibtest09.frm
--rw-r----- 1 pekka pekka 912K 2009-12-14 18:58 ibtest09.ibd
--rw-rw---- 1 pekka pekka 8.5K 2009-10-27 19:05 ibtest11a.frm
--rw-rw---- 1 pekka pekka 8.5K 2009-10-27 19:05 ibtest11b.frm
--rw-rw---- 1 pekka pekka 8.5K 2009-10-27 19:05 ibtest11c.frm
--rw-rw---- 1 pekka pekka 8.5K 2009-10-27 19:05 ibtest11d.frm
+/full-backup/2010-10-04_13-03-45/test:
+total 71M
+-rw-r----- 1 pekka pekka 8.9K 2010-10-04 13:04 alex1.frm
+-rw-r----- 1 pekka pekka 23M 2010-10-04 13:04 alex1.ibd
+-rw-r----- 1 pekka pekka 8.9K 2010-10-04 13:04 alex2.frm
+-rw-r----- 1 pekka pekka 240K 2010-10-04 13:04 alex2.ibd
+-rw-r----- 1 pekka pekka 8.9K 2010-10-04 13:04 alex3.frm
+-rw-r----- 1 pekka pekka 240K 2010-10-04 13:04 alex3.ibd
+-rw-r----- 1 pekka pekka 8.5K 2010-10-04 13:04 blobt3.frm
+-rw-r----- 1 pekka pekka 21M 2010-10-04 13:04 blobt3.ibd
+-rw-r----- 1 pekka pekka 8.5K 2010-10-04 13:04 ibstest0.frm
+-rw-r----- 1 pekka pekka 25M 2010-10-04 13:04 ibstest0.ibd
+-rw-r----- 1 pekka pekka 8.6K 2010-10-04 13:04 ibtest09.frm
+-rw-r----- 1 pekka pekka 912K 2010-10-04 13:04 ibtest09.ibd
+-rw-r----- 1 pekka pekka 8.5K 2010-10-04 13:04 ibtest11a.frm
+-rw-r----- 1 pekka pekka 8.5K 2010-10-04 13:04 ibtest11b.frm
+-rw-r----- 1 pekka pekka 8.5K 2010-10-04 13:04 ibtest11c.frm
+-rw-r----- 1 pekka pekka 8.5K 2010-10-04 13:04 ibtest11d.frm
</programlisting>
</section>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r23175 - trunk/mysql-enterprise-backup-3.5 | john.russell | 18 Oct |
