mysql 备份脚本（python）

strivelcy

已于 2022-11-24 15:01:32 修改

阅读量720

点赞数

CC 4.0 BY-SA版权

文章标签： mysql 数据库 python

于 2022-11-24 15:01:10 首次发布

本文链接：https://blog.csdn.net/strivelcy/article/details/128018810

本文介绍了一个使用Python编写的MySQL备份脚本，通过mysqldump命令获取数据库并压缩为.tar.gz文件，同时处理备份失败和清理旧备份。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysql 备份脚本（python）

import warnings
warnings.filterwarnings('ignore')
import os
import sys
import time
import tarfile
import datetime

mysql_host = "数据库服务器ip地址"
mysql_user = "备份用户"
mysql_pwd = "'密码'"
mysql_port = 端口
new_date = time.strftime("%Y:%m:%d:%H:%M:%S")
file_date = time.strftime("%Y-%m-%d-%H")
back_path = "备份目录"
back_log = "备份日志路径"
db_name = "all-databases"


def baklog (output):
    logfile = open(back_log,"a+")
    logfile.write(output)
    logfile.close()

def mysqldump ():
    backpath = os.path.exists(back_path)
    if backpath == True :
       None   
    else:
       os.makedirs(back_path)
       
    output1 = "\nStart Backup,start time:%s" % new_date
    baklog(output1)
    back_file = back_path+"/"+db_name+"_"+file_date+".sql"
    back_file1 = db_name+"_"+file_date+".sql"
    os.system("mysqldump -u%s -p%s -P%s --all-databases > %s" % (mysql_user,mysql_pwd,mysql_port,back_file))
    judge = os.path.exists(back_file)
    if judge == True :
       size = os.path.getsize(back_file)
       if size == 0 :
          end_date11 = time.strftime("%Y:%m:%d:%H:%M:%S")
          output11 = "\nBackup failed,Script Exit,Failure time: %s" % end_date11
          baklog(output11)
          sys.exit()
       else:
          output12 = "\nBackup succeeded! Backup file size: %s" % size
          baklog(output12)
    else:
       end_date12 = time.strftime("%Y:%m:%d:%H:%M:%S")
       output13 = "\nBackup failed,Script Exit,Failure time: %s" % end_date11
       baklog(output13)
       sys.exit()
    tar_file(back_file1)
    os.system("find %s -mtime +7 -name .tar.gz -exec rm -rf {} \;" % back_path)
    output14 = "\nThe file was deleted seven days ago"
    baklog(output14)
    end_date = time.strftime("%Y:%m:%d:%H:%M:%S")
    output2 = "\nEnd of backup,end time:%s" % end_date
    baklog(output2)

def tar_file (file_name):
    os.chdir(back_path)
    tar_name = db_name+"_"+file_date+".sql"+".tar"+".gz"
    tar = tarfile.open(tar_name,"w:gz")
    tar.add(file_name)
    tar.close()
    output4 = "\nThe backup file is compressed file name: %s" % tar_name
    baklog(output4)
    os.remove(file_name)
    output5 = "\nBackup source file deleted : %s" % file_name
    baklog(output5)

mysqldump()