/MySQL2MongoDB

A Python script to migrate MySQL table data to MongoDB collections

Primary LanguagePythonGNU Lesser General Public License v2.1LGPL-2.1

MySQL2MongoDB

A Python script to migrate MySQL table data to MongoDB collections

How to use this script

  1. Install MySQL and MoggoDB modules using the following commands from a Python shell:

    pip install mysql-connector-python pip install pymongo

  2. Assign values to the following variables in the script:

    delete_existing_documents = True; #if set to true, deletes all documents from the collection before inserting new ones.

    mysql_host="localhost"

    mysql_database="mydatabase"

    mysql_schema = "myschema"

    mysql_user="myuser"

    mysql_password="********"

    mongodb_host = "mongodb://localhost:27017/"

    mongodb_dbname = "mymongodb"

  3. Execute the script

For more information, please check this blog out: https://thedeveloperspace.com/migrate-mysql-table-data-to-mongodb-collections-using-python/