# 環境: python3.xdef getExportDbSql(db, index): # 獲取導出一個數據庫實例的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): # 生成數據庫導出的語句保存到文件if not fname or not dbList:return Falsef = 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 Truereturn Falsedef initDb(user, pwd, host, port, server_name, indexList): # 生成db字典對象并返回db = {}db['user'] = userdb['pwd'] = pwddb['host'] = hostdb['port'] = portdb['server'] = server_namedb['indexList'] = indexListreturn 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生成一个导出数据库的bat脚本文件的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。