Xtrabackup备份恢复常用命令与压缩测试

最新推荐文章于 2024-06-01 15:29:46 发布
最新推荐文章于 2024-06-01 15:29:46 发布
阅读量2k 收藏
点赞数
分类专栏： MySQL数据库 文章标签： mysql 备份 压缩
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/yumushui/article/details/39029335
版权




一、使用全库备份和恢复的过程：


使用innobackupex进行全库备份的命令：

$ innobackupex --defaults-file=/data/mysqldata/3306/my.cnf --user=xtrabk --password='onlybackup' /data/mysqldata/backup 

innobackupex --defaults-file=/data/mysqldata/3306/my.cnf --user=xtrabk --password='onlybackup' /data/mysqldata/backup

备份后检验备份文件

$ ll /data/mysqldata/backup/2014-09-02_14-15-45


使用全库备份进行恢复的命令(建议执行两次)：
$ innobackupex --defaults-file=/data/mysqldata/backup/my-3308.cnf --apply-log  /data/mysqldata/backup/2014-09-02_14-15-45  
innobackupex --defaults-file=/data/mysqldata/backup/my-3308.cnf --apply-log  /data/mysqldata/backup/2014-09-02_14-15-45

$ innobackupex --defaults-file=/data/mysqldata/backup/my-3308.cnf --apply-log  /data/mysqldata/backup/2014-09-02_14-15-45 


恢复和启动mysql服务：

拷贝配置文件到指定位置

cp /data/mysqldata/backup/my-3308.cnf /data/mysqldata/3308/my.cnf
使用命令启动恢复后的mysql服务

/usr/local/mysql/bin/mysqld_safe --defaults-file=/data/mysqldata/3308/my.cnf &

/usr/local/mysql/bin/mysqld_safe --defaults-file=/data/mysqldata/3308/my.cnf &


全库备份后恢复过程：

进行恢复准备
$ innobackupex --defaults-file=/data/mysqldata/backup/my-3308.cnf --apply-log /data/mysqldata/backup/2014-09-02_14-15-45 

innobackupex --defaults-file=/data/mysqldata/backup/my-3308.cnf --apply-log /data/mysqldata/backup/2014-09-02_14-15-45
进行文件恢复
$ innobackupex --defaults-file=/data/mysqldata/backup/my-3308.cnf --copy-back /data/mysqldata/backup/2014-09-02_14-15-45  

innobackupex --defaults-file=/data/mysqldata/backup/my-3308.cnf --copy-back /data/mysqldata/backup/2014-09-02_14-15-45

准备配置文件并启动数据库服务：

准备配置文件到指定位置
cp /data/mysqldata/backup/my-3308.cnf /data/mysqldata/3308/my.cnf
使用命令启动数据库服务
$ /usr/local/mysql/bin/mysqld_safe --defaults-file=/data/mysqldata/3308/my.cnf &

/usr/local/mysql/bin/mysqld_safe --defaults-file=/data/mysqldata/3308/my.cnf &


二、使用全库+增量进行备份和恢复的过程：

使用innobackupex进行全库备份的命令：
$ innobackupex --defaults-file=/data/mysqldata/3306/my.cnf --user=xtrabk --password='onlybackup' /data/mysqldata/backup 

innobackupex --defaults-file=/data/mysqldata/3306/my.cnf --user=xtrabk --password='onlybackup' /data/mysqldata/backup
全库备份后，建议备份文件
$ ll /data/mysqldata/backup/2014-09-02_14-15-45


使用innobackupex进行增量备份的命令：
$ innobackupex --defaults-file=/data/mysqldata/3306/my.cnf --user=xtrabk --password='onlybackup' --incremental --incremental-basedir=/data/mysqldata/backup/2014-09-02_14-15-45 /data/mysqldata/backup_rec   
innobackupex --defaults-file=/data/mysqldata/3306/my.cnf --user=xtrabk --password='onlybackup' --incremental --incremental-basedir=/data/mysqldata/backup/2014-09-02_14-15-45 /data/mysqldata/backup_rec
增量备份后，建议确认增量备份文件
$ ll /data/mysqldata/backup_rec/2014-09-02_14-40-18

全库备份后恢复过程：

进行全库备份恢复准备

$ innobackupex --defaults-file=/data/mysqldata/backup/my-3308.cnf --apply-log --redo-only /data/mysqldata/backup/2014-09-02_14-15-45  

 innobackupex --defaults-file=/data/mysqldata/backup/my-3308.cnf --apply-log --redo-only /data/mysqldata/backup/2014-09-02_14-15-45

进行增量备份恢复准备

$ innobackupex --defaults-file=/data/mysqldata/backup/my-3308.cnf --apply-log /data/mysqldata/backup/2014-09-02_14-15-45 --incremental-dir=/data/mysqldata/backup_rec/2014-09-02_14-40-18   

innobackupex --defaults-file=/data/mysqldata/backup/my-3308.cnf --apply-log /data/mysqldata/backup/2014-09-02_14-15-45 --incremental-dir=/data/mysqldata/backup_rec/2014-09-02_14-40-18

进行文件拷贝

$ innobackupex --defaults-file=/data/mysqldata/backup/my-3308.cnf --copy-back /data/mysqldata/backup/2014-09-02_14-15-45   
innobackupex --defaults-file=/data/mysqldata/backup/my-3308.cnf --copy-back /data/mysqldata/backup/2014-09-02_14-15-45


准备配置文件并启动数据库服务：

准备配置文件到指定位置
cp /data/mysqldata/backup/my-3308.cnf /data/mysqldata/3308/my.cnf
使用命令启动数据库服务
$ /usr/local/mysql/bin/mysqld_safe --defaults-file=/data/mysqldata/3308/my.cnf &

/usr/local/mysql/bin/mysqld_safe --defaults-file=/data/mysqldata/3308/my.cnf &


三、使用打包+压缩的方式进行备份和恢复
使用打包的命令进行mysql备份并打包和压缩的命令为：

$ innobackupex --defaults-file=/data/mysqldata/3306/my.cnf --user=xtrabk --password='onlybackup'  --stream=tar /tmp | gzip -> /data/mysqldata/backup/test/xtra_fullbackup0903.tar.gz 

 innobackupex --defaults-file=/data/mysqldata/3306/my.cnf --user=xtrabk --password='onlybackup'  --stream=tar /tmp | gzip -> /data/mysqldata/backup/test/xtra_fullbackup0903.tar.gz


解压缩命令为：
解压缩的命令需要先加-i参数，将备份文件解压到当前目录：

$  tar xvzfi xtra_fullbackup0903.tar.gz 

 tar xvzfi xtra_fullbackup0903.tar.gz


解压到指定文件：

$  tar xvzfi xtra_fullbackup0903.tar.gz  -C /data/mysqldata/backup/test/backup0903

 tar xvzfi xtra_fullbackup0903.tar.gz  -C /data/mysqldata/backup/test/backup0903

打包压缩备份与一般备份的文件大小对比：

$ du -sh /data/mysqldata/backup/xtra_fullbackup0903.tar.gz
4.4M    /data/mysqldata/backup/xtra_fullbackup0903.tar.gz

$ 
$ du -sh /data/mysqldata/backup/2014-09-02_14-15-45 
2.8G    /data/mysqldata/backup/2014-09-02_14-15-45
$ 

打包压缩备份解压前后大小对比：

# du -sh backup0903 
2.1G    backup0903

