實(shí)例如下：

# 環(huán)境: python3.xdef getExportDbSql(db, index):	# 獲取導(dǎo)出一個數(shù)據(jù)庫實(shí)例的sql語句	sql = 'mysqldump -u%s -p%s -h%s -P%d --default-character-set=utf8 --databases mu_ins_s%s > %s.s%d.mu_ins_%d.sql' %(db['user'], db['pwd'], db['host'], db['port'], index, db['server'], index, index)	return sqldef createDbBackupFile(fname, dbList):	# 生成數(shù)據(jù)庫導(dǎo)出的語句保存到文件	if not fname or not dbList:		return False	f = open(fname, 'w')	if f:		f.write('echo @off/n/n')		for db in dbList:			for index in db['indexList']:				f.write('REM %s.s%d/n' %(db['server'], index))				f.write('%s/n/n' %getExportDbSql(db, index))			f.write('/n')		f.close()		return True	return Falsedef initDb(user, pwd, host, port, server_name, indexList):	# 生成db字典對象并返回	db = {}	db['user'] = user	db['pwd'] = pwd	db['host'] = host	db['port'] = port	db['server'] = server_name	db['indexList'] = indexList	return dbdef displayDb(db):	print('user =', db['user'])	print('pwd =', db['pwd'])	print('host =', db['host'])	print('port =', db['port'])	print('server =', db['server'])	print('indexList =', db['indexList'])	print('/n')def displayList(list):	for item in list:		displayDb(item)if __name__ == '__main__':	db1 = initDb('root', '123456', '127.0.0.1', 3306, 'th1', [10000, 1, 3])	db2 = initDb('root', '123456', '127.0.0.1', 3306, 'th2', [10000, 1])		dbList = []	dbList.append(db1)	dbList.append(db2)	#displayList(dbList)		createDbBackupFile('export00.bat', dbList)

以上這篇利用python生成一個導(dǎo)出數(shù)據(jù)庫的bat腳本文件的方法就是小編分享給大家的全部內(nèi)容了，希望能給大家一個參考，也希望大家多多支持武林站長站。