Example how to migrate a table from a mySql database to a mongoDB

migrateFromMysqlToMongo.py

import pymysql
import pymongo

# Set mongo connection
connection = pymongo.MongoClient(host_mongo, port_mongo)
db = connection[bd_mongo]
db.authenticate(user_mongo, pass_mongo)
notes = db.collection_name

# Set mysql connection
conn = pymysql.connect(host='127.0.0.1', user=user_mysql, passwd=pass_mysql, db=db_mysql)
cur = conn.cursor()

cur.execute("select * from table order by id")
for r in cur:
    # f = open(str(r[0])+"-"+r[1]+".txt", "w+")
    # f.write(r[3])
    # f.close()
    note = {"title": r[1], "content": r[3]}
    print(notes.insert_one(note).inserted_id)

# Close connections
cur.close()
conn.close()
connection.close()