# du -sh xtra_fullbackup0903.tar.gz
4.5M    xtra_fullbackup0903.tar.gz


使用打包压缩方式备份mysql数据库的过程为：

$ innobackupex --defaults-file=/data/mysqldata/3306/my.cnf --user=xtrabk --password='onlybackup'  --stream=tar /tmp | gzip -> /data/mysqldata/backup/xtra_fullbackup0903.tar.gz 

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Ireland Ltd 2009-2012.  All Rights Reserved.

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

140903 15:47:49  innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/data/mysqldata/3306/my.cnf;mysql_read_default_group=xtrabackup' as 'xtrabk'  (using password: YES).
140903 15:47:49  innobackupex: Connected to MySQL server
IMPORTANT: Please check that the backup run completes successfully.
           At the end of a successful backup run innobackupex
           prints "completed OK!".

innobackupex: Using mysql server version 5.6.16-log

innobackupex: Created backup directory /tmp

140903 15:47:50  innobackupex: Starting ibbackup with command: xtrabackup_56  --defaults-file="/data/mysqldata/3306/my.cnf"  --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/data/mysqldata/3306/tmp --tmpdir=/data/mysqldata/3306/tmp --stream=tar
innobackupex: Waiting for ibbackup (pid=17572) to suspend
innobackupex: Suspend file '/data/mysqldata/3306/tmp/xtrabackup_suspended_2'

