python+expect脚本实现自动备份数据,简单实用

本文介绍了一个使用Python结合Expect脚本实现自动备份数据的解决方案。通过定义IP、端口、密码和路径的迭代器,Python脚本循环调用 Expect脚本进行SCP拷贝操作,将远程服务器的SQL文件备份到本地。Expect脚本处理连接和密码输入。为了安全,作者建议通过设置Python脚本密码来避免明文密码,可以通过vim编辑器进行设置和取消。
摘要由CSDN通过智能技术生成

python脚本如下:

#!/usr/bin/python
import  os,datetime
ip = iter(["1.1","1.2","1.3","1.4","1.5","1.6","1.7","1.8"])
port = iter(["3041","4227","2300","3212","2949","4502","3767","3405"])
passwd = iter(["11111","22222","33333","44444","55555","66666","77777","88888"])
path = iter(["/data0/backup/mysql/test/","/data1/backup_mysql/mysql/","/data0/backup/","/data0/backup/datalv/","/data1/backup/","/backup/data/","/data2/backup_mysql/mysql/","/backup/data/"])
today = "*" + str(datetime.date.today()).replace('-','').split()[0][2:] + "*"


for i in range(0,8):
    now_ip = next(ip)
    now_port = next(

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值