A Simple python Script to migrate data from MySQL to MongoDB
Author: ArJun Gawali (arjungawali111@gmail.com)
Date: 27 Oct, 2021
Version: 1.0.3
Purpose: Migrate Data from MySQL to Mongo
You can find the module here
You can install it with following command :
pip install mysql-to-mongo==1.0.3
How to use :
import mysql_to_mongo
mysql_to_mongo.migrate_all(mysqldb_dict,mongodb_host,mongodb_dbname)
Functions :
-
migrate_all : Migrate all tables from mysql to mongodb
-
Parameters :
-
mysqldb_dict : A Python dictionary of your mysql database details
Ex :
mysqldb_dict = {
"mysql_host" :"localhost",
"mysql_database" : "sample_database",
"mysql_user" : "root",
"mysql_password" : "*******",
}
-
mongodb_host : Your MongoDb hostname/Url
-
mongodb_dbname : Choose the name of Database in which the data has to migrate.
-
migrate_single : Migrate specified table
-
Parameters :
-
mysqldb_dict : A Python dictionary of your mysql database details
Ex :
mysqldb_dict = {
"mysql_host" :"localhost",
"mysql_database" : "sample_database",
"mysql_user" : "root",
"mysql_password" : "*******",
}
-
mongodb_host : Your MongoDb hostname/Url
-
mongodb_dbname : Choose the name of Database in which the data has to migrate.
-
table : Specific table which has to migrate
Change Log
1.0.1 (27/10/2021)
1.0.2 (27/10/2021)
1.0.3 (27/10/2021)
- how to use added in README.md