xtrabackup_56 version 2.1.2 for MySQL server 5.6.10 Linux (x86_64) (revision id: 611)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /data/mysqldata/3306/data
xtrabackup: Target instance is assumed as followings.
xtrabackup:   innodb_data_home_dir = ./
xtrabackup:   innodb_data_file_path = ibdata1:2048M:autoextend
xtrabackup:   innodb_log_group_home_dir = ./
xtrabackup:   innodb_log_files_in_group = 3
xtrabackup:   innodb_log_file_size = 268435456
InnoDB: Allocated tablespace 363, old maximum was 0
>> log scanned up to (29595814)
[01] Streaming ./ibdata1
>> log scanned up to (29595814)
>> log scanned up to (29595814)
>> log scanned up to (29595814)
>> log scanned up to (29595814)
>> log scanned up to (29595814)
>> log scanned up to (29595814)
>> log scanned up to (29595814)
>> log scanned up to (29595814)
>> log scanned up to (29595814)
>> log scanned up to (29596251)
>> log scanned up to (29596251)
>> log scanned up to (29596251)
>> log scanned up to (29596251)
>> log scanned up to (29596251)
>> log scanned up to (29596251)
>> log scanned up to (29596251)
>> log scanned up to (29596251)
>> log scanned up to (29596251)
>> log scanned up to (29596251)
>> log scanned up to (29596688)
>> log scanned up to (29596688)
>> log scanned up to (29596688)
>> log scanned up to (29596688)
>> log scanned up to (29596688)
>> log scanned up to (29596688)
>> log scanned up to (29597546)
>> log scanned up to (29597546)
>> log scanned up to (29597546)
>> log scanned up to (29597546)
>> log scanned up to (29597546)
>> log scanned up to (29597876)
>> log scanned up to (29598001)
>> log scanned up to (29598001)
>> log scanned up to (29598001)
>> log scanned up to (29598001)
>> log scanned up to (29598001)
>> log scanned up to (29598001)
>> log scanned up to (29598001)
>> log scanned up to (29598001)
>> log scanned up to (29598001)
>> log scanned up to (29598331)
>> log scanned up to (29598438)
>> log scanned up to (29598438)
>> log scanned up to (29598438)
>> log scanned up to (29598438)
>> log scanned up to (29598438)
>> log scanned up to (29598438)
>> log scanned up to (29598438)
>> log scanned up to (29598438)
>> log scanned up to (29598438)
>> log scanned up to (29598768)
>> log scanned up to (29598875)
>> log scanned up to (29598875)
>> log scanned up to (29598875)
>> log scanned up to (29598875)
>> log scanned up to (29598875)
>> log scanned up to (29599189)
>> log scanned up to (29599312)
>> log scanned up to (29599312)
>> log scanned up to (29599312)
>> log scanned up to (29599312)
>> log scanned up to (29599626)
>> log scanned up to (29599733)
>> log scanned up to (29599733)
>> log scanned up to (29599733)
>> log scanned up to (29599733)
>> log scanned up to (29599733)
>> log scanned up to (29599733)
>> log scanned up to (29599733)
>> log scanned up to (29599733)
>> log scanned up to (29599733)
>> log scanned up to (29600063)
>> log scanned up to (29600170)
>> log scanned up to (29600170)
>> log scanned up to (29600170)
>> log scanned up to (29600170)
>> log scanned up to (29600170)
>> log scanned up to (29600170)
>> log scanned up to (29600170)
>> log scanned up to (29600170)
>> log scanned up to (29600170)
>> log scanned up to (29600500)
>> log scanned up to (29600607)
>> log scanned up to (29600607)
>> log scanned up to (29600607)
>> log scanned up to (29600607)
>> log scanned up to (29600607)
>> log scanned up to (29600937)
>> log scanned up to (29601710)
>> log scanned up to (29601832)
>> log scanned up to (29601832)
>> log scanned up to (29601832)
>> log scanned up to (29601832)
>> log scanned up to (29602146)
>> log scanned up to (29602253)
>> log scanned up to (29602253)
>> log scanned up to (29602253)
[01]        ...done
[01] Streaming ./wikidb/EXTRNLNKS.ibd
[01]        ...done
[01] Streaming ./wikidb/KEYSTORE.ibd
[01]        ...done
[01] Streaming ./wikidb/CONTENTPROPERTIES.ibd
[01]        ...done
[01] Streaming ./wikidb/NOTIFICATIONS.ibd
[01]        ...done
[01] Streaming ./wikidb/AO_EF9604_FEATURE_DISCOVERY.ibd
[01]        ...done
[01] Streaming ./wikidb/OS_PROPERTYENTRY.ibd
>> log scanned up to (29602253)
[01]        ...done
[01] Streaming ./wikidb/DECORATOR.ibd
[01]        ...done
[01] Streaming ./wikidb/ATTACHMENTS.ibd
[01]        ...done
[01] Streaming ./wikidb/AO_21D670_WHITELIST_RULES.ibd
[01]        ...done
[01] Streaming ./wikidb/AO_5F3884_FEATURE_DISCOVERY.ibd
[01]        ...done
[01] Streaming ./wikidb/AO_A0B856_WEB_HOOK_LISTENER_AO.ibd
[01]        ...done
[01] Streaming ./wikidb/CONTENT_PERM_SET.ibd
[01]        ...done
[01] Streaming ./wikidb/AO_187CCC_SIDEBAR_LINK.ibd
[01]        ...done
[01] Streaming ./wikidb/AO_9412A1_AOUSER.ibd
[01]        ...done
[01] Streaming ./wikidb/IMAGEDETAILS.ibd
[01]        ...done
[01] Streaming ./wikidb/LABEL.ibd
[01]        ...done
[01] Streaming ./wikidb/AO_54C900_C_TEMPLATE_REF.ibd
[01]        ...done
[01] Streaming ./wikidb/PLUGINDATA.ibd
[01]        ...done
[01] Streaming ./wikidb/AO_9412A1_AOREGISTRATION.ibd
[01]        ...done
[01] Streaming ./wikidb/CONTENT_PERM.ibd
[01]        ...done
[01] Streaming ./wikidb/INDEXQUEUEENTRIES.ibd
[01]        ...done
[01] Streaming ./wikidb/CONTENT.ibd
[01]        ...done
[01] Streaming ./wikidb/AO_54C900_SPACE_BLUEPRINT_AO.ibd
[01]        ...done
[01] Streaming ./wikidb/PAGETEMPLATES.ibd
[01]        ...done
[01] Streaming ./wikidb/AO_9412A1_AOTASK.ibd
[01]        ...done
[01] Streaming ./wikidb/ATTACHMENTDATA.ibd
[01]        ...done
[01] Streaming ./wikidb/AO_9412A1_AONOTIFICATION.ibd
[01]        ...done
[01] Streaming ./wikidb/AO_54C900_CONTENT_BLUEPRINT_AO.ibd
[01]        ...done
[01] Streaming ./wikidb/CONFVERSION.ibd
>> log scanned up to (29602253)
[01]        ...done
[01] Streaming ./wikidb/AO_38321B_CUSTOM_CONTENT_LINK.ibd
[01]        ...done
[01] Streaming ./wikidb/AO_92296B_AORECENTLY_VIEWED.ibd
[01]        ...done
[01] Streaming ./wikidb/LIKES.ibd
[01]        ...done
[01] Streaming ./wikidb/AO_6384AB_FEATURE_METADATA_AO.ibd
[01]        ...done
[01] Streaming ./wikidb/AO_DC98AE_AOHELP_TIP.ibd
[01]        ...done
[01] Streaming ./wikidb/CONTENT_LABEL.ibd
[01]        ...done
[01] Streaming ./wikidb/LINKS.ibd
[01]        ...done
[01] Streaming ./wikidb/AO_42E351_HEALTH_CHECK_ENTITY.ibd
[01]        ...done
[01] Streaming ./wikidb/FOLLOW_CONNECTIONS.ibd
[01]        ...done
[01] Streaming ./wikidb/CLUSTERSAFETY.ibd
[01]        ...done
[01] Streaming ./wikidb/CONFANCESTORS.ibd
[01]        ...done
[01] Streaming ./wikidb/BODYCONTENT.ibd
[01]        ...done
[01] Streaming ./wikidb/BANDANA.ibd
[01]        ...done
[01] Streaming ./wikidb/AO_9412A1_USER_APP_LINK.ibd
[01]        ...done
[01] Streaming ./test/t1.ibd
[01]        ...done
[01] Streaming ./test/t2.ibd
[01]        ...done
[01] Streaming ./test/jw_resource.ibd
[01]        ...done
[01] Streaming ./test/deposit_coin.ibd
[01]        ...done
[01] Streaming ./test/t4.ibd
[01]        ...done
[01] Streaming ./test/t3.ibd
[01]        ...done
[01] Streaming ./test/t5.ibd
[01]        ...done
[01] Streaming ./test/admin_action_log.ibd
[01]        ...done
[01] Streaming ./test/admin_browse_log.ibd
[01]        ...done
[01] Streaming ./huobi@002dus/test_01.ibd
[01]        ...done
[01] Streaming ./huobi@002dus/admin_action_log.ibd
[01]        ...done
[01] Streaming ./huobi@002dus/admin_browse_log.ibd
[01]        ...done
[01] Streaming ./mysql/slave_worker_info.ibd
[01]        ...done
[01] Streaming ./mysql/slave_master_info.ibd
[01]        ...done
[01] Streaming ./mysql/innodb_table_stats.ibd
[01]        ...done
[01] Streaming ./mysql/innodb_index_stats.ibd
[01]        ...done
[01] Streaming ./mysql/slave_relay_log_info.ibd
[01]        ...done
[01] Streaming ./zabbixdb/sysmaps.ibd
[01]        ...done
[01] Streaming ./zabbixdb/hosts_groups.ibd
[01]        ...done
[01] Streaming ./zabbixdb/triggers.ibd
[01]        ...done
[01] Streaming ./zabbixdb/group_discovery.ibd
[01]        ...done
[01] Streaming ./zabbixdb/actions.ibd
[01]        ...done
[01] Streaming ./zabbixdb/dbversion.ibd
[01]        ...done
[01] Streaming ./zabbixdb/history_sync.ibd
[01]        ...done
[01] Streaming ./zabbixdb/functions.ibd
[01]        ...done
[01] Streaming ./zabbixdb/config.ibd
[01]        ...done
[01] Streaming ./zabbixdb/scripts.ibd
[01]        ...done
[01] Streaming ./zabbixdb/dhosts.ibd
[01]        ...done
[01] Streaming ./zabbixdb/history_uint.ibd
[01]        ...done
[01] Streaming ./zabbixdb/proxy_history.ibd
[01]        ...done
[01] Streaming ./zabbixdb/opcommand_grp.ibd
[01]        ...done
[01] Streaming ./zabbixdb/httptest.ibd
[01]        ...done
[01] Streaming ./zabbixdb/items.ibd
[01]        ...done
[01] Streaming ./zabbixdb/proxy_autoreg_host.ibd
[01]        ...done
[01] Streaming ./zabbixdb/optemplate.ibd
[01]        ...done
[01] Streaming ./zabbixdb/expressions.ibd
[01]        ...done
[01] Streaming ./zabbixdb/sysmap_url.ibd
[01]        ...done
[01] Streaming ./zabbixdb/dservices.ibd
[01]        ...done
[01] Streaming ./zabbixdb/service_alarms.ibd
>> log scanned up to (29602253)
[01]        ...done
[01] Streaming ./zabbixdb/icon_mapping.ibd
[01]        ...done
[01] Streaming ./zabbixdb/opgroup.ibd
[01]        ...done
[01] Streaming ./zabbixdb/valuemaps.ibd
[01]        ...done
[01] Streaming ./zabbixdb/sysmaps_links.ibd
[01]        ...done
[01] Streaming ./zabbixdb/services_times.ibd
[01]        ...done
[01] Streaming ./zabbixdb/hosts.ibd
[01]        ...done
[01] Streaming ./zabbixdb/hosts_templates.ibd
[01]        ...done
[01] Streaming ./zabbixdb/ids.ibd
[01]        ...done
[01] Streaming ./zabbixdb/proxy_dhistory.ibd
[01]        ...done
[01] Streaming ./zabbixdb/usrgrp.ibd
[01]        ...done
[01] Streaming ./zabbixdb/slides.ibd
[01]        ...done
[01] Streaming ./zabbixdb/httpstepitem.ibd
[01]        ...done
[01] Streaming ./zabbixdb/opmessage.ibd
[01]        ...done
[01] Streaming ./zabbixdb/operations.ibd
[01]        ...done
[01] Streaming ./zabbixdb/history_uint_sync.ibd
[01]        ...done
[01] Streaming ./zabbixdb/history_str_sync.ibd
[01]        ...done
[01] Streaming ./zabbixdb/icon_map.ibd
[01]        ...done
[01] Streaming ./zabbixdb/media.ibd
[01]        ...done
[01] Streaming ./zabbixdb/auditlog_details.ibd
[01]        ...done
[01] Streaming ./zabbixdb/screens.ibd
[01]        ...done
[01] Streaming ./zabbixdb/media_type.ibd
[01]        ...done
[01] Streaming ./zabbixdb/history_str.ibd
[01]        ...done
[01] Streaming ./zabbixdb/dchecks.ibd
[01]        ...done
[01] Streaming ./zabbixdb/slideshows.ibd
[01]        ...done
[01] Streaming ./zabbixdb/httptestitem.ibd
[01]        ...done
[01] Streaming ./zabbixdb/globalmacro.ibd
[01]        ...done
[01] Streaming ./zabbixdb/sysmaps_elements.ibd
[01]        ...done
[01] Streaming ./zabbixdb/item_discovery.ibd
[01]        ...done
[01] Streaming ./zabbixdb/autoreg_host.ibd
[01]        ...done
[01] Streaming ./zabbixdb/groups.ibd
[01]        ...done
[01] Streaming ./zabbixdb/graph_theme.ibd
[01]        ...done
[01] Streaming ./zabbixdb/applications.ibd
[01]        ...done
[01] Streaming ./zabbixdb/history_log.ibd
[01]        ...done
[01] Streaming ./zabbixdb/services_links.ibd
[01]        ...done
[01] Streaming ./zabbixdb/conditions.ibd
[01]        ...done
[01] Streaming ./zabbixdb/opconditions.ibd
[01]        ...done
[01] Streaming ./zabbixdb/opmessage_usr.ibd
[01]        ...done
[01] Streaming ./zabbixdb/services.ibd
[01]        ...done
[01] Streaming ./zabbixdb/trigger_discovery.ibd
[01]        ...done
[01] Streaming ./zabbixdb/node_cksum.ibd
[01]        ...done
[01] Streaming ./zabbixdb/drules.ibd
[01]        ...done
[01] Streaming ./zabbixdb/globalvars.ibd
[01]        ...done
[01] Streaming ./zabbixdb/profiles.ibd
[01]        ...done
[01] Streaming ./zabbixdb/housekeeper.ibd
[01]        ...done
[01] Streaming ./zabbixdb/application_template.ibd
[01]        ...done
[01] Streaming ./zabbixdb/group_prototype.ibd
[01]        ...done
[01] Streaming ./zabbixdb/opmessage_grp.ibd
[01]        ...done
[01] Streaming ./zabbixdb/user_history.ibd
[01]        ...done
[01] Streaming ./zabbixdb/sysmap_element_url.ibd
[01]        ...done
[01] Streaming ./zabbixdb/graph_discovery.ibd
[01]        ...done
[01] Streaming ./zabbixdb/history_text.ibd
[01]        ...done
[01] Streaming ./zabbixdb/nodes.ibd
[01]        ...done
[01] Streaming ./zabbixdb/hostmacro.ibd
[01]        ...done
[01] Streaming ./zabbixdb/opcommand_hst.ibd
[01]        ...done
[01] Streaming ./zabbixdb/escalations.ibd
[01]        ...done
[01] Streaming ./zabbixdb/acknowledges.ibd
[01]        ...done
[01] Streaming ./zabbixdb/opcommand.ibd
>> log scanned up to (29602253)
[01]        ...done
[01] Streaming ./zabbixdb/sysmaps_link_triggers.ibd
[01]        ...done
[01] Streaming ./zabbixdb/interface.ibd
[01]        ...done
[01] Streaming ./zabbixdb/history.ibd
[01]        ...done
[01] Streaming ./zabbixdb/host_inventory.ibd
[01]        ...done
[01] Streaming ./zabbixdb/auditlog.ibd
[01]        ...done
[01] Streaming ./zabbixdb/host_discovery.ibd
[01]        ...done
[01] Streaming ./zabbixdb/trigger_depends.ibd
[01]        ...done
[01] Streaming ./zabbixdb/trends_uint.ibd
[01]        ...done
[01] Streaming ./zabbixdb/mappings.ibd
[01]        ...done
[01] Streaming ./zabbixdb/events.ibd
[01]        ...done
[01] Streaming ./zabbixdb/httpstep.ibd
[01]        ...done
[01] Streaming ./zabbixdb/trends.ibd
[01]        ...done
[01] Streaming ./zabbixdb/interface_discovery.ibd
[01]        ...done
[01] Streaming ./zabbixdb/items_applications.ibd
[01]        ...done
[01] Streaming ./zabbixdb/users_groups.ibd
[01]        ...done
[01] Streaming ./zabbixdb/users.ibd
[01]        ...done
[01] Streaming ./zabbixdb/graphs_items.ibd
[01]        ...done
[01] Streaming ./zabbixdb/regexps.ibd
[01]        ...done
[01] Streaming ./zabbixdb/maintenances_groups.ibd
[01]        ...done
[01] Streaming ./zabbixdb/maintenances_windows.ibd
[01]        ...done
[01] Streaming ./zabbixdb/sessions.ibd
[01]        ...done
[01] Streaming ./zabbixdb/timeperiods.ibd
[01]        ...done
[01] Streaming ./zabbixdb/alerts.ibd
[01]        ...done
[01] Streaming ./zabbixdb/graphs.ibd
[01]        ...done
[01] Streaming ./zabbixdb/screens_items.ibd
[01]        ...done
[01] Streaming ./zabbixdb/maintenances.ibd
[01]        ...done
[01] Streaming ./zabbixdb/rights.ibd
[01]        ...done
[01] Streaming ./zabbixdb/images.ibd
[01]        ...done
[01] Streaming ./zabbixdb/maintenances_hosts.ibd
[01]        ...done
>> log scanned up to (29602253)

