MySQL 日志解析：innobackupex 备份日志

已于 2024-02-28 16:33:44 修改
阅读量628 收藏
点赞数
分类专栏： MySQL 文章标签： linux mysql dba
于 2022-01-13 14:08:27 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/Tony_stark_L/article/details/122472606
版权

由于个人能力有限，文中可能存在错误，欢迎批评指正。

文章目录

innobackupex 备份日志及解析

# ------开始备份
180428 09:30:01 innobackupex: Starting the backup operation

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

# ------检查版本
180428 09:30:01  version_check Connected to MySQL server
180428 09:30:01  version_check Executing a version check against the     server...
180428 09:30:01  version_check Done.
180428 09:30:01 Connecting to MySQL server host: 127.0.0.1, user: root,     password: set, port: 3306, socket: /mysql/data/mysql.sock
Using server version 5.5.18-rel23.0-log
/home/mysql/bin/innobackupex version 2.4.3 based on MySQL server 5.7.11 Linux     (x86_64) (revision id: 6a46905)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /mysql/data
xtrabackup: open files limit requested 0, set to 51200
xtrabackup: using the following InnoDB configuration:
xtrabackup:   innodb_data_home_dir = .
xtrabackup:   innodb_data_file_path = ibdata1:512M;ibdata2:512M:autoextend
xtrabackup:   innodb_log_group_home_dir = .
xtrabackup:   innodb_log_files_in_group = 4
xtrabackup:   innodb_log_file_size = 536870912
# ------O_DIRECT，不使用缓存直接写入
xtrabackup: using O_DIRECT
InnoDB: Number of pools: 1
# ------redo 拷贝线程开启
180428 09:30:01 >> log scanned up to (1965766249)
xtrabackup: Generating a list of tablespaces
InnoDB: Allocated tablespace ID 251 for slamdunk/backup_list, old maximum was     0
# ------ibd 拷贝线程开启
180428 09:30:02 [01] Streaming ./ibdata1
180428 09:30:02 >> log scanned up to (1965766249)
180428 09:30:03 >> log scanned up to (1965766249)
180428 09:30:04 >> log scanned up to (1965766249)
180428 09:30:05 >> log scanned up to (1965766249)
180428 09:30:06 >> log scanned up to (1965766249)
180428 09:30:07 >> log scanned up to (1965766249)
180428 09:30:08 [01]        ...done
180428 09:30:08 [01] Streaming ./ibdata2
180428 09:30:08 >> log scanned up to (1965766249)
180428 09:30:09 >> log scanned up to (1965766249)
180428 09:30:10 >> log scanned up to (1965766249)
180428 09:30:11 >> log scanned up to (1965766249)
180428 09:30:12 >> log scanned up to (1965766249)
180428 09:30:13 [01]        ...done
180428 09:30:13 [01] Streaming ./slamdunk/backup_list.ibd
180428 09:30:13 [01]        ...done
180428 09:30:13 [01] Streaming ./slamdunk/backup_job.ibd
180428 09:30:13 [01]        ...done
# ------ibp线程拷贝idb完成后，xtrabackup进程进入等待（redo 线程仍然继续拷贝）
180428 09:30:13 >> log scanned up to (1965766249)
# ------innobackupex 收到 xtrabackup 通知后，执行 FLUSH TABLES WITH READ LOCK (FTWRL)，取得一致性位点，然后开始备份非InnoDB文件（包括frm、MYD、MYI、CSV、opt、par等）。
180428 09:30:14 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
180428 09:30:14 Executing FLUSH TABLES WITH READ LOCK...
180428 09:30:14 Starting to backup non-InnoDB tables and files
180428 09:30:14 [01] Streaming ./mysql/help_keyword.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/procs_priv.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/host.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/columns_priv.MYD to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/servers.MYD to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/help_topic.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/help_category.MYD to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/time_zone_transition_type.MYI to     <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/time_zone_name.MYI to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/help_category.MYI to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/ndb_binlog_index.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/proc.MYD to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/func.MYD to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/time_zone.MYI to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/time_zone.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/time_zone_transition.MYI to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/user.MYD to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/host.MYI to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/general_log.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/db.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/columns_priv.MYI to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/time_zone_name.MYD to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/host.MYD to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/help_keyword.MYD to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/time_zone_transition.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/proxies_priv.MYI to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/time_zone_leap_second.MYD to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/columns_priv.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/time_zone.MYD to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/db.MYI to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/event.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/tables_priv.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/procs_priv.MYI to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/help_relation.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/help_relation.MYI to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/general_log.CSM to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/event.MYI to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/ndb_binlog_index.MYI to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/slow_log.CSM to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/slow_log.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/event.MYD to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/help_topic.MYI to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/tables_priv.MYD to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/time_zone_leap_second.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/slow_log.CSV to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/plugin.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/proc.MYI to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/user.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/plugin.MYD to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/help_topic.MYD to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/procs_priv.MYD to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/time_zone_transition.MYD to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/func.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/help_category.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/proc.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/proxies_priv.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/ndb_binlog_index.MYD to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/db.MYD to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/servers.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/help_relation.MYD to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/user.MYI to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/time_zone_transition_type.MYD to     <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/tables_priv.MYI to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/plugin.MYI to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/general_log.CSV to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/help_keyword.MYI to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/proxies_priv.MYD to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/time_zone_transition_type.frm to     <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/func.MYI to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/servers.MYI to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/time_zone_leap_second.MYI to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mysql/time_zone_name.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./test/db.opt to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./slamdunk/backup_list.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./slamdunk/backup_job.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./slamdunk/db.opt to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./performance_schema/mutex_instances.frm to     <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming     ./performance_schema/events_waits_summary_by_thread_by_event_name.frm to     <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./performance_schema/setup_instruments.frm to     <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./performance_schema/setup_timers.frm to     <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./performance_schema/events_waits_history.frm     to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming     ./performance_schema/events_waits_summary_global_by_event_name.frm to     <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./performance_schema/performance_timers.frm to     <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./performance_schema/threads.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./performance_schema/events_waits_current.frm     to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./performance_schema/setup_consumers.frm to     <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./performance_schema/file_instances.frm to     <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./performance_schema/cond_instances.frm to     <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming     ./performance_schema/file_summary_by_instance.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming     ./performance_schema/file_summary_by_event_name.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./performance_schema/rwlock_instances.frm to     <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming     ./performance_schema/events_waits_summary_by_instance.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming     ./performance_schema/events_waits_history_long.frm to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./performance_schema/db.opt to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 [01] Streaming ./mha_relay_clear/db.opt to <STDOUT>
180428 09:30:14 [01]        ...done
180428 09:30:14 Finished backing up non-InnoDB tables and files
# ------当 innobackupex 拷贝完所有非 InnoDB 表文件后，通知 xtrabackup ，同时自己进入等待
Failed to get master binlog coordinates from SHOW SLAVE STATUS
This means that the server is not a replication slave. Ignoring the     --slave-info option
# ------xtrabackup 收到 innobackupex 备份完非 InnoDB 通知后，就停止 redo 拷贝线程，然后通知 innobackupex redo log 拷贝完成； 
180428 09:30:14 [00] Streaming xtrabackup_binlog_info
180428 09:30:14 [00]        ...done
180428 09:30:14 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '1965766249'
xtrabackup: Stopping log copying thread.
.180428 09:30:14 >> log scanned up to (1965766249)

