mlistdata-mysql-neo4j
mlistdata-mysql-neo4j copied to clipboard
pramttl
An example which shows how to migrate MySQL to Neo4j data. I cannot provide the data as it is private but I have provided the equivalent SQL schema and the Property Graph Models that both represent a...
Mysql to Neo4j migrations for mailing list data
Contains scripts for migrating MySQL data to Neo4j Graph database. Before you migrate you need to prepare your Neo4j property graph model and know the schema of your Mysql data.
These migrations have been carefully designed so that running these migrations multiple times does not create extra nodes or relationships.
These scripts are schema dependent so you might need to tweak it for your use case. It was written for our own use case and database schema but it can serve as a good example of how to write a migration script for your MySQL data to import it into a Neo4j graph dataabse.
Instalation
cd <project-dir>
virtualenv venv
source venv/bin/activate
pip install -r requirements.txt
Usage
These commands are to be run on the shell in strict sequence for migrations to work perfectly.
python migrate_1_mailing_lists_people.py
python migrate_2_messages.py
python migrate_3_people.py
ER Model for data used in MySQL database:
pramttl