#innobackupex --user=root --password=root --host=172.17.210.112 --parallel=4 --throttle=400 --stream=tar /home 2>/home/bakup.log 1>/home/allbakup.tar

[root@ykt ~]# innobackupex --user=root --defaults-file=/etc/my.cnf --host=192.168.0.200 --parallel=2 --throttle=400 --databases=yktgl /home

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

150113 14:15:30 innobackupex: Starting mysql with options: --defaults-file='/etc/my.cnf' --user='root' --host='192.168.0.200' --unbuffered --
150113 14:15:30 innobackupex: Connected to database with mysql child process (pid=3410)
150113 14:15:36 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.23, for Linux (i686) using readline 5.1
innobackupex: Using mysql server version Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

innobackupex: Created backup directory /home/2015-01-13_14-15-36
150113 14:15:36 innobackupex: Starting mysql with options: --defaults-file='/etc/my.cnf' --user='root' --host='192.168.0.200' --unbuffered --
150113 14:15:36 innobackupex: Connected to database with mysql child process (pid=3438)
150113 14:15:41 innobackupex: Connection to database server closed

150113 14:15:41 innobackupex: Starting ibbackup with command: xtrabackup_55 --defaults-file="/etc/my.cnf" --backup --suspend-at-end --target-dir=/home/2015-01-13_14-15-36 --throttle=400 --parallel=2
innobackupex: Waiting for ibbackup (pid=3449) to suspend
innobackupex: Suspend file '/home/2015-01-13_14-15-36/xtrabackup_suspended'

xtrabackup_55 Ver 1.6 Rev undefined for 5.5.9 Linux (i686)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
xtrabackup: Target instance is assumed as followings.
xtrabackup:   innodb_data_home_dir = ./
xtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup:   innodb_log_group_home_dir = ./
xtrabackup:   innodb_log_files_in_group = 2
xtrabackup:   innodb_log_file_size = 5242880
150113 14:15:41 InnoDB: Using Linux native AIO
>> log scanned up to (1077419713)
xtrabackup: Starting 2 threads for parallel data files transfer
[01] Copying ./ibdata1
     to /home/2015-01-13_14-15-36/ibdata1
[01]        ...done
>> log scanned up to (1077419713)

150113 14:15:47 innobackupex: Continuing after ibbackup has suspended
150113 14:15:47 innobackupex: Starting mysql with options: --defaults-file='/etc/my.cnf' --user='root' --host='192.168.0.200' --unbuffered --
150113 14:15:47 innobackupex: Connected to database with mysql child process (pid=3466)
150113 14:15:51 innobackupex: Starting to lock all tables...
>> log scanned up to (1077419713)
>> log scanned up to (1077419713)
150113 14:16:01 innobackupex: All tables locked and flushed to disk

150113 14:16:01 innobackupex: Starting to backup .frm, .MRG, .MYD, .MYI,
innobackupex: .TRG, .TRN, .ARM, .ARZ, .CSM, .CSV and .opt files in
innobackupex: subdirectories of '/var/lib/mysql'
innobackupex: Backing up files '/var/lib/mysql/yktgl/*.{frm,MYD,MYI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (231 files)
>> log scanned up to (1077419713)
150113 14:16:01 innobackupex: Finished backing up .frm, .MRG, .MYD, .MYI, .TRG, .TRN, .ARM, .ARZ, .CSV, .CSM and .opt files

innobackupex: Resuming ibbackup

xtrabackup: The latest check point (for incremental): '1077419713'
>> log scanned up to (1077419713)
xtrabackup: Stopping log copying thread.
xtrabackup: Transaction log of lsn (1077419399) to (1077419713) was copied.
150113 14:16:04 innobackupex: All tables unlocked
150113 14:16:04 innobackupex: Connection to database server closed

innobackupex: Backup created in directory '/home/2015-01-13_14-15-36'
innobackupex: MySQL binlog position: filename 'mysql-bin.000181', position 4991
150113 14:16:04 innobackupex: completed OK!

