使用python备份数据库并删除备份超过一定时长的文件

 1 #!/usr/bin/env python
 2 #-*- coding: utf-8 -*-
 3 """ 
 4 @Project:Py
 5 @author:sandu
 6 @Email: sandu12345@msn.cn
 7 @Software: PyCharm
 8 @file: mysql_class.py 
 9 @time: 2018/1/18 0018 下午 14:02 
10 """ 
11 
12 #导入模块
13 import time
14 import os
15 
16 DATE = time.strftime('%Y%m%d%H%M%S')
17 DAYS = 3
18 
19 class MysqlBak():
20 
21     def __init__(self,DATE,DAYS):
22         self.date = DATE
23         self.days = DAYS
24         self.__DB_HOST = "127.0.0.1"
25         self.__DB_PORT = "3306"
26         self.__DB_NAME = "demooil"
27         self.__DB_USER = "demooil"
28         self.__DB_PASS = "8OvUNQU8CggrahGS"
29         self.__BIN_DIR = "/usr/local/mysql/bin/mysqldump"
30         self.__OPTIONS = "--skip-extended-insert --skip-lock-tables --set-gtid-purged=OFF --triggers --routines --events"
31         self.__MYSQLBACK_DIR = "/home/backup/demooil_bak/"
32         self.__filebak_log = "/var/log/mysqlbak.log"
33         self.__filerm_log = "/var/log/mysqlrm.log"
34 
35     def mysql_bak(self):
36         try:
37             # all
38             mysql_file = self.__MYSQLBACK_DIR + str(self.date) + ".sql"
39             os.system("%s -h%s -u%s -p%s %s -d --databases %s > %s" % (self.__BIN_DIR,self.__DB_HOST,self.__DB_USER,self.__DB_PASS,self.__OPTIONS,self.__DB_NAME,mysql_file))
40             if os.path.exists(mysql_file):
41                 with open(self.__filebak_log,'a') as f_obj:
42                     f_obj.write('%s success back file %s \n' %  (self.date[0:8],mysql_file))
43         except Exception as e:
44             with open(self.__filebak_log, 'a') as f_obj:
45                 f_obj.write('%s error back file %s \n' %  (self.date[0:8],mysql_file))
46                 f_obj.write("error msg: %s" % e)
47 
48     def mysql_rm(self):
49         """删除备份目录下超过一定时长的文件"""
50         f = list(os.listdir(self.__MYSQLBACK_DIR))
51         now_time = self.date[0:8]
52         for i in f:
53             if i[15:] == 'sql':
54                 exit_time = i[0:8]
55                 update_time = int(exit_time) + self.days
56                 if update_time < int(now_time):
57                     os.remove(self.__MYSQLBACK_DIR + i)
58                     with open(self.__filerm_log, 'a') as file_log:
59                         file_log.write("%s删除备份文件%s \n" % (self.date[0:8], i))
60 
61 if __name__ == '__main__':
62     mysql_bak = MysqlBak(DATE,DAYS)
63     mysql_bak.mysql_bak()
64     mysql_bak.mysql_rm()
65 
66 # linux定时执行python文件
67 # crontab
68 # 0 5 * * * /usr/bin/python /root/demooil_mysql_bak.py >/dev/null 2>&1