140903 15:49:35  innobackupex: Continuing after ibbackup has suspended
140903 15:49:35  innobackupex: Starting to lock all tables...
140903 15:49:35  innobackupex: All tables locked and flushed to disk

140903 15:49:35  innobackupex: Starting to backup non-InnoDB tables and files
innobackupex: in subdirectories of '/data/mysqldata/3306/data'
innobackupex: Backing up files '/data/mysqldata/3306/data/performance_schema/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (53 files)
>> log scanned up to (29602253)
innobackupex: Backing up files '/data/mysqldata/3306/data/wikidb/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (44 files)
>> log scanned up to (29602253)
innobackupex: Backing up files '/data/mysqldata/3306/data/test/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (10 files)
innobackupex: Backing up file '/data/mysqldata/3306/data/huobi@002dus/db.opt'
innobackupex: Backing up file '/data/mysqldata/3306/data/huobi@002dus/test_01.frm'
innobackupex: Backing up file '/data/mysqldata/3306/data/huobi@002dus/admin_action_log.frm'
innobackupex: Backing up file '/data/mysqldata/3306/data/huobi@002dus/admin_browse_log.frm'
innobackupex: Backing up files '/data/mysqldata/3306/data/sys/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (64 files)
innobackupex: Backing up files '/data/mysqldata/3306/data/mysql/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (74 files)
>> log scanned up to (29602253)
innobackupex: Backing up files '/data/mysqldata/3306/data/zabbixdb/*.{frm,isl,MYD,MYI,MAD,MAI,MRG,TRG,TRN,ARM,ARZ,CSM,CSV,opt,par}' (109 files)
>> log scanned up to (29602253)
140903 15:49:39  innobackupex: Finished backing up non-InnoDB tables and files

140903 15:49:39  innobackupex: Waiting for log copying to finish

>> log scanned up to (29602253)
xtrabackup: The latest check point (for incremental): '29602253'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (29602253)

xtrabackup: Transaction log of lsn (29595377) to (29602253) was copied.
140903 15:49:40  innobackupex: All tables unlocked

innobackupex: Backup created in directory '/tmp'
innobackupex: MySQL binlog position: filename 'mysql-bin.000006', position 404091
140903 15:49:40  innobackupex: Connection to database server closed
innobackupex: You must use -i (--ignore-zeros) option for extraction of the tar stream.
140903 15:49:40  innobackupex: completed OK!
[mysql@nagios backup]$


