windows使用python进行定时备份mysql数据库
由于对于windows的bat的语言不熟,我决定使用python调用os模块进行mysql备份,代码如下
import os
from datetime import datetime,timedelta
import random
print(os.getcwd())
if not os.path.exists(r"C:\Users\***\Desktop\mysqlback"):
os.mkdir(r'C:\Users\***\Desktop\mysqlback')
for root,dirs,files in os.walk(r"C:\Users\***\Desktop\mysqlback"):
for name in files:
print(os.path.join(root,name))
if name.endswith(".sql"):
da=name[:10]
if (datetime.now()-timedelta(days=10))>datetime.strptime(da,"%Y-%m-%d"):
print(os.path.join(root,name))
os.remove(os.path.join(root,name))
else:
print('fff')
os.system(r"mysqldump -uroot -p**** zzer_manage>C:\Users\guanjw\Desktop\mysqlback\{}.sql".format(str(datetime.today().date())))
print("hah")
这里可以删除10天以上的备份数据,只是保留10天以内的