# ------innobackupex 收到 redo 备份完成通知后，就开始解锁
180428 09:30:14 Executing UNLOCK TABLES
180428 09:30:14 All tables unlocked
# ------ innobackupex 和 xtrabackup 进程各自完成收尾工作，如资源的释放、写备份元数据信息等
180428 09:30:14 Backup created in directory '/mysql/bak'
MySQL binlog position: filename 'mysql-bin.000037', position '449597771'
180428 09:30:14 [00] Streaming backup-my.cnf
180428 09:30:14 [00]        ...done
180428 09:30:14 [00] Streaming xtrabackup_info
180428 09:30:14 [00]        ...done
xtrabackup: Transaction log of lsn (1965765916) to (1965766249) was copied.
180428 09:30:14 completed OK!
樱木...
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
mysql的物理备份_MySQL物理备份基本操作
weixin_30499315的博客
02-01 234
Ⅰ、xtrabackup介绍xtrabackup只能备份innodb引擎的数据，不能备份表结构，percona开源的，强烈推荐最新版本(旧版本bug多)innobackupex可以备份myisam和innodb两种引擎的数据和表结构，一般用这个备份时，默认读取MySQL配置文件(datadir)Ⅱ、xtrabackup安装使用2.1 安装[root@VM_0_5_centos src]# yum ...
mysql基础+用户管理+完增日志备份+innobackupex在线全增备份
lianglikang的博客
10-27 179
官网:http://dev.mysql.com/downloads/mysql 配置mysql数据库: 下载源码包解压：切换到目录下 yum -y install mysql-community-*.rpm 初始随机密码生成的文件: cat /var/log/mysqld.log mysql -uroot -p'初始随机密码' show database; #查看数据库 #设置密码 alter user root@"localhost" identified by '密...
MySQL备份工具 innobackupex 日志注释及备份过程解读
最新发布
学亮编程手记
05-25 274
日志以“# ------开始备份”为标志，表明innobackupex备份操作的启动，并提示用户检查备份是否成功完成，最终会有“completed OK!: “redo拷贝线程开启”和后续的日志扫描记录显示innobackupex正在处理InnoDB的redo日志，这是确保事务一致性的关键部分。整个日志提供了备份操作的透明度，每一步都清晰地记录了备份的进展和状态，对于监控备份作业的成功与否以及后续问题分析至关重要。文件）的备份开始，这些文件包含各个InnoDB表的数据和索引。
分享一个“MySQL-5.7版本的xtrabackup物理备份”shell脚本（提供思路！）
Sakura_QKS的博客
12-06 460
物理备份；xtrabackup;innobackupex;全量备份，增量备份；差异备份
Xtrabackup介绍及使用
zll4859291的博客
03-28 690
Percona-xtrabackup是 Percona公司开发的一个用于MySQL数据库物理热备的备份工具，支持MySQL、Percona server和MariaDB， 开源免费，是目前较为受欢迎的主流备份工具。xtrabackup只能备份innoDB和xtraDB两种数据引擎的表，而不能备份MyISAM数据表。xtrabakackup有3个工具，分别是xtrabakup、innobakupex、xbstreamxtrabackup 支持InnoDB，XtraDB。
xtrabackup 的全备和恢复
we6100的专栏
09-24 169
MySQL 全备 和 恢复
mysql 慢查日志实时解析工具
09-20
我们知道mysql慢日志解析工具有很多种，比如我们常用的mysqldumpslow、pt-query-digest等，这些都是比较有效的解析工具，今天介绍的是基于go写的一款实时解析日志工具
MySQL使用innobackupex备份连接服务器失败的解决方法
09-09
5. 安装perl-DBD-MySQL：如果上述验证显示perl-DBD-MySQL及其依赖项缺失，可以使用`yum install perl-DBD-MySQL.x86_64`命令来安装。安装完成后，再次运行`yum list installed | grep perl-DBD-MySQL`，确认安装成功...
MYSQL日志与备份还原问题详解
09-09
MySQL日志与备份还原是数据库管理中的重要环节，它们对于数据的安全性和可恢复性起着至关重要的作用。本文主要探讨了MySQL的错误日志、二进制日志（BINLOG）、数据备份和数据恢复这四个关键知识点。 首先，错误日志...
关于Mysql的日志管理、备份与恢复
11-09
MySQL数据库在日常运维中，日志管理、备份与恢复是至关重要的环节，它们关系到数据的安全性和业务的连续性。本文将深入探讨这三大主题，帮助你更好地理解并掌握相关知识。 首先，我们来了解MySQL的日志系统。MySQL...
日志文件解析MySQL版
01-06
这个jar文件很可能包含了日志解析器和与MySQL交互的代码，用户可以通过命令行参数提供日志文件路径，程序会自动解析日志并将其导入到MySQL数据库中。使用jar文件可以方便地在不同的环境中部署和运行日志分析服务。 ...
mysql5.7的日志管理(错误日志，二进制日志，GTID,慢日志，备份)
weixin_43467062的博客
07-28 1457
1.错误日志 1.1 配置方法 默认：开启状态，/数据存放文件/错误日志.err 查看数据 select @@datadir; ls -l /错误日志地方 定制 方法： 1.vim /etc/my.cnf log_error=/tmp/mysql.log 说明：日志目录必须得提前有，且mysql有权限写入 2.重启 /etc/init.d/mysqld restart 1.2 怎么看错误日志 vim /错误日志位置 [error] 2.binlog二进制日志 作用：(差不多=sql层的行为) 主
Xtrabackup 解决数据库自动备份方案
枫飘长安的博客
03-22 524
数据库自动备份脚本
mysql undo001_MySQL Backup--innobackupex操作日志
weixin_34125509的博客
01-27 304
190605 14:28:14 innobackupex: Starting the backup operationIMPORTANT: Please check that the backup run completes successfully.At the end of a successful backup run innobackupexprints "completed OK!".1...
MySQL Backup--innobackupex操作日志
weixin_30414305的博客
06-05 254
备份脚本： innobackupex \--defaults-file="/export/servers/mysql/etc/my.cnf" \--host="localhost" \--port=3358 \--user='admin' \--password='admin_psw' \--slave-info \--safe-slave-backup \"/export/ba...
mysql使用innobackupex备份详解
象话的博客
10-13 2953
mysql使用innobackupex备份详解
mysql xtrabackup_MySQL备份恢复：Xtrabackup流传输实践
weixin_35912261的博客
01-27 480
XtraBackup支持流式备份，将备份以指定的tar或xbstream格式发送到STDOUT，而不是直接将文件复制到备份目录。要使用此功能，仅需要使用--stream选项即可，指定流格式为tar或xbstream，以及指定存储临时文件的绝对路径。$ innobackupex --stream=tar /tmp1$innobackupex--stream=tar/tmpinnobackupex在子...
Percona Xtrabackup 备份生成的几个文件功能说明
Data & Analysis
01-12 900
前言 在xtrabackup使用的过程中，主要会有以下几个文件生成，本文就这几个文件的内容以及作用进行记录和说明。 xtrabackup_binlog_info xtrabackup_binlog_pos_innodb xtrabackup_checkpoints xtrabackup_info xtrabackup_logfile xtrabackup_slave_info b...
mysql数据库全备和全备还原（使用Xtrabackup）
11-09 115
一、使用innobackupex创建全备 语法 innobackupex --user=DBUSER --password=DBUSERPASS /path/to/backup/dir/ innobackupex --user=DBUSER --password=DBUSERPASS...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值