mysql database backup use python scripts
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- import os,subprocess,datetime
-
-
- MYSQL_USER = 'root'
- MYSQL_PASS = 'pass'
- MYSQL_HOST = 'localhost'
- DEL_DAYS = 5
- BACK_PATH = '/mysql_backup'
-
- ''
- CUR_TIME = datetime.date.today()
- AGO_TIME = datetime.timedelta(days=DEL_DAYS)
- DEL_TIME = CUR_TIME - AGO_TIME
- DATABASE = ''
-
-
-
- def mysqldump():
- if os.path.isdir(BACK_PATH):
- os.chdir(BACK_PATH)
- else:
- os.mkdir(BACK_PATH)
- os.chdir(BACK_PATH)
- database_cmd=subprocess.Popen("mysql -u%s -p%s -h%s -e 'show databases'|grep -v Database|grep -v information" %(MYSQL_USER,MYSQL_PASS,MYSQL_HOST),stdout=subprocess.PIPE,shell=True)
- DATABASE_NAME=database_cmd.stdout.read().split()
- for DATABASE in DATABASE_NAME:
- MYSQLDUMP_FILENAME="/mysql_backup/%s%s.sql"%(CUR_TIME,DATABASE)
- subprocess.call("mysqldump -u%s -p%s -h%s %s>%s" %(MYSQL_USER,MYSQL_PASS,MYSQL_HOST,DATABASE,MYSQLDUMP_FILENAME),shell=True)
- if os.path.isfile('${DEL_TIME}${DATABASE}.sql'):
- subprocess.call("rm ${DEL_TIME}${DATABASE}.sql",shell=True)
-
- mysqldump()
本文转自it你好 51CTO博客,原文链接:http://blog.51cto.com/itnihao/1174898,如需转载请自行联系原作者