Python Backup Database

March into Python ...

Environment required for operation: PYTHON,MYSQLDB

Paste the Python script you wrote about SQL backup:

#!/usr/bin/env python
Import MySQLdb
Import OS
Import time
Datalist=[]
Remoteaddr= ' xxxx '
User= ' Root '
password= ' xxxx '
Dbconnect = MySQLdb.connect (%s,%s,%s)% (Remoteaddr,user,password)
Cursor=dbconnect.cursor ()
Sql= "Show Databases"
Cursor.execute (SQL)
Dbconnect.commit ()
Data=cursor.fetchall ()
For list in data:

# print List[0]
Datalist.append (List[0])
#print data
Print DataList
Datalist.remove ("Information_schema")
Datalist.remove ("MySQL")
Datalist.remove ("Test")
#print dataList
Dbconnect.close ()
Time=time.strftime ("%y-%m-%d")
Backup_dir= "/tmp/xiao/%s"%time
If not os.path.exists (Backup_dir):
Os.makedirs (Backup_dir)
Print "Backup directory created ..."
For MySQL in dataList:
mysqldump= "mysqldump-u%s-p%s-h%s%s>%s/%s.sql"% (User,password,remoteaddr,mysql,backup_dir)
Os.system (mysqldump)
Print "All databases are backuped ..."

This article from "The Young Master very busy" blog, please be sure to keep this source http://yingzi234.blog.51cto.com/3374280/1430377