设为首页 加入收藏

TOP

mysql的xtrabackup备份恢复等基本操作教程(二)
2018-04-18 06:06:46 】 浏览:771
Tags:mysql xtrabackup 备份 恢复 基本操作 教程
Dependency Installed: perl-Digest.noarch 0:1.17-245.el7 Complete! [root@single-instance oracle_setup]# rpm -ivh mysql-community-libs-compat-5.7.21-1.el7.x86_64.rpm warning: mysql-community-libs-compat-5.7.21-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY Preparing... ################################# [100%] Updating / installing... 1:mysql-community-libs-compat-5.7.2################################# [100%] --依赖 mysql-community-libs-compat [root@single-instance yum.repos.d]# yum -y install perl-DBD-MySQL.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-DBD-MySQL.x86_64 0:4.023-5.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ============================================================================================================================================================= Package Arch Version Repository Size ============================================================================================================================================================= Installing: perl-DBD-MySQL x86_64 4.023-5.el7 rhel7 140 k Transaction Summary ============================================================================================================================================================= Install 1 Package Total download size: 140 k Installed size: 323 k Downloading packages: 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-DBD-MySQL-4.023-5.el7.x86_64 1/1 Verifying : perl-DBD-MySQL-4.023-5.el7.x86_64 1/1 Installed: perl-DBD-MySQL.x86_64 0:4.023-5.el7 Complete! --安装xtrabackup [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 Preparing... ################################# [100%] Updating / installing... 1:percona-xtrabackup-24-2.4.10-1.el################################# [100%] --查看安装文件 [root@single-instance xtrabackup_dir]# rpm -qa |grep xtrabackup percona-xtrabackup-24-2.4.10-1.el7.x86_64 [root@single-instance xtrabackup_dir]# rpm -ql percona-xtrabackup-24-2.4.10-1.el7.x86_64 /usr/bin/innobackupex /usr/bin/xbcloud /usr/bin/xbcloud_osenv /usr/bin/xbcrypt /usr/bin/xbstream /usr/bin/xtrabackup /usr/share/doc/percona-xtrabackup-24-2.4.10 /usr/share/doc/percona-xtrabackup-24-2.4.10/COPYING /usr/share/man/man1/innobackupex.1.gz /usr/share/man/man1/xbcrypt.1.gz /usr/share/man/man1/xbstream.1.gz /usr/share/man/man1/xtrabackup.1.gz

2、基本设置

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

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目