import pymysql
import time
import datetime
import os
from itertools import chain
dbUser='root'
dbPasswd='Qwer_12345'
dbHost='192.168.18.134'
backupDir = '/root/backup/mysql/'
backupDate = time.strftime("%Y%m%d")
db = pymysql.connect('192.168.18.134','root','Qwer_12345','mysql')
cursor = db.cursor()
cursor.execute("show databases")
Alldatabasename = cursor.fetchall()
Alldatabasename = list(chain.from_iterable(Alldatabasename))
#Alldatabasename = Alldatabasename.split(",")
print(Alldatabasename)
db.close()
i = input("请输入要备份的数据库名称:")
if i in Alldatabasename:
cmd = 'mysqldump -u'+ dbUser + ' -p'+ dbPasswd +' '+ i + '>' + backupDir + backupDate + i + '.sql'
os.system(cmd)
print ('The database backup success! %s' %time.strftime('%Y-%m-%d %H:%M:%S'))
else:
print("%s 数据库不存在,请重新输入"% i)