I want to upload 2 different MySQL databases into one neo4j db using APOC, how should I get started? Please keep in mind I do not want to use fabric to query across multiple neo4j instances, for purposes of visualizing the whole db for the project I'm working on.
There is an post on it here:
But a short answer is download the jar connector file from here:
Add it to the Neo4j
dbmss-*****/plugins directory. Restart database.
Run this to list all tables in the database dbname:
call apoc.load.jdbc("jdbc:mysql://localhost:3306/dbname?user=dbuser&password=dbpassword", "SELECT table_name,TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'dbname'") yield row with row,toInteger(row.TABLE_ROWS) as antal where antal>0 return row