centos 7 mysqlhotcopy 安装,使用 笔记
来源:互联网 发布:淘宝官方活动报名 编辑:程序博客网 时间:2024/05/22 02:14
1,安装perl-DBI 和 perl-DBD-MySQL,否则在运行mysqlhotcopy时会保错:
[root@localhost ~]# mysqlhotcopy -u root -p mysqlname /opt/sql_back/Warning: /usr/bin/mysqlhotcopy is deprecated and will be removed in a future version.install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at (eval 11) line 3.Perhaps the DBD::mysql perl module hasn't been fully installed,or perhaps the capitalisation of 'mysql' isn't right.Available drivers: DBM, ExampleP, File, Gofer, Proxy, Sponge. at /usr/bin/mysqlhotcopy line 199.
安装方法:
[root@localhost ~]# yum install perl-DBD* -y
2,备份
[root@localhost ~]# /bin/mysqlhotcopy -u root -p '' --addtodest mysqlname /opt/sql_back/
3,还原
[root@localhost~]# cp -arp /opt/sql_back/mysqlname /var/lib/mysql/ --将备份的数据移到mysql数据根目录
0 0
- centos 7 mysqlhotcopy 安装,使用 笔记
- Centos下使用mysqlhotcopy备份
- 使用mysqlhotcopy备份MySQL
- mysqlhotcopy
- 使用mysqlhotcopy 物理增量备份
- centos 7 安装MySQL(笔记)
- VirtualBox 安装 Centos 7 笔记
- 【CentOS笔记】CentOS安装JDK
- 【CentOS笔记】CentOS安装花生壳
- CentOS 5.4安装笔记
- centos 安装lua笔记
- Centos学习笔记--安装
- CentOS minimal 安装笔记
- CentOS minimal 安装笔记
- centos 安装mysql 笔记
- centos安装oracle笔记
- CentOS安装oracle11gR2笔记
- Centos 安装Rsync笔记
- Guest OS, Qemu, KVM工作流程
- AIDL的Proxy-Stub理解:(以实际媒体播放器服务单独运行在一个进程中为例)
- 短信验证具体步骤
- UITableViewCell 的Image设置了UIViewContentModeScaleAspectFill后图片超出去了
- LeetCode Algorithms3: Longest substring without repeating characters(in swift)
- centos 7 mysqlhotcopy 安装,使用 笔记
- Netlink实现热拔插监控
- MySQL 数据备份与还原
- zabbix监控报错zabbix server is not running: the information displayed may not be current
- Kali linux
- 史上最全的环信iOS 2.x and 3.x SDK单聊的集成方案!
- SEO终极算法(三),百度排名引流So easy
- KVM虚拟机创建功能详细讲解
- 从零接触java第一周