一个好用的Python备份mysql的脚本

时间：2023-03-08 21:37:36

前几天打算用Python写一个mysql脚本，上Google看了下老外写的，写的挺好的，原地址在http://tecadmin.net/python-script-for-mysql-database-backup/#，所以就给 copy过来了

 #!/usr/bin/python

 ###########################################################

 #

 # This python script is used for mysql database backup

 # using mysqldump utility.

 #

 # Written by : Rahul Kumar

 # Website: http://tecadmin.net

 # Created date: Dec 03, 2013

 # Last modified: Dec 03, 2013

 # Tested with : Python 2.6.6

 # Script Revision: 1.1

 #

 ##########################################################

 # Import required python libraries

 import os

 import time

 import datetime

 # MySQL database details to which backup to be done. Make sure below user having enough privileges to take databases backup.

 # To take multiple databases backup, create any file like /backup/dbnames.txt and put databses names one on each line and assignd to DB_NAME variable.

 DB_HOST = 'localhost'

 DB_USER = 'root'

 DB_USER_PASSWORD = '_root_user_password_'

 #DB_NAME = '/backup/dbnames.txt'

 DB_NAME = 'db_name'

 BACKUP_PATH = '/backup/dbbackup/'

 # Getting current datetime to create seprate backup folder like "12012013-071334".

 DATETIME = time.strftime('%m%d%Y-%H%M%S')

 TODAYBACKUPPATH = BACKUP_PATH + DATETIME

 # Checking if backup folder already exists or not. If not exists will create it.

 print "creating backup folder"

 if not os.path.exists(TODAYBACKUPPATH):

     os.makedirs(TODAYBACKUPPATH)

 # Code for checking if you want to take single database backup or assinged multiple backups in DB_NAME.

 print "checking for databases names file."

 if os.path.exists(DB_NAME):

     file1 = open(DB_NAME)

     multi = 1

     print "Databases file found..."

     print "Starting backup of all dbs listed in file " + DB_NAME

 else:

     print "Databases file not found..."

     print "Starting backup of database " + DB_NAME

     multi = 0

 # Starting actual database backup process.

 if multi:

    in_file = open(DB_NAME,"r")

    flength = len(in_file.readlines())

    in_file.close()

    p = 1

    dbfile = open(DB_NAME,"r")

    while p <= flength:

        db = dbfile.readline()   # reading database name from file

        db = db[:-1]         # deletes extra line

        dumpcmd = "mysqldump -u " + DB_USER + " -p" + DB_USER_PASSWORD + " " + db + " > " + TODAYBACKUPPATH + "/" + db + ".sql"

        os.system(dumpcmd)

        p = p + 1

    dbfile.close()

 else:

    db = DB_NAME

    dumpcmd = "mysqldump -u " + DB_USER + " -p" + DB_USER_PASSWORD + " " + db + " > " + TODAYBACKUPPATH + "/" + db + ".sql"

    os.system(dumpcmd)

 print "Backup script completed"

 print "Your backups has been created in '" + TODAYBACKUPPATH + "' directory"
# chmod +x dbbackup.py
# python dbbackup.py
做定时任务执行:
0 2 * * * /usr/bin/python dbbackup.py

相关文章