python 数据库备份_Python备份MySQL数据库的代码详解

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

本文实例讲述了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=con