List:Commits« Previous MessageNext Message »
From:john.russell Date:October 18 2010 5:41am
Subject:svn commit - mysqldoc@docsrva: r23175 - trunk/mysql-enterprise-backup-3.5
View as plain text  
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=&apos;hundin-bin.006&apos;,
+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 &apos;help;&apos; or &apos;\h&apos; for help. Type &apos;\c&apos; to clear the buffer.
+Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
 
-mysql&gt; GRANT RELOAD ON *.* TO &apos;dba&apos;@&apos;localhost&apos;;
+mysql> GRANT RELOAD ON *.* TO 'dba'@'localhost';
 Query OK, 0 rows affected (0.10 sec)
 
-mysql&gt; GRANT CREATE, INSERT, DROP ON mysql.ibbackup_binlog_marker
-    -&gt; TO &apos;dba&apos;@&apos;localhost&apos;;
+mysql> GRANT CREATE, INSERT, DROP ON mysql.ibbackup_binlog_marker
+    -> TO 'dba'@'localhost';
 Query OK, 0 rows affected (0.06 sec)
 
-mysql&gt; 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 &quot;innobackup completed OK!&quot;.
+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&apos;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 &apos;/full-backup/2009-12-14_18-58-36/ibdata1&apos;
-ibbackup: and the new created log files are at &apos;/full-backup/2009-12-14_18-58-36/&apos;
+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 &quot;innobackup completed OK!&quot;.
+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&apos;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 &apos;/full-backup/2009-12-14_18-58-36/ibdata1&apos;
-ibbackup: and the new created log files are at &apos;/full-backup/2009-12-14_18-58-36/&apos;
+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.5john.russell18 Oct