Python实现备份MySQL数据库的方法示例_Python

Python实现备份MySQL数据库的方法示例

2021-01-04 00:23郭一军_guoyJoe Python

这篇文章主要介绍了Python实现备份MySQL数据库的方法,涉及Python针对mysql数据库的连接及基于mysqldump命令操作数据库备份的相关实现技巧,需要的朋友可以参考下

本文实例讲述了Python实现备份 MySQL数据库的方法。分享给大家供大家参考，具体如下：

									#!/usr/bin/env python

									# -*- coding:utf-8 -*-

									#导入模块

									import MySQLdb

									import time

									import datetime

									import os

									"""

									 Purpose: 备份数据库

									 Created: 2015/5/12

									 Modified:2015/5/12

									 @author: guoyJoe

									"""

									dbUser='root'

									dbPasswd='root'

									dbHost='192.168.1.6'

									dbCharset = 'utf8'

									backupDir = '/u02/backup/mysql'

									backupDate = time.strftime("%Y%m%d")

									#查出MySQL中所有的数据库名称

									sqlStr1 = "show databases like 'db%'"

									try:

									  connDB= MySQLdb.connect("192.168.1.6","root","root","test" )

									  connDB.select_db('test')

									  curSql1=connDB.cursor()

									  curSql1.execute(sqlStr1)

									  allDatabase = curSql1.fetchall()

									  print 'The database backup to start! %s'  %time.strftime('%Y-%m-%d %H:%M:%S')

									  for db in allDatabase:

									    dbName = db[0]

									    fileName = '%s/%s_%s.sql' %(backupDir,backupDate,dbName)

									    print fileName

									    if os.path.exists(fileName):

									        os.remove(fileName)

									    os.system("mysqldump -h%s -u%s -p%s %s --default_character-set=%s > %s/%s_%s.sql" %(dbHost,dbUser,dbPasswd,dbName,dbCharset,backupDir,backupDate,dbName))

									  print 'The database backup success! %s' %time.strftime('%Y-%m-%d %H:%M:%S')

									#异常

									except MySQLdb.Error,err_msg:

									  print "MySQL error msg:",err_msg