Mysql 物理備份工具xtrabackup的使用

hunterjoy發表於2015-07-05
MySql
[root@linfytest3 soft]# rpm -ivh percona-xtrabackup-2.2.11-1.el7.x86_64.rpm
warning: percona-xtrabackup-2.2.11-1.el7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Preparing...                          ################################# [100%]
Updating / installing...
   1:percona-xtrabackup-2.2.11-1.el7  ################################# [100%]

[root@linfytest3 /]# xtrabackup  --defaults-file=/var/lib/mysql3306/my.cnf  --user=root --password=111111 --backup --target-dir=/tmp --socket=/tmp/mysql3306.sock
xtrabackup version 2.2.11 based on MySQL server 5.6.24 Linux (x86_64) (revision id: )
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql3306
xtrabackup: open files limit requested 0, set to 4096
xtrabackup: using the following InnoDB configuration:
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 = 31457280
>> log scanned up to (8586398)
xtrabackup: Generating a list of tablespaces
[01] Copying ./ibdata1 to /tmp/ibdata1
[01]        ...done
[01] Copying ./mysql/innodb_table_stats.ibd to /tmp/mysql/innodb_table_stats.ibd
[01]        ...done
[01] Copying ./mysql/innodb_index_stats.ibd to /tmp/mysql/innodb_index_stats.ibd
[01]        ...done
[01] Copying ./mysql/slave_relay_log_info.ibd to /tmp/mysql/slave_relay_log_info.ibd
[01]        ...done
[01] Copying ./mysql/slave_master_info.ibd to /tmp/mysql/slave_master_info.ibd
[01]        ...done
[01] Copying ./mysql/slave_worker_info.ibd to /tmp/mysql/slave_worker_info.ibd
[01]        ...done
[01] Copying ./mysql/xyz.ibd to /tmp/mysql/xyz.ibd
[01]        ...done
[01] Copying ./mysql/linfy_v5.ibd to /tmp/mysql/linfy_v5.ibd
[01]        ...done
[01] Copying ./test/test.ibd to /tmp/test/test.ibd
[01]        ...done
[01] Copying ./test/ipaddr.ibd to /tmp/test/ipaddr.ibd
[01]        ...done
[01] Copying ./linfy/dou.ibd to /tmp/linfy/dou.ibd
[01]        ...done
[01] Copying ./linfy/tian.ibd to /tmp/linfy/tian.ibd
[01]        ...done
[01] Copying ./linfy/AI.ibd to /tmp/linfy/AI.ibd
[01]        ...done
[01] Copying ./linfy/AII.ibd to /tmp/linfy/AII.ibd
[01]        ...done
[01] Copying ./linfy/AQQ.ibd to /tmp/linfy/AQQ.ibd
[01]        ...done
[01] Copying ./linfy/t1.ibd to /tmp/linfy/t1.ibd
[01]        ...done
[01] Copying ./linfy/t2.ibd to /tmp/linfy/t2.ibd
[01]        ...done
[01] Copying ./linfy/t3.ibd to /tmp/linfy/t3.ibd
[01]        ...done
[01] Copying ./tiandou/taintian.ibd to /tmp/tiandou/taintian.ibd
[01]        ...done
[01] Copying ./tiandou/doudou.ibd to /tmp/tiandou/doudou.ibd
[01]        ...done
[01] Copying ./tiandou/linfy.ibd to /tmp/tiandou/linfy.ibd
[01]        ...done
[01] Copying ./tiandou/device.ibd to /tmp/tiandou/device.ibd
[01]        ...done
[01] Copying ./tiandou/autoincre_demo.ibd to /tmp/tiandou/autoincre_demo.ibd
[01]        ...done
>> log scanned up to (8586398)
xtrabackup: The latest check point (for incremental): '8586398'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (8586398)

xtrabackup: Transaction log of lsn (8586398) to (8586398) was copied.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/543979/viewspace-1723326/，如需轉載，請註明出處，否則將追究法律責任。

相關文章