使用压缩命令解压缩备份文件的过程为：

# tar xvzfi xtra_fullbackup0903.tar.gz  -C /data/mysqldata/backup/test/backup0903
backup-my.cnf
ibdata1
wikidb/EXTRNLNKS.ibd
wikidb/KEYSTORE.ibd
wikidb/CONTENTPROPERTIES.ibd
wikidb/NOTIFICATIONS.ibd
wikidb/AO_EF9604_FEATURE_DISCOVERY.ibd
wikidb/OS_PROPERTYENTRY.ibd
wikidb/DECORATOR.ibd
wikidb/ATTACHMENTS.ibd
wikidb/AO_21D670_WHITELIST_RULES.ibd
wikidb/AO_5F3884_FEATURE_DISCOVERY.ibd
wikidb/AO_A0B856_WEB_HOOK_LISTENER_AO.ibd
wikidb/CONTENT_PERM_SET.ibd
wikidb/AO_187CCC_SIDEBAR_LINK.ibd
wikidb/AO_9412A1_AOUSER.ibd
wikidb/IMAGEDETAILS.ibd
wikidb/LABEL.ibd
wikidb/AO_54C900_C_TEMPLATE_REF.ibd
wikidb/PLUGINDATA.ibd
wikidb/AO_9412A1_AOREGISTRATION.ibd
wikidb/CONTENT_PERM.ibd
wikidb/INDEXQUEUEENTRIES.ibd
wikidb/CONTENT.ibd
wikidb/AO_54C900_SPACE_BLUEPRINT_AO.ibd
wikidb/PAGETEMPLATES.ibd
wikidb/AO_9412A1_AOTASK.ibd
wikidb/ATTACHMENTDATA.ibd
wikidb/AO_9412A1_AONOTIFICATION.ibd
wikidb/AO_54C900_CONTENT_BLUEPRINT_AO.ibd
wikidb/CONFVERSION.ibd
wikidb/AO_38321B_CUSTOM_CONTENT_LINK.ibd
wikidb/AO_92296B_AORECENTLY_VIEWED.ibd
wikidb/LIKES.ibd
wikidb/AO_6384AB_FEATURE_METADATA_AO.ibd
wikidb/AO_DC98AE_AOHELP_TIP.ibd
wikidb/CONTENT_LABEL.ibd
wikidb/LINKS.ibd
wikidb/AO_42E351_HEALTH_CHECK_ENTITY.ibd
wikidb/FOLLOW_CONNECTIONS.ibd
wikidb/CLUSTERSAFETY.ibd
wikidb/CONFANCESTORS.ibd
wikidb/BODYCONTENT.ibd
wikidb/BANDANA.ibd
wikidb/AO_9412A1_USER_APP_LINK.ibd
test/t1.ibd
test/t2.ibd
test/jw_resource.ibd
test/deposit_coin.ibd
test/t4.ibd
test/t3.ibd
test/t5.ibd
test/admin_action_log.ibd
test/admin_browse_log.ibd
huobi@002dus/test_01.ibd
huobi@002dus/admin_action_log.ibd
huobi@002dus/admin_browse_log.ibd
mysql/slave_worker_info.ibd
mysql/slave_master_info.ibd
mysql/innodb_table_stats.ibd
mysql/innodb_index_stats.ibd
mysql/slave_relay_log_info.ibd
zabbixdb/sysmaps.ibd
zabbixdb/hosts_groups.ibd
zabbixdb/triggers.ibd
zabbixdb/group_discovery.ibd
zabbixdb/actions.ibd
zabbixdb/dbversion.ibd
zabbixdb/history_sync.ibd
zabbixdb/functions.ibd
zabbixdb/config.ibd
zabbixdb/scripts.ibd
zabbixdb/dhosts.ibd
zabbixdb/history_uint.ibd
zabbixdb/proxy_history.ibd
zabbixdb/opcommand_grp.ibd
zabbixdb/httptest.ibd
zabbixdb/items.ibd
zabbixdb/proxy_autoreg_host.ibd
zabbixdb/optemplate.ibd
zabbixdb/expressions.ibd
zabbixdb/sysmap_url.ibd
zabbixdb/dservices.ibd
zabbixdb/service_alarms.ibd
zabbixdb/icon_mapping.ibd
zabbixdb/opgroup.ibd
zabbixdb/valuemaps.ibd
zabbixdb/sysmaps_links.ibd
zabbixdb/services_times.ibd
zabbixdb/hosts.ibd
zabbixdb/hosts_templates.ibd
zabbixdb/ids.ibd
zabbixdb/proxy_dhistory.ibd
zabbixdb/usrgrp.ibd
zabbixdb/slides.ibd
zabbixdb/httpstepitem.ibd
zabbixdb/opmessage.ibd
zabbixdb/operations.ibd
zabbixdb/history_uint_sync.ibd
zabbixdb/history_str_sync.ibd
zabbixdb/icon_map.ibd
zabbixdb/media.ibd
zabbixdb/auditlog_details.ibd
zabbixdb/screens.ibd
zabbixdb/media_type.ibd
zabbixdb/history_str.ibd
zabbixdb/dchecks.ibd
zabbixdb/slideshows.ibd
zabbixdb/httptestitem.ibd
zabbixdb/globalmacro.ibd
zabbixdb/sysmaps_elements.ibd
zabbixdb/item_discovery.ibd
zabbixdb/autoreg_host.ibd
zabbixdb/groups.ibd
zabbixdb/graph_theme.ibd
zabbixdb/applications.ibd
zabbixdb/history_log.ibd
zabbixdb/services_links.ibd
zabbixdb/conditions.ibd
zabbixdb/opconditions.ibd
zabbixdb/opmessage_usr.ibd
zabbixdb/services.ibd
zabbixdb/trigger_discovery.ibd
zabbixdb/node_cksum.ibd
zabbixdb/drules.ibd
zabbixdb/globalvars.ibd
zabbixdb/profiles.ibd
zabbixdb/housekeeper.ibd
zabbixdb/application_template.ibd
zabbixdb/group_prototype.ibd
zabbixdb/opmessage_grp.ibd
zabbixdb/user_history.ibd
zabbixdb/sysmap_element_url.ibd
zabbixdb/graph_discovery.ibd
zabbixdb/history_text.ibd
zabbixdb/nodes.ibd
zabbixdb/hostmacro.ibd
zabbixdb/opcommand_hst.ibd
zabbixdb/escalations.ibd
zabbixdb/acknowledges.ibd
zabbixdb/opcommand.ibd
zabbixdb/sysmaps_link_triggers.ibd
zabbixdb/interface.ibd
zabbixdb/history.ibd
zabbixdb/host_inventory.ibd
zabbixdb/auditlog.ibd
zabbixdb/host_discovery.ibd
zabbixdb/trigger_depends.ibd
zabbixdb/trends_uint.ibd
zabbixdb/mappings.ibd
zabbixdb/events.ibd
zabbixdb/httpstep.ibd
zabbixdb/trends.ibd
zabbixdb/interface_discovery.ibd
zabbixdb/items_applications.ibd
zabbixdb/users_groups.ibd
zabbixdb/users.ibd
zabbixdb/graphs_items.ibd
zabbixdb/regexps.ibd
zabbixdb/maintenances_groups.ibd
zabbixdb/maintenances_windows.ibd
zabbixdb/sessions.ibd
zabbixdb/timeperiods.ibd
zabbixdb/alerts.ibd
zabbixdb/graphs.ibd
zabbixdb/screens_items.ibd
zabbixdb/maintenances.ibd
zabbixdb/rights.ibd
zabbixdb/images.ibd
zabbixdb/maintenances_hosts.ibd
xtrabackup_binlog_info
performance_schema/events_waits_summary_by_host_by_event_name.frm
performance_schema/events_waits_summary_by_account_by_event_name.frm
performance_schema/events_waits_history_long.frm
performance_schema/socket_summary_by_event_name.frm
performance_schema/socket_summary_by_instance.frm
performance_schema/performance_timers.frm
performance_schema/events_stages_summary_by_host_by_event_name.frm
performance_schema/rwlock_instances.frm
performance_schema/objects_summary_global_by_type.frm
performance_schema/events_stages_summary_global_by_event_name.frm
performance_schema/events_stages_history.frm
performance_schema/host_cache.frm
performance_schema/table_io_waits_summary_by_table.frm
performance_schema/events_statements_summary_by_user_by_event_name.frm
performance_schema/mutex_instances.frm
performance_schema/events_statements_current.frm
performance_schema/events_waits_summary_by_thread_by_event_name.frm
performance_schema/events_statements_summary_by_host_by_event_name.frm
performance_schema/events_statements_history.frm
performance_schema/events_stages_history_long.frm
performance_schema/threads.frm
performance_schema/accounts.frm
performance_schema/events_statements_summary_by_digest.frm
performance_schema/events_waits_summary_by_instance.frm
performance_schema/setup_actors.frm
performance_schema/events_waits_summary_by_user_by_event_name.frm
performance_schema/events_statements_summary_global_by_event_name.frm
performance_schema/setup_objects.frm
performance_schema/db.opt
performance_schema/file_summary_by_event_name.frm
performance_schema/users.frm
performance_schema/events_waits_history.frm
performance_schema/events_stages_summary_by_account_by_event_name.frm
performance_schema/table_io_waits_summary_by_index_usage.frm
performance_schema/socket_instances.frm
performance_schema/events_waits_current.frm
performance_schema/setup_instruments.frm
performance_schema/events_statements_history_long.frm
performance_schema/session_connect_attrs.frm
performance_schema/file_instances.frm
performance_schema/events_statements_summary_by_account_by_event_name.frm
performance_schema/events_waits_summary_global_by_event_name.frm
performance_schema/table_lock_waits_summary_by_table.frm
performance_schema/session_account_connect_attrs.frm
performance_schema/events_stages_summary_by_user_by_event_name.frm
performance_schema/events_stages_current.frm
performance_schema/setup_consumers.frm
performance_schema/file_summary_by_instance.frm
performance_schema/hosts.frm
performance_schema/cond_instances.frm
performance_schema/events_statements_summary_by_thread_by_event_name.frm
performance_schema/setup_timers.frm
performance_schema/events_stages_summary_by_thread_by_event_name.frm
wikidb/CLUSTERSAFETY.frm
wikidb/CONTENT_PERM.frm
wikidb/DECORATOR.frm
wikidb/AO_A0B856_WEB_HOOK_LISTENER_AO.frm
wikidb/BANDANA.frm
wikidb/PAGETEMPLATES.frm
wikidb/AO_38321B_CUSTOM_CONTENT_LINK.frm
wikidb/EXTRNLNKS.frm
wikidb/LINKS.frm
wikidb/CONFANCESTORS.frm
wikidb/LIKES.frm
wikidb/BODYCONTENT.frm
wikidb/ATTACHMENTS.frm
wikidb/NOTIFICATIONS.frm
wikidb/KEYSTORE.frm
wikidb/AO_EF9604_FEATURE_DISCOVERY.frm
wikidb/db.opt
wikidb/CONFVERSION.frm
wikidb/AO_42E351_HEALTH_CHECK_ENTITY.frm
wikidb/AO_54C900_C_TEMPLATE_REF.frm
wikidb/CONTENTPROPERTIES.frm
wikidb/INDEXQUEUEENTRIES.frm
wikidb/AO_6384AB_FEATURE_METADATA_AO.frm
wikidb/CONTENT.frm
wikidb/AO_54C900_SPACE_BLUEPRINT_AO.frm
wikidb/AO_187CCC_SIDEBAR_LINK.frm
wikidb/AO_9412A1_AOTASK.frm
wikidb/AO_54C900_CONTENT_BLUEPRINT_AO.frm
wikidb/AO_9412A1_AOUSER.frm
wikidb/AO_5F3884_FEATURE_DISCOVERY.frm
wikidb/AO_9412A1_USER_APP_LINK.frm
wikidb/ATTACHMENTDATA.frm
wikidb/PLUGINDATA.frm
wikidb/OS_PROPERTYENTRY.frm
wikidb/AO_92296B_AORECENTLY_VIEWED.frm
wikidb/CONTENT_LABEL.frm
wikidb/LABEL.frm
wikidb/AO_9412A1_AOREGISTRATION.frm
wikidb/CONTENT_PERM_SET.frm
wikidb/IMAGEDETAILS.frm
wikidb/AO_DC98AE_AOHELP_TIP.frm
wikidb/AO_21D670_WHITELIST_RULES.frm
wikidb/FOLLOW_CONNECTIONS.frm
wikidb/AO_9412A1_AONOTIFICATION.frm
test/jw_resource.frm
test/t2.frm
test/deposit_coin.frm
test/db.opt
test/t1.frm
test/t3.frm
test/t4.frm
test/admin_action_log.frm
test/t5.frm
test/admin_browse_log.frm
huobi@002dus/db.opt
huobi@002dus/test_01.frm
huobi@002dus/admin_action_log.frm
huobi@002dus/admin_browse_log.frm
sys/x@0024statements_with_full_table_scans.frm
sys/x@0024statements_with_sorting.frm
sys/x@0024statements_with_errors_or_warnings.frm
sys/x@0024io_global_by_file_by_latency.frm
sys/x@0024user_summary_by_file_io_type.frm
sys/x@0024schema_index_statistics.frm
sys/innodb_buffer_stats_by_table.frm
sys/x@0024io_global_by_wait_by_latency.frm
sys/io_global_by_wait_by_bytes.frm
sys/x@0024statements_with_temp_tables.frm
sys/schema_table_statistics_with_buffer.frm
sys/x@0024user_summary_by_statement_type.frm
sys/processlist.frm
sys/statements_with_sorting.frm
sys/waits_global_by_latency.frm
sys/latest_file_io.frm
sys/x@0024wait_classes_global_by_avg_latency.frm
sys/schema_unused_indexes.frm
sys/user_summary_by_stages.frm
sys/user_summary.frm
sys/x@0024wait_classes_global_by_latency.frm
sys/x@0024ps_digest_95th_percentile_by_avg_us.frm
sys/db.opt
sys/x@0024processlist.frm
sys/x@0024schema_table_statistics.frm
sys/user_summary_by_file_io_type.frm
sys/statements_with_errors_or_warnings.frm
sys/schema_table_statistics.frm
sys/schema_object_overview.frm
sys/x@0024innodb_buffer_stats_by_table.frm
sys/schema_tables_with_full_table_scans.frm
sys/io_global_by_file_by_latency.frm
sys/statements_with_runtimes_in_95th_percentile.frm
sys/version.frm
sys/x@0024waits_global_by_latency.frm
sys/x@0024statements_with_runtimes_in_95th_percentile.frm
sys/user_summary_by_file_io.frm
sys/waits_by_user_by_latency.frm
sys/x@0024io_by_thread_by_latency.frm
sys/x@0024io_global_by_wait_by_bytes.frm
sys/user_summary_by_statement_type.frm
sys/x@0024innodb_buffer_stats_by_schema.frm
sys/x@0024user_summary_by_file_io.frm
sys/x@0024schema_table_statistics_with_buffer.frm
sys/x@0024latest_file_io.frm
sys/x@0024waits_by_user_by_latency.frm
sys/wait_classes_global_by_latency.frm
sys/io_by_thread_by_latency.frm
sys/schema_index_statistics.frm
sys/ps_check_lost_instrumentation.frm
sys/wait_classes_global_by_avg_latency.frm
sys/x@0024user_summary.frm
sys/x@0024ps_digest_avg_latency_distribution.frm
sys/x@0024statement_analysis.frm
sys/statements_with_temp_tables.frm
sys/x@0024io_global_by_file_by_bytes.frm
sys/user_summary_by_statement_latency.frm
sys/x@0024user_summary_by_stages.frm
sys/statement_analysis.frm
sys/x@0024user_summary_by_statement_latency.frm
sys/io_global_by_file_by_bytes.frm
sys/io_global_by_wait_by_latency.frm
sys/statements_with_full_table_scans.frm
sys/innodb_buffer_stats_by_schema.frm
mysql/plugin.frm
mysql/time_zone_leap_second.MYD
mysql/time_zone_transition_type.MYI
mysql/servers.frm
mysql/procs_priv.frm
mysql/db.MYI
mysql/help_topic.MYD
mysql/time_zone.frm
mysql/slave_master_info.frm
mysql/help_relation.MYD
mysql/proc.MYD
mysql/time_zone_name.frm
mysql/db.frm
mysql/help_topic.MYI
mysql/plugin.MYI
mysql/innodb_table_stats.frm
mysql/tables_priv.MYI
mysql/func.frm
mysql/general_log.frm
mysql/plugin.MYD
mysql/help_keyword.MYI
mysql/time_zone.MYI
mysql/event.MYI
mysql/help_topic.frm
mysql/proc.frm
mysql/time_zone_transition_type.MYD
mysql/help_category.MYD
mysql/tables_priv.frm
mysql/slave_relay_log_info.frm
mysql/servers.MYI
mysql/columns_priv.frm
mysql/help_keyword.frm
mysql/time_zone_transition_type.frm
mysql/tables_priv.MYD
mysql/general_log.CSM
mysql/func.MYI
mysql/time_zone_transition.MYD
mysql/db.MYD
mysql/ndb_binlog_index.MYI
mysql/proxies_priv.MYD
mysql/servers.MYD
mysql/proc.MYI
mysql/slave_worker_info.frm
mysql/slow_log.CSM
mysql/procs_priv.MYI
mysql/columns_priv.MYI
mysql/time_zone_name.MYI
mysql/help_category.MYI
mysql/help_keyword.MYD
mysql/time_zone_name.MYD
mysql/ndb_binlog_index.frm
mysql/time_zone_transition.frm
mysql/event.MYD
mysql/time_zone_transition.MYI
mysql/columns_priv.MYD
mysql/general_log.CSV
mysql/help_category.frm
mysql/ndb_binlog_index.MYD
mysql/proxies_priv.MYI
mysql/time_zone_leap_second.frm
mysql/func.MYD
mysql/event.frm
mysql/slow_log.frm
mysql/procs_priv.MYD
mysql/help_relation.frm
mysql/time_zone.MYD
mysql/help_relation.MYI
mysql/innodb_index_stats.frm
mysql/proxies_priv.frm
mysql/slow_log.CSV
mysql/user.MYI
mysql/time_zone_leap_second.MYI
mysql/user.frm
mysql/user.MYD
zabbixdb/services_times.frm
zabbixdb/application_template.frm
zabbixdb/slideshows.frm
zabbixdb/media_type.frm
zabbixdb/config.frm
zabbixdb/functions.frm
zabbixdb/opmessage_grp.frm
zabbixdb/httpstep.frm
zabbixdb/mappings.frm
zabbixdb/proxy_autoreg_host.frm
zabbixdb/screens.frm
zabbixdb/maintenances_hosts.frm
zabbixdb/history_sync.frm
zabbixdb/user_history.frm
zabbixdb/group_prototype.frm
zabbixdb/host_discovery.frm
zabbixdb/media.frm
zabbixdb/dchecks.frm
zabbixdb/maintenances_windows.frm
zabbixdb/dbversion.frm
zabbixdb/conditions.frm
zabbixdb/opconditions.frm
zabbixdb/acknowledges.frm
zabbixdb/alerts.frm
zabbixdb/hosts_groups.frm
zabbixdb/rights.frm
zabbixdb/auditlog_details.frm
zabbixdb/httptest.frm
zabbixdb/timeperiods.frm
zabbixdb/autoreg_host.frm
zabbixdb/graphs_items.frm
zabbixdb/opgroup.frm
zabbixdb/triggers.frm
zabbixdb/images.frm
zabbixdb/expressions.frm
zabbixdb/proxy_dhistory.frm
zabbixdb/users_groups.frm
zabbixdb/optemplate.frm
zabbixdb/dservices.frm
zabbixdb/auditlog.frm
zabbixdb/services_links.frm
zabbixdb/interface.frm
zabbixdb/httpstepitem.frm
zabbixdb/history_text.frm
zabbixdb/groups.frm
zabbixdb/drules.frm
zabbixdb/db.opt
zabbixdb/trigger_discovery.frm
zabbixdb/scripts.frm
zabbixdb/users.frm
zabbixdb/usrgrp.frm
zabbixdb/opcommand.frm
zabbixdb/sysmap_element_url.frm
zabbixdb/sysmaps_elements.frm
zabbixdb/applications.frm
zabbixdb/sessions.frm
zabbixdb/services.frm
zabbixdb/maintenances_groups.frm
zabbixdb/graph_discovery.frm
zabbixdb/trigger_depends.frm
zabbixdb/globalmacro.frm
zabbixdb/dhosts.frm
zabbixdb/history_uint_sync.frm
zabbixdb/hosts_templates.frm
zabbixdb/valuemaps.frm
zabbixdb/events.frm
zabbixdb/globalvars.frm
zabbixdb/icon_map.frm
zabbixdb/opmessage.frm
zabbixdb/proxy_history.frm
zabbixdb/items.frm
zabbixdb/sysmaps.frm
zabbixdb/escalations.frm
zabbixdb/sysmaps_links.frm
zabbixdb/maintenances.frm
zabbixdb/httptestitem.frm
zabbixdb/history_str_sync.frm
zabbixdb/sysmaps_link_triggers.frm
zabbixdb/hostmacro.frm
zabbixdb/items_applications.frm
zabbixdb/history_uint.frm
zabbixdb/nodes.frm
zabbixdb/graph_theme.frm
zabbixdb/trends_uint.frm
zabbixdb/history_str.frm
zabbixdb/hosts.frm
zabbixdb/history_log.frm
zabbixdb/profiles.frm
zabbixdb/item_discovery.frm
zabbixdb/opcommand_grp.frm
zabbixdb/regexps.frm
zabbixdb/service_alarms.frm
zabbixdb/node_cksum.frm
zabbixdb/history.frm
zabbixdb/host_inventory.frm
zabbixdb/interface_discovery.frm
zabbixdb/group_discovery.frm
zabbixdb/opcommand_hst.frm
zabbixdb/trends.frm
zabbixdb/housekeeper.frm
zabbixdb/opmessage_usr.frm
zabbixdb/operations.frm
zabbixdb/icon_mapping.frm
zabbixdb/screens_items.frm
zabbixdb/slides.frm
zabbixdb/graphs.frm
zabbixdb/actions.frm
zabbixdb/sysmap_url.frm
zabbixdb/ids.frm
xtrabackup_logfile
xtrabackup_checkpoints
xtrabackup_binary
[root@nagios backup]#





