Migrate neo4j.dump from AuraDB 4 to be used on Neo4j Desktop db 5

Greetings,

I am using AuraDB Professional version 4. I am trying to migrate our exported neo4j.dump file into a Neo4j 5 (.13 or greater, the latest .24 would be best, something that allows for working with vector embedding queries) using Neo4j Desktop. I do not want to follow this process...

which leads to

...because again I'm using AuraDB Professional AND I do not want to create new AuraDB instances ($$$) on our account. I simply want to work with the 4 version neo4j.dump in Neo4j Desktop 5.

I have tried a number of different 'load' 'migrate' 'copy' queries from the terminal commands which point to my Neo4j Desktop 5.24.0 database, but nothing seems to be working.

There does not appear to be a simple soup to nuts/practical/pragmatic, explanation/demonstration of how to do this. If there is, please point me to it.

Many Thanks,

ka

1 Like

@kave

Odd in that

I have tried a number of different 'load' 'migrate' 'copy' queries from the terminal commands which point to my Neo4j Desktop 5.24.0 database

and specifically migrate and copy did not work ?

Did you run neo4j-admin database copy and or neo4j-admin database migrate from the path where 5.24.x was installed? Documentation at Migrate your databases - Upgrade and Migration Guide indicates these are 2 ways to move from a v4x to v5x database?

What was the result of the command (i.e. migrate or copy)?
What was the result when attempting to then start with Neo4j v5x ?

Thanks so much for your quick response Dana. Here's what I'm doing...

From the page you cited Migrate your databases - Upgrade and Migration Guide Restore the database on Neo4j 5 Step 1.

I have a neo4j.dump file that has been exported from my AuraDB 4 Snapshots. A .dump file seems to be the only format I can export from AuraDB 4.

In my Neo4j Desktop, I have created a new Graph DBMS of 5.24.0 and having clicked the + Add button, I have added this neo4j.dump file to this project (though there seems to be some issue around its placement in this dir). Assuming the dir of the added neo4j.dump file is correct, I open a terminal for this Graph DBMS and run the Step 1 cmd:

bin\neo4j-admin database restore neo4j --from-path=neo4j.dump

This returns an error saying the Path 'C:\Users\user.Neo4jDesktop\relate-data\dbmss\dbms-abc-123\neo4j.dump' does not exist. So out of the gate I have to figure out where Desktop would prefer I put this file for restore.

I copied the neo4j.dump file and put it in the root dir for dbms-abc-123 and ran the cmd again. This time I get the error of --from-path option should contain only backup artifact files (ending with '.backup').

I don't know how to get AuraDB 4 to export a snapshot as a .backup file and the documentation seen here Backup your databases - Upgrade and Migration Guide doesn't show how I would create a .backup file from AuraDB 4. The documentation on this page uses cmd line and I don't know how to run cmd line against an AuraDB instance either in the AuraDB admin or from Neo4j Desktop.

@kave
Part of the issue and as described at Backup and restore - Operations Manual is that one can create either a online Database Backup or a offline Database Dump through neo4j-admin backup and neo4j-admin dump ( v4.4x syntax) and then one needs to run the converse to either Restore ( neo4j-admin database restore ) or Load ( neo4j-admin database load) respectively and in v5x syntax.

Given you have a .dump file you would need to run neo4j-admin database load similar to

bin\neo4j-admin database load --from-path=c:\dumps\ neo4j --overwrite-destination=true

and with the neo4j.dump located in c:\dumps.

Once loaded you will then need to run neo4j-admin database migrate