mydumper备份还原数据库

复制代码
[root@localhost ~]# cd /data1
[root@localhost data1]# rpm -ivh mydumper-0.12.7-1.el7.x86_64.rpm 
准备中...                          ################################# [100%]
        file /usr/bin/mydumper from install of mydumper-0.12.7-1.x86_64 conflicts with file from package mydumper-0.11.1-3.x86_64
        file /usr/bin/myloader from install of mydumper-0.12.7-1.x86_64 conflicts with file from package mydumper-0.11.1-3.x86_64
[root@localhost data1]# cd /data
[root@localhost data]# mkdir mydumper
[root@localhost data]# mv /data1/mydumper-0.12.7-1.el7.x86_64.rpm /data/mydumper/
[root@localhost data]# which mydumper
/usr/bin/mydumper
[root@localhost data]# mkdir -p /data/mydumper/mysqlbak/62/221107
[root@localhost data]# /usr/bin/mydumper -h 192.168.200.62 -u xxx -p xxx -B xxx -t 20 -v 3 -L /data/mydumper/mydumper62.log -o /data/mydumper/mysqlbak/62/221107

参考链接https:
//www.cnblogs.com/jenvid/p/8462688.html
https://www.cnblogs.com/cfas/p/16700105.html
复制代码
posted @   太阳k  阅读(57)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 终于写完轮子一部分:tcp代理 了,记录一下
· 震惊!C++程序真的从main开始吗?99%的程序员都答错了
· 别再用vector<bool>了!Google高级工程师:这可能是STL最大的设计失误
· 单元测试从入门到精通
· 【硬核科普】Trae如何「偷看」你的代码?零基础破解AI编程运行原理
点击右上角即可分享
微信分享提示