Innobackupex record details of different backup methods

Detailed records of innobackupex different backup methods [html] common backup mode [root @ Slave02 tmp] # innobackupex -- database = "inno test" -- user = root -- password = root -- no-lock -- defaults-file =/etc/my. cnf/data0/backup/mysql 2>/tmp/mysqlbackup. log xtrabackup_55 version 1.6.2 for MySQL server 5.5.10 Linux (i686) (revision id: undefined) [01] Copying. /ibdata1 to/data0/backup/mysql/2013-03-28_10-10-45/ibdata1 [01]... done [01] Copying. /inno/m M. ibd to/data0/backup/mysql/2013-03-28_10-10-45/inno/mm. ibd [01]... done [01] Copying. /inno/t. ibd to/data0/backup/mysql/2013-03-28_10-10-45/inno/t. ibd [01]... done xtrabackup: The latest check point (for incremental): '000000' xtrabackup: Stopping log copying thread. xtrabackup: Transaction log of lsn (893330831) to (893330831) was copied. [root @ Slave02 tmp] # Note: Use the root user of mysql The backup path of est is/data0/backup/mysql /. After the backup is successful, the backup directory with the timestamp name will be created under this directory. The no-lock parameter is used to specify that the table is not locked during Backup. 2>/tmp/mysqlbackup. log stores the output information in the backup process to/tmp/mysqlbackup. [root @ Slave02 tmp] # cd/data0/backup/mysql/--- verify the backup file [root @ Slave02 mysql] # ll total 20 drwxr-xr-x 4 root 4096 Mar 28 2013-03-28_10-10-45-rw-r -- 1 root 83 Mar 28 stderr-rw-r -- 1 root 0 Mar 28 stdout [root @ Slave02 mysql] # cd 2013-03-28_10-10-45/[root @ Slave02 2013-03-28_10-10-45] # ll total 469520-r W-r -- 1 root 363 Mar 28 backup-my.cnf-rw-r -- 1 root 480247808 Mar 28 ibdata1 drwx ------ 2 root 4096 Mar 28 inno- rw-r -- 1 root 0 Mar 28 mysql-stderr-rw-r -- 1 root 76 Mar 28 mysql-stdout drwxr-xr-x 2 root root 4096 Mar 28 test-rw-r -- 1 root 13 Mar 28 xtrabackup_binary-rw-r -- 1 root 81 Mar 28 xtr Abackup_checkpoints-rw-r -- 1 root 2560 Mar 28 xtrabackup_logfile [root @ Slave02 2013-03-28_10-10-45] # cd inno/[root @ Slave02 inno] # ll total 2096-rw-r ----- 1 mysql 8554 Mar 27mm. frm-rw-r -- 1 root 1048576 Mar 28 10:11mm. ibd-rw-r ----- 1 mysql 8554 Mar 27 t. frm-rw-r -- 1 root 1048576 Mar 28 t. ibd [root @ Slave02 inno] # [root @ Slave02 tmp] # Cat mysqlbackup. log ---- detailed process of viewing Backup records InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003,200 9 Innobase Oy and Percona Inc 2009-2011. all Rights Reserved. this software is published under the gnu general public license Version 2, June 1991. 130328 10:10:39 innobackupex: Starting mysql with options: -- defaults-file = '/etc/my. cnf '-- password = 'root' -- user = 'root' -- unbuffered -- 130328 10:10:39 in Nobackupex: Connected to database with mysql child process (pid = 3714) 130328 10:10:45 innobackupex: Connection to database server closed IMPORTANT: Please check that the backup run completes successfully. at the end of a successful backup run innobackupex prints "completed OK! ". Innobackupex: Using mysql Ver 14.14 Distrib 5.5.13, for Linux (i686) using readline 5.1 innobackupex: Using mysql server version Copyright (c) 2000,201 0, Oracle and/or its affiliates. all rights reserved. innobackupex: Created backup directory/data0/backup/mysql/2013-03-28_10-10-45 130328 10:10:45 innobackupex: Starting mysql with options: -- defaults-file = '/etc/my. cnf '-- password = 'root' -- user = 'Root' -- unbuffered -- 130328 10:10:45 innobackupex: Connected to database with mysql child process (pid = 3742) 130328 10:10:49 innobackupex: Connection to database server closed 130328 10:10:49 innobackupex: starting ibbackup with command: xtrabackup_55 -- defaults-file = "/etc/my. cnf "-- backup -- suspend-at-end -- target-dir =/data0/backup/mysql/2013-03-28_10-10-45 innobackupex: Waiting for ibbackup (Pid = 3754) to suspend innobackupex: Suspend file '/data0/backup/mysql/2013-03-28_10-10-45/xtrabackup_suincluded' xtrabackup: uses posix_fadvise (). xtrabackup: cd to/usr/local/mysql/data xtrabackup: Target instance is assumed as followings. xtrabackup: innodb_data_home_dir =. /xtrabackup: innodb_data_file_path = ibdata1: 10 M: autoextend xtrabackup: innodb_log_group_home_dir =. /xtrabackup: innodb_lo G_files_in_group = 2 xtrabackup: innodb_log_file_size = 5242880 130328 10:10:49 InnoDB: Using Linux native AIO 130328 10:10:50 InnoDB: Warning: allocated tablespace 2, old maximum was 0> log scanned up to (893330831)> log scanned up to (893330831)> log scanned up to (893330831) 130328 10:11:03 innobackupex: continuing after ibbackup has susponded 130328 10:11:03 innobackupex: Starting mysql With options: -- defaults-file = '/etc/my. cnf '-- password = 'root' -- user = 'root' -- unbuffered -- 130328 10:11:04 innobackupex: Connected to database with mysql child process (pid = 3770)> log scanned up to (893330831) 130328 10:11:08 innobackupex: Starting to backup. frm ,. MRG ,. MYD ,. MYI, innobackupex :. TRG ,. TRN ,. ARM ,. ARZ ,. CSM ,. CSV and. opt files in innobackupex: subdirectories of '/usr/local/mys Ql/data 'innobackupex: Backing up file'/usr/local/mysql/data/inno/mm. frm 'innobackupex: Backing up file'/usr/local/mysql/data/inno/t. frm 'innobackupex: Backing up files'/usr/local/mysql/data/test /*. {frm, MYD, MYI, MRG, TRG, TRN, ARM, ARZ, CSM, CSV, opt, par} '(19 files) 130328 10:11:08 innobackupex: Finished backing up. frm ,. MRG ,. MYD ,. MYI ,. TRG ,. TRN ,. ARM ,. ARZ ,. CSV ,. CSM and. opt files innobackupex: Resuming ibbackup> log scanned up to (893330831) 130328 10:11:09 innobackupex: Connection to database server closed innobackupex: Backup created in directory '/data0/backup/mysql/2013-03-28_10-10-45' 130328 10:11:09 innobackupex: completed OK! [Root @ Slave02 tmp] # compressing backup; [root @ Slave02 inno] # innobackupex -- database = "inno test" -- user = root -- password = root -- no-lock -- defaults-file =/etc/my. cnf -- stream = tar/data0/backup/mysql 2>/tmp/mysqlbackup. log | zip>/data0/backup/mysql/mike.tar.gz adding:-(deflated 63%) you have new mail in/var/spool/mail/root [root @ Slave02 inno] # [root @ Slave02 mysql] # ls 2013-03-28_10-10-45 mike.tar.gz stderr stdout logs [root @ Slave02 mysql] # ll total 176004 drwxr-xr-x 4 root 4096 Mar 28 2013-03-28_10-10-45-rw-r -- 1 root 180012554 Mar 28 03 mike.tar.gz-rw-r -- 1 root root 83 Mar 28 stderr-rw-r -- 1 root 0 Mar 28 stdout-rw-r -- 1 root 13 Mar 28 xtrabackup_binary [root @ Slave02 mysql] # ll-la total 176020 drwxr-xr-x 3 root 4096 Mar 28. drwxr-xr-x 3 root 4096 Mar 28 .. drwxr-xr-x 4 root 4096 Mar 28 2013-03-28_10-10-45-rw-r -- 1 root 180012554 Mar 28 03 mike.tar.gz-rw-r -- 1 root 83 Mar 28 stderr-rw-r -- 1 root 0 Mar 28 stdout-rw-r -- 1 root 13 Mar 28 xtrabackup_binary [root @ Slave02 mysql] #