Xtrabackup备份恢复常用命令与压缩测试
一、使用全库备份和恢复的过程：
使用innobackupex进行全库备份的命令：
$ innobackupex --defaults-file=/data/mysqldata/3306/my.cnf --user=xtrabk --password='onlybackup' /data/mysqldata/backup
[html] view plain copy
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
[html] view plain copy
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 &
[html] view plain copy
/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
[html] view plain copy
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
[html] view plain copy
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 &
[html] view plain copy
/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
[html] view plain copy
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
[html] view plain copy
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
[html] view plain copy
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
[html] view plain copy
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
[html] view plain copy
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 &
[html] view plain copy
/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
[html] view plain copy
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
[html] view plain copy
tar xvzfi xtra_fullbackup0903.tar.gz
解压到指定文件：
$ tar xvzfi xtra_fullbackup0903.tar.gz -C /data/mysqldata/backup/test/backup0903
[html] view plain copy
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数据库的过程为：
[html] view plain copy
$ 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]$
使用压缩命令解压缩备份文件的过程为：
[html] view plain copy
# 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]#
转载于:https://blog.51cto.com/xiaocao13140/2129081
1796
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
