前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >使用XtraBackup创建mysql slave11

使用XtraBackup创建mysql slave11

作者头像
franket
发布2022-05-12 22:58:58
3180
发布2022-05-12 22:58:58
举报
文章被收录于专栏:技术杂记技术杂记

恢复数据库

代码语言:javascript
复制
[root@slave-test fullbackup]# innobackupex  --copy-back /data/fullbackup/2015-10-12_15-24-06/ 

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013.  All Rights Reserved.

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

Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p

151012 20:40:09  innobackupex: Starting the copy-back operation

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

innobackupex: Starting to copy files in '/data/fullbackup/2015-10-12_15-24-06'
innobackupex: back to original data directory '/var/lib/mysql'
innobackupex: Copying '/data/fullbackup/2015-10-12_15-24-06/xtrabackup_info' to '/var/lib/mysql/xtrabackup_info'
innobackupex: Copying '/data/fullbackup/2015-10-12_15-24-06/xtrabackup_binlog_pos_innodb' to '/var/lib/mysql/xtrabackup_binlog_pos_innodb'
innobackupex: Creating directory '/var/lib/mysql/bhdw_qa'
innobackupex: Copying '/data/fullbackup/2015-10-12_15-24-06/bhdw_qa/db.opt' to '/var/lib/mysql/bhdw_qa/db.opt'
innobackupex: Copying '/data/fullbackup/2015-10-12_15-24-06/bhdw_qa/user_logins.ibd' to '/var/lib/mysql/bhdw_qa/user_logins.ibd'
...
...
innobackupex: Starting to copy InnoDB system tablespace
innobackupex: in '/data/fullbackup/2015-10-12_15-24-06'
innobackupex: back to original InnoDB data directory '/var/lib/mysql/'
innobackupex: Copying '/data/fullbackup/2015-10-12_15-24-06/ibdata1' to '/var/lib/mysql/ibdata1'

innobackupex: Starting to copy InnoDB undo tablespaces
innobackupex: in '/data/fullbackup/2015-10-12_15-24-06'
innobackupex: back to '/var/lib/mysql'

innobackupex: Starting to copy InnoDB log files
innobackupex: in '/data/fullbackup/2015-10-12_15-24-06'
innobackupex: back to original InnoDB log directory '/var/lib/mysql'
innobackupex: Copying '/data/fullbackup/2015-10-12_15-24-06/ib_logfile0' to '/var/lib/mysql/ib_logfile0'
innobackupex: Copying '/data/fullbackup/2015-10-12_15-24-06/ib_logfile1' to '/var/lib/mysql/ib_logfile1'
innobackupex: Finished copying back files.

151012 20:44:21  innobackupex: completed OK!
[root@slave-test fullbackup]# echo $?
0
[root@slave-test fullbackup]# 

本文系转载,前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文系转载前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
相关产品与服务
数据库
云数据库为企业提供了完善的关系型数据库、非关系型数据库、分析型数据库和数据库生态工具。您可以通过产品选择和组合搭建,轻松实现高可靠、高可用性、高性能等数据库需求。云数据库服务也可大幅减少您的运维工作量,更专注于业务发展,让企业一站式享受数据上云及分布式架构的技术红利!
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档