yumushui
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
xtrabackup备份与还原
ileonion的博客
05-29 1875
-apply-log-only：除了最后一次增量备份的prepare不需要加--apply-log-only，前面的prepare都要加此参数。使用容器运行mysql实例时，通过配置文件读取到的socket文件位置都是容器中的，而不是宿主机内的，xtrabackup备份会出错。方法1：可以通过主机（--host）、端口（--port）、用户（--user）、密码（--password）进行连接。方法2：可以通过socket文件、用户（--user）、密码（--password）进行连接。
xtrabackup备份恢复shell脚本
08-26
《Xtrabackup备份与恢复：Shell脚本详解》 ...总结，Xtrabackup结合Shell脚本提供了一套强大的MySQL备份恢复解决方案，能够应对各种复杂的业务场景。理解并熟练掌握这一工具，对于保障数据库的安全运行具有重要意义。
MySQL数据库之基于XtraBackup的备份有效性检查脚本
yimenglin的博客
03-30 415
本文主要向大家介绍了MySQL数据库之基于XtraBackup的备份有效性检查脚本 ，通过具体的内容向大家展现，希望对大家学习MySQL数据库有所帮助。    备份存放：通过XtraBackup的流式备份，将备份异地存放到备份服务器上。  &nbs...
xtrabackup备份原理解析
baijiu1的博客
04-22 4991
对于数据量大的数据库来说，xtrabackup是作为mysql最好的热备份工具。 xtrabackup内容解析： 首先做一次全量备份： xtrabackup -uroot -p123456 --backup -S /usr/local/mysql/mysql.sock 第一部分（对于innodb表的备份）： 190422 16:14:28 version_check Connecte...
【5】MySQL数据库备份-XtraBackup - 全量备份
最新发布
CharlesYuangc的博客
06-01 1043
关于数据库备份的一些常见术语、工具等，可见《MySQL数据库-备份》章节，当前不再重复概述。本篇主要对XtraBackup工具的使用做下详细讲解。首先，说下所使用的环境、版本。
xtrabackup 备份数据库命令解析
2301_79996063的博客
11-18 166
【代码】xtrabackup 备份数据库命令解析。
Xtrabackup备份
喝醉酒的小白
06-02 5747
mysql备份
XtraBackup 备份与恢复实例讲解.docx
05-08
rsync 工具一次性拷贝所有非 InnoDB 文件，而不是为每个文件单独创建 cp，在备份恢复很多数据库和表时非常高效。此选项不能和 --stream 一起使用。 14. --incremental 该选项用于告诉 xtrabackup 创建一个增量备份...
Mysql数据库备份恢复测试报告-xtrabackup.docx
03-29
7. **最佳实践**：为了确保数据安全，应定期进行备份，并进行恢复测试以验证备份的有效性和恢复流程的可靠性。此外，根据业务需求选择合适的备份策略，例如全量备份与增量备份的组合，以平衡备份时间和恢复效率。 ...
mysql xtrabackup 备份恢复实现分享
09-11
2. **快速备份与恢复**：备份和恢复过程快速，减少了对数据库性能的影响。 3. **事务一致性**：备份过程中保证了数据的一致性，避免了因备份导致的数据不完整。 4. **数据压缩**：支持数据压缩，节省存储空间和网络...
Xtrabackup备份与恢复.pdf
09-13
Xtrabackup备份与恢复 Xtrabackup是一个用于MySQL数据库物理热备的备份工具，由Percona公司开发，支持MySQL、Percona server和MariaDB，开源免费。其主要特点是能够对数据库进行增量备份，支持InnoDB和XtraDB两种...
xtrabackup备份恢复测试
lijingkuan的博客
12-10 574
1.下载并解压xtrabackup [root@myrep1 tmp]# tar -zxvf percona-xtrabackup-2.3.2-Linux-x86_64.tar.gz [root@myrep1 tmp]# ll total 367484 drwxr-xr-x. 5 root root 4096 Oct 17 02:50 percona-xtrabackup-2.3.2
xpb备份过程FTWRL超时问题
weixin_30627381的博客
06-27 185
现象： PXC版本：5.5.34 xtrabackup版本:2.0.6 xtrabackup夜间备份失败，查看备份日志如下： ... ... >> log scanned up to (386464269338) >> log scanned up to (386464269338) >> log ...
慢查询和innobackup备份导致数据库挂起
sdmei
11-15 841
现象 短信报警凌晨的备份任务失败；研发说应用挂了，应用都重启过了，貌似还没解决；其他cpu、磁盘空间、日志等指标都正常，没收到报警，疑惑； 排查 凌晨1点开始的备份不成功： >> log scanned up to (348743804470) xtrabackup: Creating suspend file '/data1/backup/2017-11-14_
xtrabackup 备份恢复过程详解
jolly10的专栏
04-24 4473
xtrabackup是Percona公司CTO Vadim参与开发的一款基于InnoDB的在线热备工具，具有开源，免费，支持在线热备，备份恢复速度快，占用磁盘空间小等特点，并且支持不同情况下的多种备份形式。xtrabackup的官方下载地址为http://www.percona.com/software/percona-xtrabackup。xtrabackup包含两个主要的工具，即xtrabac...
xtrabackup命令用法实战
wfs
05-21 5372
上篇整理了innobackupex命令的用法：innobackupex命令用法实战，接下来介绍xtrabackup命令的用法。其中xtrabackup命令使用说明可以参考：Percona XtraBackup使用说明 完全备份 1.创建备份 [root@linux-node1 backup]# xtrabackup --user=backup --password=123456 --da...
Xtrabackup备份与恢复
小胡子
05-28 5697
一、Xtrabackup介绍 　　MySQL冷备、mysqldump、MySQL热拷贝都无法实现对数据库进行增量备份。在实际生产环境中增量备份是非常实用的，如果数据大于50G或100G，存储空间足够的情况下，可以每天进行完整备份，如果每天产生的数据量较大，需要定制数据备份策略。例如每周实用完整备份，周一到周六实用增量备份。而Percona-Xtrabackup就是为了实现增量备份而出现的一款主流备份工具，xtrabakackup有2个工具，分别是xtrabakup、innobakupe。 　　Pe..
MYSQL中重复的索引和多余的索引
朝着梦想 渐行前进
08-27 1885
About every second application I look at has some tables which have redundant or duplicate indexes so its the time to speak about these a bi
Percona XtraBackup 2.4 innobackupex全量、增量备份恢复流程
cuantangnie3915的博客
04-26 334
innobackupex是xtrabackup的软连接。 xtrabackup 使用C语言编译的备份工具，可以完整备份MySQL数据库，支持MyISAM、InnoDB和XtraDB存储引擎。 在备份的时候，备份工具主要执...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值