- 可配置备份文件保留天数
- 可配置指定表不备份
import os
import time
import schedule
from datetime import date, timedelta
DB_user = "root"
DB_password = "root"
DB_name = "demo"
SUDO_Password = ''
DOCKER_image = "5390aaed0e9c"
FILE_SAVE_path = "/prod/backup/"
FILE_SAVE_DATE = 5
def execute():
del_file()
backup()
def backup():
IGNORED_TABLES_STRING = ""
EXCLUDED_TABLES = [
'log_data',
'log_data202210',
'log_data202209',
'log_login',
'log_operation',
'log_request',
]
for table_name in EXCLUDED_TABLES:
IGNORED_TABLES_STRING += " --ignore-table=" + DB_name + "." + table_name
FILEPATH = FILE_SAVE_path + "demo_`date +%F`.sql"
command = "docker exec " + DOCKER_image + " sh -c 'exec mysqldump -u " + DB_user + " -p" + DB_password + " " + DB_name + \
" " + IGNORED_TABLES_STRING + "' > " + FILEPATH
print(command)
os.system('echo %s|sudo -S %s' % (SUDO_Password, command))
def del_file():
dt = date.today() - timedelta(FILE_SAVE_DATE)
filePath = FILE_SAVE_path + 'demo_' + dt.strftime("%Y-%m-%d") + ".sql"
if os.path.exists(filePath):
os.remove(filePath)
print("删除已有文件 " + filePath)
"""
schedule.every(2).seconds.do(job) # 部署每2s执行一次job()函数的任务
schedule.every(2).minutes.do(job) # 部署每2分钟执行一次job()函数的任务
schedule.every().hour.do(job) # 部署每×小时执行一次job()函数的任务
schedule.every().day.at("10:30").do(job) # 部署在每天的10:30执行job()函数的任务
schedule.every().monday.do(job) # 部署每个星期一执行job()函数的任务
schedule.every().wednesday.at("13:15").do(job) # 部署每周三的13:15执行函数的任务
"""
schedule.every().day.at("02:30").do(execute)
if __name__ == "__main__":
while True:
schedule.run_pending()
time.sleep(1)