Author: jrussell
Date: 2010-10-18 06:53:31 +0200 (Mon, 18 Oct 2010)
New Revision: 23171
Log:
Replaced a bunch of innobackup (now mysqlbackup) examples.
I think some of the examples in source control, such as
example-5.1.txt and example-5.2.txt, no longer have corresponding
listings in the manual, which could be the source of confusion in the
sequencing for the Chapter 3 examples.
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 03:36:34 UTC (rev 23170)
+++ trunk/mysql-enterprise-backup-3.5/manual.xml 2010-10-18 04:53:31 UTC (rev 23171)
Changed blocks: 7, Lines Added: 214, Lines Deleted: 227; 29358 bytes
@@ -2278,98 +2278,94 @@
directory.
</para>
-<programlisting>
+<programlisting id="example-5.2a">
$ mysqlbackup /home/pekka/.my.cnf /backups
+mysqlbackup: Starting mysqlbackup with following arguments:
+mysqlbackup /home/pekka/.my.cnf /backups
-InnoDB Backup Utility v1.7.2
-Copyright (c) 2003, 2010, Oracle and/or its affiliates. All Rights Reserved.
+mysqlbackup: Unique backup id generated for the current backup operation is 12861836873602550
-This software is published under
-the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
+mysqlbackup: IMPORTANT: Please check that backup run completes successfully.
+ At the end of a successful 'backup' run mysqlbackup
+ prints "mysqlbackup completed OK!".
-IMPORTANT: Please check that the backup run completes successfully.
- At the end of a successful backup run innobackup
- prints "innobackup completed OK!".
+mysqlbackup: Created backup directory '/backups/2010-10-04_12-14-47'
+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
-innobackup: Using mysql Ver 14.14 Distrib 5.1.37, for pc-linux-gnu (i686) using readline 5.1
-innobackup: Using mysql server version 5.1.37
-innobackup: Using MySQL Enterprise Backup 3.5-beta7
+101004 12:14:47 mysqlbackup: Starting ibbackup binary with args:
-innobackup: Created backup directory /backups/2010-03-02_12-11-58
-100302 12:11:58 innobackup: Starting mysql with options: --unbuffered
-100302 12:11:58 innobackup: Connected to database with mysql child process (pid=12222)
-100302 12:12:02 innobackup: Connection to database server closed
-
-100302 12:12:02 innobackup: Starting ibbackup with command: ibbackup --suspend-at-end /home/pekka/.my.cnf /backups/2010-03-02_12-11-58/backup-my.cnf
-ibbackup version 3.5.1 MySQL Enterprise Backup 3.5.1
+./ibbackup --suspend-at-end /home/pekka/.my.cnf /backups/2010-10-04_12-14-47/backup-my.cnf
+mysqlbackup: Waiting for ibbackup process to suspend
+mysqlbackup: Suspend file '/backups/2010-10-04_12-14-47/ibbackup_suspended'
+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/simple
innodb_data_file_path got value ibdata1:10M;ibdata2:20M;ibdata3:50M:autoextend
datadir got value /sqldata/simple
-innobackup: Waiting for ibbackup (pid=12233) to suspend
-innobackup: Suspend file '/backups/2010-03-02_12-11-58/ibbackup_suspended'
-
innodb_log_group_home_dir got value /sqldata/simple
innodb_log_files_in_group got value 3
innodb_log_file_size got value 10485760
-Contents of /backups/2010-03-02_12-11-58/backup-my.cnf:
-innodb_data_home_dir got value /backups/2010-03-02_12-11-58
+Contents of /backups/2010-10-04_12-14-47/backup-my.cnf:
+innodb_data_home_dir got value /backups/2010-10-04_12-14-47
innodb_data_file_path got value ibdata1:10M;ibdata2:20M;ibdata3:50M:autoextend
-datadir got value /backups/2010-03-02_12-11-58
-innodb_log_group_home_dir got value /backups/2010-03-02_12-11-58
+datadir got value /backups/2010-10-04_12-14-47
+innodb_log_group_home_dir got value /backups/2010-10-04_12-14-47
innodb_log_files_in_group got value 3
innodb_log_file_size got value 10485760
ibbackup: System tablespace file format is Antelope.
-ibbackup: Found checkpoint at lsn 928223244.
-ibbackup: Starting log scan from lsn 928223232.
-100302 12:12:02 ibbackup: Copying log...
-100302 12:12:02 ibbackup: Log copied, lsn 928223244.
+ibbackup: Found checkpoint at lsn 32164666380.
+ibbackup: Starting log scan from lsn 32164666368.
+101004 12:14:47 ibbackup: Copying log...
+101004 12:14:48 ibbackup: Log copied, lsn 32164666380.
ibbackup: We wait 1 second before starting copying the data files...
-100302 12:12:03 ibbackup: Copying /sqldata/simple/ibdata1 (Antelope file format).
-100302 12:12:04 ibbackup: Copying /sqldata/simple/ibdata2 (Antelope file format).
-100302 12:12:05 ibbackup: Copying /sqldata/simple/ibdata3 (Antelope file format).
+101004 12:14:49 ibbackup: Copying /sqldata/simple/ibdata1 (Antelope file format).
+101004 12:14:50 ibbackup: Copying /sqldata/simple/ibdata2 (Antelope file format).
+101004 12:14:54 ibbackup: Copying /sqldata/simple/ibdata3 (Antelope file format).
+ibbackup: Progress in MB: 200 400
ibbackup: You specified the option --suspend-at-end.
-100302 12:12:11 ibbackup: Suspending the backup procedure to wait
-ibbackup: until you delete the marker file /backups/2010-03-02_12-11-58/ibbackup_suspended.
-100302 12:12:12 innobackup: Continuing after ibbackup has suspended
-100302 12:12:12 innobackup: Starting mysql with options: --unbuffered
-100302 12:12:12 innobackup: Connected to database with mysql child process (pid=12240)
-100302 12:12:16 innobackup: Starting to lock all tables...
-100302 12:12:33 innobackup: All tables locked and flushed to disk
+101004 12:16:04 mysqlbackup: Continuing after ibbackup has suspended
-100302 12:12:33 innobackup: Starting to backup all files in
-innobackup: subdirectories of '/backups/2009-10-27_16-44-38'
-innobackup: Backing up files '/backups/2009-10-27_16-44-38/mysql/*' (70 files)
-innobackup: Backing up file '/backups/2009-10-27_16-44-38/test/alex2.frm'
-innobackup: Backing up file '/backups/2009-10-27_16-44-38/test/blobt3.frm'
-innobackup: Backing up file '/backups/2009-10-27_16-44-38/test/ibstest0.frm'
-innobackup: Backing up file '/backups/2009-10-27_16-44-38/test/ibstest1.frm'
-100302 12:12:33 innobackup: Finished backing up all files in database subdirectories
+101004 12:16:04 mysqlbackup: Starting to lock all the tables....
-innobackup: Resuming ibbackup
+101004 12:16:04 mysqlbackup: All tables are locked and flushed to disk
+mysqlbackup: Opening backup source directory '/sqldata/simple'
-100302 12:12:34 ibbackup: Suspension ends. Continuing the backup procedure.
+101004 12:16:04 mysqlbackup: Starting to backup all files in subdirectories of '/sqldata/simple'
+mysqlbackup: Backing up the database directory 'mysql'
+101004 12:16:04 ibbackup: Suspending the backup procedure to wait
+ibbackup: until you delete the marker file /backups/2010-10-04_12-14-47/ibbackup_suspended.
+mysqlbackup: Backing up the database directory 'test'
-100302 12:12:34 ibbackup: Copying of the last data file is close to ending...
+101004 12:16:06 mysqlbackup: All tables unlocked
+mysqlbackup: All tables were locked for 1.959 seconds
+mysqlbackup: Resuming ibbackup
+101004 12:16:07 ibbackup: Suspension ends. Continuing the backup procedure.
+
+101004 12:16:07 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 928223006.
-ibbackup: Scanned log up to lsn 928223244.
-ibbackup: Was able to parse the log up to lsn 928223244.
+ibbackup: A copied database page was modified at 32164665879.
+ibbackup: Scanned log up to lsn 32164666380.
+ibbackup: Was able to parse the log up to lsn 32164666380.
ibbackup: Maximum page number for a log record 0
-100302 12:12:34 ibbackup: Full backup completed!
-100302 12:12:38 innobackup: All tables unlocked
-100302 12:12:38 innobackup: Connection to database server closed
+101004 12:16:07 ibbackup: Full backup completed!
+mysqlbackup: Backup created in directory '/backups/2010-10-04_12-14-47'
+mysqlbackup: start_lsn: 32164666368
+mysqlbackup: incremental_base_lsn: 32164665879
+mysqlbackup: end_lsn: 32164666380
-innobackup: Backup created in directory '/backups/2010-03-02_12-11-58'
-innobackup: MySQL binlog position: filename '', position
-100302 12:12:38 innobackup: innobackup completed OK!
+101004 12:16:08 mysqlbackup: mysqlbackup completed OK!
+
</programlisting>
<para>
@@ -2379,19 +2375,20 @@
time when the backup run was started, in the local time zone.
</para>
-<programlisting>
+<programlisting id="example-5.2b">
$ ls -lh /backups
-total 56K
-drwxr-xr-x 4 pekka pekka 88 2009-10-27 15:44 2009-10-27_15-43-35
-drwxr-xr-x 4 pekka pekka 4.0K 2009-10-27 16:11 2009-10-27_15-50-24
-drwxr-xr-x 4 pekka pekka 4.0K 2009-10-27 16:12 2009-10-27_16-12-07
-drwxr-xr-x 4 pekka pekka 4.0K 2009-10-27 16:18 2009-10-27_16-16-56
-drwxr-xr-x 4 pekka pekka 4.0K 2009-10-27 16:19 2009-10-27_16-19-11
-drwxr-xr-x 4 pekka pekka 4.0K 2010-03-02 12:11 2009-10-27_16-44-38
-drwxr-xr-x 2 pekka pekka 24 2009-12-14 17:46 2009-12-14_17-46-44
+total 60K
+drwxr-xr-x 4 pekka pekka 4.0K 2010-03-18 15:34 2009-10-27_16-44-38
drwxr-xr-x 4 pekka pekka 4.0K 2009-12-14 18:56 2009-12-14_18-56-02
-drwxr-xr-x 2 pekka pekka 24 2010-03-02 12:05 2010-03-02_12-05-17
-drwxr-xr-x 4 pekka pekka 88 2010-03-02 12:12 2010-03-02_12-11-58
+drwxr-xr-x 4 pekka pekka 88 2010-03-25 17:04 2010-03-25_17-03-34
+drwxr-xr-x 4 pekka pekka 4.0K 2010-05-17 18:26 2010-05-17_18-23-52
+drwxr-xr-x 4 pekka pekka 4.0K 2010-10-04 12:14 2010-05-17_18-35-41
+drwx------ 4 pekka pekka 80 2010-09-15 13:17 2010-09-15_13-16-19
+drwx------ 4 pekka pekka 80 2010-09-16 14:19 2010-09-16_14-17-59
+drwx------ 4 pekka pekka 80 2010-09-20 13:37 2010-09-20_13-36-07
+drwx------ 4 pekka pekka 80 2010-09-27 12:56 2010-09-27_12-54-57
+drwx------ 4 pekka pekka 80 2010-09-30 15:25 2010-09-30_15-24-23
+drwx------ 4 pekka pekka 80 2010-10-04 12:16 2010-10-04_12-14-47
</programlisting>
<para>
@@ -2404,19 +2401,18 @@
<literal>.MYD</literal>, and <literal>.MYI</literal> files:
</para>
-<programlisting>
-$ ls -lh /backups/2010-03-02_12-11-58
-total 145M
--rw-r--r-- 1 pekka pekka 348 2010-03-02 12:11 backup-my.cnf
--rw-r--r-- 1 pekka pekka 1 2010-03-02 12:12 ibbackup_binlog_info
--rw-r----- 1 pekka pekka 1.0K 2010-03-02 12:12 ibbackup_logfile
--rw-r----- 1 pekka pekka 10M 2010-03-02 12:12 ibdata1
--rw-r----- 1 pekka pekka 20M 2010-03-02 12:12 ibdata2
--rw-r----- 1 pekka pekka 114M 2010-03-02 12:12 ibdata3
-drwxr-xr-x 2 pekka pekka 4.0K 2010-03-02 12:12 mysql
--rw-r--r-- 1 pekka pekka 0 2010-03-02 12:12 mysql-stderr
--rw-r--r-- 1 pekka pekka 466 2010-03-02 12:12 mysql-stdout
-drwxr-xr-x 2 pekka pekka 32 2010-03-02 12:12 test
+<programlisting id="example-5.2c">
+$ ls -lh /backups/2010-10-04_12-14-47
+total 489M
+-rw-r--r-- 1 pekka pekka 347 2010-10-04 12:14 backup-my.cnf
+-rw-r--r-- 1 pekka pekka 18 2010-10-04 12:16 ibbackup_binlog_info
+-rw-r--r-- 1 pekka pekka 158 2010-10-04 12:16 ibbackup_export_variables.txt
+-rw-r----- 1 pekka pekka 1.0K 2010-10-04 12:16 ibbackup_logfile
+-rw-r----- 1 pekka pekka 10M 2010-10-04 12:14 ibdata1
+-rw-r----- 1 pekka pekka 20M 2010-10-04 12:14 ibdata2
+-rw-r----- 1 pekka pekka 458M 2010-10-04 12:16 ibdata3
+drwx------ 2 pekka pekka 4.0K 2010-10-04 12:16 mysql
+drwx------ 2 pekka pekka 24 2010-10-04 12:16 test
</programlisting>
<para>
@@ -2453,52 +2449,51 @@
(<literal>ibdata*</literal>).
</para>
-<programlisting>
-$ mysqlbackup --apply-log /home/pekka/.my.cnf /backups/2010-03-02_12-11-58
+<programlisting id="example-5.3a">
+$ mysqlbackup --apply-log /home/pekka/.my.cnf /backups/2010-10-04_12-14-47
+mysqlbackup: Starting mysqlbackup with following arguments:
+mysqlbackup --apply-log /home/pekka/.my.cnf /backups/2010-10-04_12-14-47
-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
+mysqlbackup: Starting ibbackup binary with args:
-IMPORTANT: Please check that the apply-log run completes successfully.
- At the end of a successful apply-log run innobackup
- prints "innobackup completed OK!".
-
-innobackup: Using MySQL Enterprise Backup 3.5-beta7
-
-
-100302 12:18:58 innobackup: Starting ibbackup with command: ibbackup --restore /backups/2010-03-02_12-11-58/backup-my.cnf
-
-ibbackup version 3.5.1 MySQL Enterprise Backup 3.5.1
+./ibbackup --apply-log /backups/2010-10-04_12-14-47/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 /backups/2010-03-02_12-11-58/backup-my.cnf:
-innodb_data_home_dir got value /backups/2010-03-02_12-11-58
+Note: Using posix_fadvise() for performance optimization.
+
+Contents of /backups/2010-10-04_12-14-47/backup-my.cnf:
+innodb_data_home_dir got value /backups/2010-10-04_12-14-47
innodb_data_file_path got value ibdata1:10M;ibdata2:20M;ibdata3:50M:autoextend
-datadir got value /backups/2010-03-02_12-11-58
-innodb_log_group_home_dir got value /backups/2010-03-02_12-11-58
+datadir got value /backups/2010-10-04_12-14-47
+innodb_log_group_home_dir got value /backups/2010-10-04_12-14-47
innodb_log_files_in_group got value 3
innodb_log_file_size got value 10485760
-100302 12:18:58 ibbackup: ibbackup_logfile's creation parameters:
-ibbackup: start lsn 928223232, end lsn 928223244,
-ibbackup: start checkpoint 928223244.
-InnoDB: Doing recovery: scanned up to log sequence number 928223244
+101004 12:24:12 ibbackup: ibbackup_logfile's creation parameters:
+ibbackup: start lsn 32164666368, end lsn 32164666380,
+ibbackup: start checkpoint 32164666380.
+InnoDB: Doing recovery: scanned up to log sequence number 32164666380
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 928223244.
+ibbackup: lsn 32164666380.
ibbackup: Last MySQL binlog file position 0 534, file name ./MySQL-bin.000008
-ibbackup: The first data file is '/backups/2010-03-02_12-11-58/ibdata1'
-ibbackup: and the new created log files are at '/backups/2010-03-02_12-11-58/'
+ibbackup: The first data file is '/backups/2010-10-04_12-14-47/ibdata1'
+ibbackup: and the new created log files are at '/backups/2010-10-04_12-14-47/'
ibbackup: System tablespace file format is Antelope.
-100302 12:19:00 ibbackup: Full backup prepared for recovery successfully!
-100302 12:19:00 innobackup: innobackup completed OK!
+101004 12:24:13 ibbackup: Full backup prepared for recovery successfully!
+
+101004 12:24:13 mysqlbackup: mysqlbackup completed OK!
+
</programlisting>
<para>
@@ -2508,67 +2503,65 @@
(lsn) <literal>928223244</literal>.
</para>
-<programlisting>
-$ ls -lh /backups/2010-03-02_12-11-58
-total 175M
--rw-r--r-- 1 pekka pekka 348 2010-03-02 12:11 backup-my.cnf
--rw-r--r-- 1 pekka pekka 1 2010-03-02 12:12 ibbackup_binlog_info
--rw-r----- 1 pekka pekka 1.0K 2010-03-02 12:12 ibbackup_logfile
--rw-r----- 1 pekka pekka 10M 2010-03-02 12:12 ibdata1
--rw-r----- 1 pekka pekka 20M 2010-03-02 12:12 ibdata2
--rw-r----- 1 pekka pekka 114M 2010-03-02 12:12 ibdata3
--rw-r----- 1 pekka pekka 10M 2010-03-02 12:19 ib_logfile0
--rw-r----- 1 pekka pekka 10M 2010-03-02 12:18 ib_logfile1
--rw-r----- 1 pekka pekka 10M 2010-03-02 12:19 ib_logfile2
-drwxr-xr-x 2 pekka pekka 4.0K 2010-03-02 12:12 mysql
--rw-r--r-- 1 pekka pekka 0 2010-03-02 12:12 mysql-stderr
--rw-r--r-- 1 pekka pekka 466 2010-03-02 12:12 mysql-stdout
-drwxr-xr-x 2 pekka pekka 32 2010-03-02 12:12 test
+<programlisting id="example-5.3b">
+$ ls -lh /backups/2010-10-04_12-14-47
+total 519M
+-rw-r--r-- 1 pekka pekka 347 2010-10-04 12:14 backup-my.cnf
+-rw-r--r-- 1 pekka pekka 18 2010-10-04 12:16 ibbackup_binlog_info
+-rw-r--r-- 1 pekka pekka 158 2010-10-04 12:16 ibbackup_export_variables.txt
+-rw-r----- 1 pekka pekka 1.0K 2010-10-04 12:16 ibbackup_logfile
+-rw-r----- 1 pekka pekka 10M 2010-10-04 12:14 ibdata1
+-rw-r----- 1 pekka pekka 20M 2010-10-04 12:14 ibdata2
+-rw-r----- 1 pekka pekka 458M 2010-10-04 12:16 ibdata3
+-rw-r----- 1 pekka pekka 10M 2010-10-04 12:24 ib_logfile0
+-rw-r----- 1 pekka pekka 10M 2010-10-04 12:24 ib_logfile1
+-rw-r----- 1 pekka pekka 10M 2010-10-04 12:24 ib_logfile2
+drwx------ 2 pekka pekka 4.0K 2010-10-04 12:16 mysql
+drwx------ 2 pekka pekka 24 2010-10-04 12:16 test
</programlisting>
<para>
- We are now almost ready to start a server on this backup. Before
- we can do this, we must prepare a valid
- <literal>my.cnf</literal> file for the backup. The
- <literal>backup-my.cnf</literal> in the backup directory cannot
- be used as such because it contains only the six parameters
- required by <literal>&llbackup;</literal>. We must create a
- <literal>my.cnf</literal> file where these six parameters are
- copied from <literal>backup-my.cnf</literal> file, and the other
- parameters are defined by the original <literal>my.cnf</literal>
- file (which is <literal>/home/pekka/.my.cnf</literal> in this
- example). We make a copy of the original file and add the
- changes in <literal>backup-my.cnf</literal>.
+ We are now almost ready to start a server on this backup. The
+ final requirement is to prepare a valid
+ <literal>my.cnf</literal> file for the backup. We cannot reuse
+ the <literal>backup-my.cnf</literal> in the backup directory,
+ because it contains only the small subset of parameters required
+ by <literal>&llbackup;</literal>. We must create a
+ <literal>my.cnf</literal> file by copying these parameters from
+ the <literal>backup-my.cnf</literal> file, and copying the other
+ parameters from the original <literal>my.cnf</literal> file
+ (which is <literal>/home/pekka/.my.cnf</literal> in this
+ example). We make a copy of the original file and append the
+ additional parameters in <literal>backup-my.cnf</literal>.
</para>
-<programlisting>
-$ cat /home/pekka/.my.cnf /backups/2010-03-02_12-11-58/backup-my.cnf > /backups/2010-03-02_12-11-58/my.cnf
+<programlisting id="example-5.3c">
+$ cat /home/pekka/.my.cnf /backups/2010-10-04_12-14-47/backup-my.cnf > /backups/2010-10-04_12-14-47/my.cnf
</programlisting>
<para>
- Now we have a valid <literal>my.cnf</literal> file
- (<literal>/backups/2009-10-27_16-44-38/my.cnf</literal>), and we
- can start a server on the backup:
+ Now we can start a server on the backup, specifying this new
+ <literal>my.cnf</literal> as the configuration file:
</para>
-<programlisting>
-$ mysqld --defaults-file=/backups/2010-03-02_12-11-58/my.cnf
-100302 12:19:00 [Warning] Changed limits: max_open_files: 1024 max_connections: 200 table_cache: 407
-100302 12:19:00 [Note] Plugin 'FEDERATED' is disabled.
+<programlisting id="example-5.3d">
+$ mysqld --defaults-file=/backups/2010-10-04_12-14-47/my.cnf
+101004 12:24:13 [Warning] Changed limits: max_open_files: 1024 max_connections: 200 table_cache: 407
+101004 12:24:14 [Note] Plugin 'FEDERATED' is disabled.
InnoDB: The log file was created by ibbackup --apply-log at
-InnoDB: ibbackup 100302 12:19:00
+InnoDB: ibbackup 101004 12:24:13
InnoDB: NOTE: the following crash recovery is part of a normal restore.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
-100302 12:19:00 InnoDB: Database was not shut down normally!
+101004 12:24:14 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Last MySQL binlog file position 0 534, file name ./MySQL-bin.000008
-100302 12:19:00 InnoDB: Started; log sequence number 0 928223756
-100302 12:19:00 [Note] Event Scheduler: Loaded 0 events
-100302 12:19:00 [Note] mysqld: ready for connections.
+101004 12:24:14 InnoDB: Started; log sequence number 7 2099895820
+101004 12:24:14 [Note] Event Scheduler: Loaded 0 events
+101004 12:24:14 [Note] mysqld: ready for connections.
</programlisting>
</section>
@@ -2582,23 +2575,22 @@
<literal>/backups/2004-02-03_13-27-09</literal>):
</para>
-<programlisting>
-$ ls -lh /backups/2010-03-02_12-11-58
-total 175M
--rw-r--r-- 1 pekka pekka 348 2010-03-02 12:11 backup-my.cnf
--rw-r--r-- 1 pekka pekka 1 2010-03-02 12:12 ibbackup_binlog_info
--rw-r----- 1 pekka pekka 1.0K 2010-03-02 12:12 ibbackup_logfile
--rw-r----- 1 pekka pekka 10M 2010-03-02 12:19 ibdata1
--rw-r----- 1 pekka pekka 20M 2010-03-02 12:19 ibdata2
--rw-r----- 1 pekka pekka 114M 2010-03-02 12:19 ibdata3
--rw-r----- 1 pekka pekka 10M 2010-03-02 12:19 ib_logfile0
--rw-r----- 1 pekka pekka 10M 2010-03-02 12:18 ib_logfile1
--rw-r----- 1 pekka pekka 10M 2010-03-02 12:19 ib_logfile2
--rw-r--r-- 1 pekka pekka 3.2K 2010-03-02 12:19 my.cnf
-drwxr-xr-x 2 pekka pekka 4.0K 2010-03-02 12:12 mysql
--rw-r--r-- 1 pekka pekka 0 2010-03-02 12:12 mysql-stderr
--rw-r--r-- 1 pekka pekka 466 2010-03-02 12:12 mysql-stdout
-drwxr-xr-x 2 pekka pekka 32 2010-03-02 12:12 test
+<programlisting id="example-5.4a">
+$ ls -lh /backups/2010-10-04_12-14-47
+total 519M
+-rw-r--r-- 1 pekka pekka 347 2010-10-04 12:14 backup-my.cnf
+-rw-r--r-- 1 pekka pekka 18 2010-10-04 12:16 ibbackup_binlog_info
+-rw-r--r-- 1 pekka pekka 158 2010-10-04 12:16 ibbackup_export_variables.txt
+-rw-r----- 1 pekka pekka 1.0K 2010-10-04 12:16 ibbackup_logfile
+-rw-r----- 1 pekka pekka 10M 2010-10-04 12:24 ibdata1
+-rw-r----- 1 pekka pekka 20M 2010-10-04 12:24 ibdata2
+-rw-r----- 1 pekka pekka 458M 2010-10-04 12:24 ibdata3
+-rw-r----- 1 pekka pekka 10M 2010-10-04 12:24 ib_logfile0
+-rw-r----- 1 pekka pekka 10M 2010-10-04 12:24 ib_logfile1
+-rw-r----- 1 pekka pekka 10M 2010-10-04 12:24 ib_logfile2
+-rw-r--r-- 1 pekka pekka 3.2K 2010-10-04 12:24 my.cnf
+drwx------ 2 pekka pekka 4.0K 2010-10-04 12:16 mysql
+drwx------ 2 pekka pekka 24 2010-10-04 12:16 test
</programlisting>
<para>
@@ -2607,80 +2599,75 @@
<literal>/home/pekka/.my.cnf</literal> file):
</para>
-<programlisting>
-$ mysqlbackup --copy-back /home/pekka/.my.cnf /backups/2010-03-02_12-11-58
+<programlisting id="example-5.4b">
+$ mysqlbackup --copy-back /home/pekka/.my.cnf /backups/2010-10-04_12-14-47
+mysqlbackup: Starting mysqlbackup with following arguments:
+mysqlbackup --copy-back /home/pekka/.my.cnf /backups/2010-10-04_12-14-47
-InnoDB Backup Utility v1.7.2
-Copyright (c) 2003, 2010, Oracle and/or its affiliates. All Rights Reserved.
+mysqlbackup: IMPORTANT: Please check that copy-back run completes successfully.
+ At the end of a successful 'copy-back' run mysqlbackup
+ prints "mysqlbackup completed OK!".
-This software is published under
-the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
+mysqlbackup: Starting to copy back files
+mysqlbackup: in '/backups/2010-10-04_12-14-47' directory
+mysqlbackup: back to original data directory '/sqldata/simple'
+mysqlbackup: Copying back file '/backups/2010-10-04_12-14-47/ibbackup_binlog_info'
+mysqlbackup: Copying back file '/backups/2010-10-04_12-14-47/my.cnf'
+mysqlbackup: Copying back directory '/backups/2010-10-04_12-14-47/mysql'
+mysqlbackup: Copying back directory '/backups/2010-10-04_12-14-47/test'
+mysqlbackup: Starting to copy back InnoDB tables and indexes
+mysqlbackup: in '/backups/2010-10-04_12-14-47'
+mysqlbackup: back to original InnoDB datadirectory '/sqldata/simple'
+mysqlbackup: Copying back file '/backups/2010-10-04_12-14-47/ibdata1'
+mysqlbackup: Copying back file '/backups/2010-10-04_12-14-47/ibdata2'
+mysqlbackup: Copying back file '/backups/2010-10-04_12-14-47/ibdata3'
+mysqlbackup: Starting to copy back InnoDB log files
+mysqlbackup: in '/backups/2010-10-04_12-14-47'
+mysqlbackup: back to original InnoDB log directory '/sqldata/simple'
+mysqlbackup: Copying back file '/backups/2010-10-04_12-14-47/ib_logfile0'
+mysqlbackup: Copying back file '/backups/2010-10-04_12-14-47/ib_logfile1'
+mysqlbackup: Copying back file '/backups/2010-10-04_12-14-47/ib_logfile2'
+mysqlbackup: Finished copying backup files.
-IMPORTANT: Please check that the copy-back run completes successfully.
- At the end of a successful copy-back run innobackup
- prints "innobackup completed OK!".
-innobackup: Starting to copy MyISAM tables, indexes,
-innobackup: .ARM, .ARZ, .MRG, .TRG, .TRN, .opt, .frm and .par files
-innobackup: in '/backups/2010-03-02_12-11-58'
-innobackup: back to original data directory '/backups/2009-10-27_16-44-38'
-innobackup: Copying file '/backups/2010-03-02_12-11-58/ibbackup_binlog_info'
-innobackup: Copying file '/backups/2010-03-02_12-11-58/my.cnf'
-innobackup: Copying directory '/backups/2010-03-02_12-11-58/mysql'
-innobackup: Copying directory '/backups/2010-03-02_12-11-58/test'
+101004 12:28:11 mysqlbackup: mysqlbackup completed OK!
-innobackup: Starting to copy InnoDB tables and indexes
-innobackup: in '/backups/2010-03-02_12-11-58'
-innobackup: back to original InnoDB data directory '/backups/2009-10-27_16-44-38'
-innobackup: Copying file '/backups/2010-03-02_12-11-58/ibdata1'
-innobackup: Copying file '/backups/2010-03-02_12-11-58/ibdata2'
-innobackup: Copying file '/backups/2010-03-02_12-11-58/ibdata3'
-
-innobackup: Starting to copy InnoDB log files
-innobackup: in '/backups/2010-03-02_12-11-58'
-innobackup: back to original InnoDB log directory '/backups/2009-10-27_16-44-38'
-innobackup: Copying file '/backups/2010-03-02_12-11-58/ib_logfile0'
-innobackup: Copying file '/backups/2010-03-02_12-11-58/ib_logfile1'
-innobackup: Copying file '/backups/2010-03-02_12-11-58/ib_logfile2'
-innobackup: Finished copying back files.
-
-100302 17:18:13 innobackup: innobackup completed OK!
</programlisting>
<para>
The original database directory is now restored from the backup:
</para>
-<programlisting>
+<programlisting id="example-5.4c">
$ ls -lh /sqldata/simple
-total 175M
--rw-r--r-- 1 pekka pekka 411 2010-03-02 11:32 backup-my.cnf
--rw-r--r-- 1 pekka pekka 1 2009-10-27 16:45 ibbackup_binlog_info
--rw-r----- 1 pekka pekka 10M 2009-10-27 16:45 ibdata1
--rw-r----- 1 pekka pekka 20M 2009-10-27 16:45 ibdata2
--rw-r----- 1 pekka pekka 114M 2009-10-27 16:45 ibdata3
--rw-r----- 1 pekka pekka 10M 2009-10-27 16:45 ib_logfile0
--rw-r----- 1 pekka pekka 10M 2009-10-27 16:45 ib_logfile1
--rw-r----- 1 pekka pekka 10M 2009-10-27 16:45 ib_logfile2
--rw-r--r-- 1 pekka pekka 2.8K 2009-10-27 16:45 my.cnf
--rw-r--r-- 1 pekka pekka 2.5K 2009-09-10 16:36 my.cnf~
-drwx------ 2 pekka pekka 4.0K 2009-10-27 18:31 mysql
-drwx------ 2 pekka pekka 32 2009-09-24 11:13 test
+total 519M
+-rw-r--r-- 1 pekka pekka 411 2010-09-15 11:29 backup-my.cnf
+-rw-r--r-- 1 pekka pekka 18 2010-10-04 12:26 ibbackup_binlog_info
+-rw-r----- 1 pekka pekka 10M 2010-10-04 12:26 ibdata1
+-rw-r----- 1 pekka pekka 20M 2010-10-04 12:26 ibdata2
+-rw-r----- 1 pekka pekka 458M 2010-10-04 12:28 ibdata3
+-rw-r----- 1 pekka pekka 10M 2010-10-04 12:28 ib_logfile0
+-rw-r----- 1 pekka pekka 10M 2010-10-04 12:28 ib_logfile1
+-rw-r----- 1 pekka pekka 10M 2010-10-04 12:28 ib_logfile2
+-rw-r--r-- 1 pekka pekka 3.2K 2010-10-04 12:26 my.cnf
+-rw-r--r-- 1 pekka pekka 2.8K 2009-10-27 16:45 my.cnf~
+drwx------ 2 pekka pekka 4.0K 2010-05-17 18:41 mysql
+drwx------ 2 pekka pekka 808K 2010-03-22 16:13 test
</programlisting>
<para>
and we can start a server on it:
</para>
-<programlisting>
+<programlisting id="example-5.4d">
$ mysqld
-100302 17:18:15 [Warning] Changed limits: max_open_files: 1024 max_connections: 200 table_cache: 407
-100302 17:18:16 [Warning] One can only use the --user switch if running as root
+101004 12:28:16 [Warning] Changed limits: max_open_files: 1024 max_connections: 200 table_cache: 407
+101004 12:28:16 [Warning] One can only use the --user switch if running as root
-100302 17:18:17 [Note] Plugin 'FEDERATED' is disabled.
-100302 17:18:18 InnoDB: Started; log sequence number 0 928223756
-100302 17:18:18 [Note] Event Scheduler: Loaded 0 events
-100302 17:18:18 [Note] mysqld: ready for connections.
+101004 12:28:17 [Note] Plugin 'FEDERATED' is disabled.
+101004 12:28:18 InnoDB: Started; log sequence number 7 2099895820
+101004 12:28:19 [Note] Event Scheduler: Loaded 0 events
+101004 12:28:19 [Note] mysqld: ready for connections.
</programlisting>
</section>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r23171 - trunk/mysql-enterprise-backup-3.5 | john.russell | 18 Oct |