xtrabackup_55 Ver 1.6 Rev undefined for 5.5.9 Linux (i686)
xtrabackup: cd to /home/2015-01-13_13-18-51
xtrabackup: This target seems to be already prepared.
xtrabackup: notice: xtrabackup_logfile was already used to '--prepare'.
xtrabackup: Temporary instance for recovery is set as followings.
xtrabackup:   innodb_data_home_dir = ./
xtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup:   innodb_log_group_home_dir = ./
xtrabackup:   innodb_log_files_in_group = 2
xtrabackup:   innodb_log_file_size = 5242880
150113 13:59:54 InnoDB: Using Linux native AIO
xtrabackup: Starting InnoDB instance for recovery.
xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
150113 13:59:54 InnoDB: The InnoDB memory heap is disabled
150113 13:59:54 InnoDB: Mutexes and rw_locks use InnoDB's own implementation
150113 13:59:54 InnoDB: Compressed tables use zlib 1.2.3
150113 13:59:54 InnoDB: Using Linux native AIO
150113 13:59:54 InnoDB: Warning: innodb_file_io_threads is deprecated. Please use innodb_read_io_threads and innodb_write_io_threads instead
150113 13:59:54 InnoDB: Initializing buffer pool, size = 100.0M
150113 13:59:54 InnoDB: Completed initialization of buffer pool
150113 13:59:54 InnoDB: highest supported file format is Barracuda.
150113 13:59:54 InnoDB: Waiting for the background threads to start
150113 13:59:55 Percona XtraDB () 1.1.5-20.0 started; log sequence number 1077412369

[notice (again)]
If you use binary log and don't use any hack of group commit,
the binary log position seems to be:
InnoDB: Last MySQL binlog file position 0 43380, file name ./mysql-bin.000180

xtrabackup: starting shutdown with innodb_fast_shutdown = 1
150113 13:59:55 InnoDB: Starting shutdown...
150113 14:00:00 InnoDB: Shutdown completed; log sequence number 1077413135
150113 14:00:00 innobackupex: completed OK!

[root@ykt ~]#service mysql stop #停止mysql資料庫服務
[
root@ykt ~]#mv /var/lib/mysql/yktgl /var/lib/mysql/yktglbak #備份原來資料

[root@ykt ~]# innobackupex --user=root --databases=yktgl --apply-log /home/2015-01-13_13-18-51/ #恢復備份日誌

[root@ykt ~]# innobackupex --user=root --databases=yktgl --copy-back /home/2015-01-13_13-18-51/ #開始複製日誌檔案

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

IMPORTANT: Please check that the copy-back run completes successfully.
At the end of a successful copy-back run innobackupex
prints "completed OK!".

innobackupex: Starting to copy MyISAM tables, indexes,
innobackupex: .MRG, .TRG, .TRN, .ARM, .ARZ, .CSM, .CSV, .opt, and .frm files
innobackupex: in '/home/2015-01-13_13-18-51'
innobackupex: back to original data directory '/var/lib/mysql'
innobackupex: Copying file '/home/2015-01-13_13-18-51/xtrabackup_checkpoints'
innobackupex: Copying file '/home/2015-01-13_13-18-51/xtrabackup_binlog_info'
innobackupex: Copying directory '/home/2015-01-13_13-18-51/yktgl'
innobackupex: Copying file '/home/2015-01-13_13-18-51/xtrabackup_binlog_pos_innodb'
innobackupex: Copying file '/home/2015-01-13_13-18-51/xtrabackup_binary'

innobackupex: Starting to copy InnoDB tables and indexes
innobackupex: in '/home/2015-01-13_13-18-51'
innobackupex: back to original InnoDB data directory '/var/lib/mysql'
innobackupex: Copying file '/home/2015-01-13_13-18-51/ibdata1'

innobackupex: Starting to copy InnoDB log files
innobackupex: in '/home/2015-01-13_13-18-51'
innobackupex: back to original InnoDB log directory '/var/lib/mysql'
innobackupex: Copying file '/home/2015-01-13_13-18-51/ib_logfile0'
innobackupex: Copying file '/home/2015-01-13_13-18-51/ib_logfile1'
innobackupex: Finished copying back files.

[root@ykt mysql]# pwd
/var/lib/mysql
[root@ykt mysql]# chown -R mysql:mysql yktgl
[root@ykt mysql]# pwd
/var/lib/mysql
[root@ykt mysql]# chown mysql:mysql mysql
mysql目錄沒有許可權建立ibdata1檔案
[root@ykt ~]# service mysql start #啟動資料庫服務

innobackupex備份恢復實戰

相關文章