Author: jrussell
Date: 2010-10-18 07:04:10 +0200 (Mon, 18 Oct 2010)
New Revision: 23172
Log:
Replaced the rest of the innobackup a.k.a. mysqlbackup examples.
I think example-5.6a.txt through g.txt represent a new scenario
that's not in the manual yet, that Pekka would like to add.
I think example-incr.1a.txt and all the other -incr ones are now obsolete
because their place is taken by renamed ones.
Crosscheck before doing any 'svn rm' to take these files out of SVN.
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 04:53:31 UTC (rev 23171)
+++ trunk/mysql-enterprise-backup-3.5/manual.xml 2010-10-18 05:04:10 UTC (rev 23172)
Changed blocks: 8, Lines Added: 47, Lines Deleted: 43; 7558 bytes
@@ -3078,7 +3078,7 @@
stored in per-table datafiles (<literal>.ibd</literal> files).
</para>
-<programlisting>
+<programlisting id="example-6.1a">
$ ls /sqldata/mts/test
alex1.frm alex2.ibd blobt3.frm ibstest0.ibd ibtest11a.frm ibtest11d.frm
alex1.ibd alex3.frm blobt3.ibd ibtest09.frm ibtest11b.frm
@@ -3089,12 +3089,14 @@
We run ibbackup with the <literal>--include</literal> option.
</para>
-<programlisting>
-$ ibbackup --include 'test\.ib.*' /home/pekka/.my.cnf /home/pekka/.backup-my.cnf
-ibbackup version 3.5.1 MySQL Enterprise Backup 3.5.1
+<programlisting id="example-6.1b">
+$ ibbackup --include 'test\.ib.*' /home/pekka/.my.cnf /home/pekka/.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.
+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
@@ -3111,24 +3113,24 @@
innodb_log_files_in_group got value 3
innodb_log_file_size got value 10485760
-Value of include option: 'test\.ib.*'
+Value of include option: 'test\.ib.*'
ibbackup: System tablespace file format is Barracuda.
-ibbackup: Found checkpoint at lsn 2559661285.
-ibbackup: Starting log scan from lsn 2559661056.
-100302 17:51:11 ibbackup: Copying log...
-100302 17:51:11 ibbackup: Log copied, lsn 2559661285.
+ibbackup: Found checkpoint at lsn 2638548215.
+ibbackup: Starting log scan from lsn 2638547968.
+101004 13:23:03 ibbackup: Copying log...
+101004 13:23:03 ibbackup: Log copied, lsn 2638548215.
ibbackup: We wait 1 second before starting copying the data files...
-100302 17:51:12 ibbackup: Copying /sqldata/mts/ibdata1 (Barracuda file format).
-100302 17:51:12 ibbackup: Copying /sqldata/mts/ibdata2 (Barracuda file format).
-100302 17:51:13 ibbackup: Copying /sqldata/mts/ibdata3 (Barracuda file format).
-100302 17:51:16 ibbackup: Copying /sqldata/mts/test/ibstest0.ibd (Antelope file format).
-100302 17:51:17 ibbackup: Copying /sqldata/mts/test/ibtest09.ibd (Antelope file format).
-ibbackup: A copied database page was modified at 2559661285.
-ibbackup: Scanned log up to lsn 2559661285.
-ibbackup: Was able to parse the log up to lsn 2559661285.
+101004 13:23:04 ibbackup: Copying /sqldata/mts/ibdata1 (Barracuda file format).
+101004 13:23:05 ibbackup: Copying /sqldata/mts/ibdata2 (Barracuda file format).
+101004 13:23:07 ibbackup: Copying /sqldata/mts/ibdata3 (Barracuda file format).
+101004 13:23:15 ibbackup: Copying /sqldata/mts/test/ibstest0.ibd (Antelope file format).
+101004 13:23:17 ibbackup: Copying /sqldata/mts/test/ibtest09.ibd (Antelope file format).
+ibbackup: A copied database page was modified at 2638548215.
+ibbackup: Scanned log up to lsn 2638548215.
+ibbackup: Was able to parse the log up to lsn 2638548215.
ibbackup: Maximum page number for a log record 0
-100302 17:51:17 ibbackup: Full backup completed!
+101004 13:23:18 ibbackup: Full backup completed!
</programlisting>
<para>
@@ -3144,7 +3146,7 @@
the backup.
</para>
-<programlisting>
+<programlisting id="example-6.1c">
$ ls /sqldata-backup/test
ibstest0.ibd
ibtest09.ibd
@@ -3164,7 +3166,7 @@
for <literal>test</literal> database is shown below.
</para>
-<programlisting>
+<programlisting id="example-6.2a">
$ ls /sqldata/mts/test
alex1.frm alex2.ibd blobt3.frm ibstest0.ibd ibtest11a.frm ibtest11d.frm
alex1.ibd alex3.frm blobt3.ibd ibtest09.frm ibtest11b.frm
@@ -3176,12 +3178,14 @@
<literal>--include</literal> options:
</para>
-<programlisting>
-$ ibbackup --compress --include '.*\.(alex|blob).*' /home/pekka/.my.cnf /home/pekka/.backup-my.cnf
-ibbackup version 3.5.1 MySQL Enterprise Backup 3.5.1
+<programlisting id="example-6.2b">
+$ ibbackup --compress --include '.*\.(alex|blob).*' /home/pekka/.my.cnf /home/pekka/.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.
+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
@@ -3198,29 +3202,29 @@
innodb_log_files_in_group got value 3
innodb_log_file_size got value 10485760
-Value of include option: '.*\.(alex|blob).*'
+Value of include option: '.*\.(alex|blob).*'
ibbackup: System tablespace file format is Barracuda.
-ibbackup: Found checkpoint at lsn 2559661285.
-ibbackup: Starting log scan from lsn 2559661056.
-100302 17:52:34 ibbackup: Copying log...
-100302 17:52:34 ibbackup: Log copied, lsn 2559661285.
+ibbackup: Found checkpoint at lsn 2638548215.
+ibbackup: Starting log scan from lsn 2638547968.
+101004 13:23:23 ibbackup: Copying log...
+101004 13:23:23 ibbackup: Log copied, lsn 2638548215.
ibbackup: We wait 1 second before starting copying the data files...
-100302 17:52:35 ibbackup: Copying /sqldata/mts/ibdata1 (Barracuda file format).
-100302 17:52:36 ibbackup: Copying /sqldata/mts/ibdata2 (Barracuda file format).
-100302 17:52:36 ibbackup: Copying /sqldata/mts/ibdata3 (Barracuda file format).
-100302 17:52:38 ibbackup: Copying /sqldata/mts/test/alex1.ibd (Antelope file format).
-100302 17:52:40 ibbackup: Copying /sqldata/mts/test/alex2.ibd (Antelope file format).
-100302 17:52:40 ibbackup: Copying /sqldata/mts/test/alex3.ibd (Antelope file format).
-100302 17:52:40 ibbackup: Copying /sqldata/mts/test/blobt3.ibd (Antelope file format).
-ibbackup: A copied database page was modified at 2559661285.
-ibbackup: Scanned log up to lsn 2559661285.
-ibbackup: Was able to parse the log up to lsn 2559661285.
+101004 13:23:24 ibbackup: Copying /sqldata/mts/ibdata1 (Barracuda file format).
+101004 13:23:25 ibbackup: Copying /sqldata/mts/ibdata2 (Barracuda file format).
+101004 13:23:26 ibbackup: Copying /sqldata/mts/ibdata3 (Barracuda file format).
+101004 13:23:32 ibbackup: Copying /sqldata/mts/test/alex1.ibd (Antelope file format).
+101004 13:23:34 ibbackup: Copying /sqldata/mts/test/alex2.ibd (Antelope file format).
+101004 13:23:34 ibbackup: Copying /sqldata/mts/test/alex3.ibd (Antelope file format).
+101004 13:23:34 ibbackup: Copying /sqldata/mts/test/blobt3.ibd (Antelope file format).
+ibbackup: A copied database page was modified at 2638548215.
+ibbackup: Scanned log up to lsn 2638548215.
+ibbackup: Was able to parse the log up to lsn 2638548215.
ibbackup: Maximum page number for a log record 0
-ibbackup: Compressed 151 MB of data files to 15 MB (compression 89%).
+ibbackup: Compressed 146 MB of data files to 15 MB (compression 89%).
-100302 17:52:41 ibbackup: Full backup completed!
+101004 13:23:36 ibbackup: Full backup completed!
</programlisting>
<para>
@@ -3229,7 +3233,7 @@
per-table datafiles.
</para>
-<programlisting>
+<programlisting id="example-6.2c">
$ ls /sqldata-backup/test
alex1.ibz
alex2.ibz
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r23172 - trunk/mysql-enterprise-backup-3.5 | john.russell | 18 Oct |
