设为首页 加入收藏

TOP

mysql的xtrabackup备份恢复等基本操作教程(一)
2018-04-18 06:06:46 】 浏览:766
Tags:mysql xtrabackup 备份 恢复 基本操作 教程

演示环境:

操作系统Linux-x86-64

数据库版本:5.7.19

本次演示包括:xtrabackup软件的安装, 全量备份,增量备份,恢复 操作

1、安装xtrabackup软件

--查看软件
[root@single-instance oracle_setup]# ll *xtrabackup*
-rw-r--r-- 1 root root 7745224 Mar 19 21:21 percona-xtrabackup-24-2.4.10-1.el7.x86_64.rpm


--安装报错 一些依赖包没有
[root@single-instance oracle_setup]# rpm -ivh percona-xtrabackup-24-2.4.10-1.el7.x86_64.rpm
warning: percona-xtrabackup-24-2.4.10-1.el7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
error: Failed dependencies:
        libev.so.4()(64bit) is needed by percona-xtrabackup-24-2.4.10-1.el7.x86_64
        perl(DBD::mysql) is needed by percona-xtrabackup-24-2.4.10-1.el7.x86_64
        perl(Digest::MD5) is needed by percona-xtrabackup-24-2.4.10-1.el7.x86_64


--安装依赖包
[root@single-instance oracle_setup]# rpm -ivh libev4-4.24-alt1.x86_64.rpm
Preparing...                          ################################# [100%]
Updating / installing...
   1:libev4-4.24-alt1                 ################################# [100%]


[root@single-instance yum.repos.d]# yum -y install perl-Digest-MD5.x86_64
Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
Resolving Dependencies
--> Running transaction check
---> Package perl-Digest-MD5.x86_64 0:2.52-3.el7 will be installed
--> Processing Dependency: perl(Digest::base) >= 1.00 for package: perl-Digest-MD5-2.52-3.el7.x86_64
--> Running transaction check
---> Package perl-Digest.noarch 0:1.17-245.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=============================================================================================================================================================
 Package                                    Arch                              Version                                 Repository                        Size
=============================================================================================================================================================
Installing:
 perl-Digest-MD5                            x86_64                            2.52-3.el7                              rhel7                             30 k
Installing for dependencies:
 perl-Digest                                noarch                            1.17-245.el7                            rhel7                             23 k

Transaction Summary
=============================================================================================================================================================
Install  1 Package (+1 Dependent package)

Total download size: 53 k
Installed size: 82 k
Downloading packages:
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                        6.8 MB/s |  53 kB  00:00:00     
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
** Found 1 pre-existing rpmdb problem(s), 'yum check' output follows:
cyrus-sasl-lib-2.1.26-20.el7_2.x86_64 is a duplicate with cyrus-sasl-lib-2.1.23-15.el6_6.2.x86_64
  Installing : perl-Digest-1.17-245.el7.noarch                                                                                                           1/2 
  Installing : perl-Digest-MD5-2.52-3.el7.x86_64                                                                                                         2/2 
  Verifying  : perl-Digest-1.17-245.el7.noarch                                                                                                           1/2 
  Verifying  : perl-Digest-MD5-2.52-3.el7.x86_64                                                                                                         2/2 

Installed:
  perl-Digest-MD5.x86_64 0:2.52-3.el7                                                                                                                        

首页 上一页 1 2 3 4 5 6 7 下一页 尾页 1/10/10
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇阿里云服务器上安装mysql并开启远.. 下一篇Centos7系统下安装Mysql教程

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目