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 @ 2022-11-07 15:39  太阳k  阅读(55)  评论(0编辑  收藏  举报