mongodb转mysql思路_脚本 将阿里云 mongodb数据转成mysql

思路：mongodb是阿里云上，有定时备份，用python脚本去下载备份文件，恢复到我的环境 中，用脚本查出数据转换成sql插入mysql.

我的环境python是2.7.5。注：mysql端要预先建设 好对应的表，表名和mongodb上的表同名。

api:

https://help.aliyun.com/document_detail/26226.html?spm=a2c4g.11186623.6.1308.77201b113JWEGG

pip install aliyun-python-sdk-core

pip install aliyun-python-sdk-rds

pip install aliyun-python-sdk-dds

cat mongo_dload_backup.py

#!/usr/bin/env python

#coding=utf-8

import sys,os

from aliyunsdkcore.client import AcsClient

from aliyunsdkcore.acs_exception.exceptions import ClientException

from aliyunsdkcore.acs_exception.exceptions import ServerException

from aliyunsdkdds.request.v20151201.DescribeBackupsRequest import DescribeBackupsRequest

# AccessKeyID,AccessKeySecret 从阿里账号上查看 。

client = AcsClient('AccessKeyID', 'Acces