Neo4j Desktop Terminal - How to Load a Dump File into a Local Database

[knuser]

Greetings,

I am trying to use the Neo4j Desktop Terminal v1.5.7 to load a neo4j.dump file 8mb into a local db. The database server being used is 4.4.0.

I have added the neo4j.dump file using the Add > File button.

The neo4j.dump file now exists in my Project > File folder: C:\Users\owner.Neo4jDesktop\relate-data\projects\project-1649d707-9d31-c9271901a49d\neo4j.dump

I opened the terminal, and ran the following command:

C:\Users\owner\.Neo4jDesktop\relate-data\dbmss\dbms-b9a39309-7017-57235f0-55cfe> bin\neo4j-admin load --from=neo4j.dump --database=neo4j --force

This does not work the terminal responds with:

Archive does not exist: neo4j.dump

How does it not exist? I added it and can see it both in the ND under File and I can see the file by going to Reveal in File Explorer?

And if I put the neo4j.dump file in either the root folder of C:\Users\owner.Neo4jDesktop\relate-data\dbmss\dbms-b9a39309-7017-57235f055cfe or the [same path]\import, this too will not work and the terminal responds with:

Done: 0 files, 0B processed.
Unable to load database: NoSuchFileException: C:\Users\owner\.Neo4jDesktop\relate-data\dbmss\dbms-b9a39309-7017-57235f055cfe\data\databases\neo4j\.\profiles\neostore.nodestore.db.labels.321.cacheprof

What am I doing wrong to load a .dump file into my local db in Neo4j Desktop?

[elaine_rosenber (Elaine Rosenberg)]

Is the version of the dump file also 4.4? If it is the same version then you should be able to create a database from the dump file.

If you use neo4j-admin load, you should provide the full path to the dump file.

[knuser]

Thanks @elaine_rosenber , yes the dump file is from AuraDB and is 4.4.0.

Yes, using the following command, I have also tried using the full path of the neo4j.dump file that I have previously loaded into the local db using Add > File. The neo4j.dump file resides in this dir
C:\Users\owner.Neo4jDesktop\relate-data\projects\project-1649d707-9d31-c9271901a49d\neo4j.dump
and I have used that full path in the command:

C:\Users\owner\.Neo4jDesktop\relate-data\dbmss\dbms-b9a39309-7017-57235f0-55cfe>bin\neo4j-admin load --from=C:\Users\owner\.Neo4jDesktop\relate-data\projects
\project-1649d707-9d31-c9271901a49d\neo4j.dump --database=neo4j318 --force

But I still get the same error seen above:

Selecting JVM - Version:11.0.17+8-LTS, Name:OpenJDK 64-Bit Server VM, Vendor:Azul Systems, Inc.
Done: 0 files, 0B processed.
Unable to load database: NoSuchFileException: C:\Users\owner\.Neo4jDesktop\relate-data\dbmss\dbms-b9a39309-7017-57235f0-55cfe\data\databases\graph318\.\profiles\neostore.nodestore.db.labels.321.cacheprof

[knuser]

Is there anything wrong with my command?
Could you please share a working load command that you use?

[elaine_rosenber (Elaine Rosenberg)]

When was the Aura dump file created?

[knuser]

Within the last week

[elaine_rosenber (Elaine Rosenberg)]

If it was created within the last week, then the version of the database used for the dump is 5.

[elaine_rosenber (Elaine Rosenberg)]

The version of the db used by AuraDB is 5.6 right now.

You cannot load a 5.6 dump file into a 4.x DBMS.

Can you create a 5.6 or 5.5 DBMS in Desktop? Then you should be able to load it from Neo4j Desktop.

[knuser]

Don't the following pics from AuraDB indicate I'm using 4.4.0?

[elaine_rosenber (Elaine Rosenberg)]

Is the AuraDB instance still running? If so, when you connect with Neo4j Browser, what is returned with:

CALL dbms.components YIELD name, versions, edition

[knuser]

The same as what is seen in the pics above...

[elaine_rosenber (Elaine Rosenberg)]

If you have a 4.4 DBMS started in Neo4j Desktop, you should be able to right-click the dump file and select add to DBMS. Can you do that?

Elaine

[knuser]

No I cannot, I have a separate question out for that specific process that also does not work.

Neo4j Desktop - Import a Dump File into a Database

Greetings, I am using Neo4j Desktop 1.5.7. The database servers being used are 4.4.0. I want to be able to import a dump file into my local Neo4j Desktop instance. This dump file was created in AuraDB from a snapshot. This dump file/data set has approx. 80k nodes, around 8mb. Again, all server versions are the same, 4.4.0. Using ND, I have a new project and I have added a neo4j.dump file using the button Add > File. The file now shows under the File section of the project. Then in the same…

I am hoping we can stay with this topic of loading a dump into a local database file using terminal commands.

[elaine_rosenber (Elaine Rosenberg)]

If you select the 3 dots to the right, do you see an option to load into DDMS?

[knuser]

Yes the ... exist, but again, I have a separate question out for that specific UI / Load functionality (which also does not work).
Can we please keep this question focused on doing this with the terminal?

If not, can you please respond to my other UI / Load question seen here...

Neo4j Desktop - Import a Dump File into a Database

Greetings, I am using Neo4j Desktop 1.5.7. The database servers being used are 4.4.0. I want to be able to import a dump file into my local Neo4j Desktop instance. This dump file was created in AuraDB from a snapshot. This dump file/data set has approx. 80k nodes, around 8mb. Again, all server versions are the same, 4.4.0. Using ND, I have a new project and I have added a neo4j.dump file using the button Add > File. The file now shows under the File section of the project. Then in the same…

[elaine_rosenber (Elaine Rosenberg)]

1. I opened a terminal window for the started DBMS.
2. I copied the absolute path for the dump file.
3. I loaded the new db from the dump file. (see screenshot)
4. I typed :USE SYSTEM
5. I typed CREATE DATABASE MyNewDB

I was then able to query the loaded db.

[knuser]

Thanks but I'm still getting the same errors.
I see you're using a Mac, any chance you can do this on Windows? The command syntax seems different, for example you have single quotes around your --from='path'. When I put single quotes around my path I get this error...

java.nio.file.InvalidPathException: Illegal char <:> at index 2: 'C:\Users\owner\.N
eo4jDesktop\projects\project-3728df8b-8456-607273ed2f95\neo4j.dump'

I see you suggested using --verbose on the other question (focused on UI).
--verbose responds with the following...

org.neo4j.cli.CommandFailedException: Unable to load database: NoSuchFileException:
 C:\Users\owner\.Neo4jDesktop\relate-data\dbmss\dbms-b9a39309-887a-57235f
055cfe\data\databases\neo4j320\.\profiles\neostore.counts.db.320.cacheprof

All of this leads me to believe that the --from I'm using is incorrect.
But I don't have any examples of a correct path to use on my Windows machine.

[elaine_rosenber (Elaine Rosenberg)]

I put quotes around the path to the db because my path had spaces in it which java didn't like.

In this community post, there is an example for Windows. I noticed that in this post, Dan suggests copying the dump file to a simpler location to use for the from value. He also changes directory to the bin directory to execute the load.

Failed to dump a database in Neo4j Desktop 4.3.5

I think you're running into a desktop issue unique to windows. The easiest workaround is: 1 - Stop the database. 2 - Open a terminal window for the database you want to dump. [image] 3 - Dump the database using the neo4j-admin command with the dump option: bin\neo4j-admin dump --verbose --database=neo4j --to=C:\dbdumps\mydb.dmp 4 - Use the neo4j-admin load option to restore to the database .\neo4j-admin load --from=C:\dbdumps\mydb.dmp --database=mydb --force neo4j-admin doc

[knuser]

Thanks Elaine, I'm losing confidence that there's a documented answer available for this specific situation. In the most recent link you provided, the --from part of the load command is pointing to a different dir than where Desktop puts my dump file after I use the Desktop Add > File feature.
After adding the dump file to a given project, my dump file lives here
C:\Users\owner.Neo4jDesktop\projects\project-3728df8b-8456-607273ed2f95,
but any attempts to point to that path in the command line --from result in the errors provided.
I'm trying to use all of the features and command lines that are natively provided in Neo4j Desktop, but the documentation around this seems to be lacking.

There are 2 Documentation sites listed under Desktop's Help & Learn section, but nothing speaks to loading dump files via terminal...
Neo4j Desktop Manual - Neo4j Desktop - Neo4j Desktop
User Interface Guide - Neo4j Desktop User Interface Guide - Developer Guides

Is there explicit documentation somewhere that speaks to using Desktop to load a dump file using the Desktop terminal on Windows? Or is there a youtube video that shows a successful Desktop load of a dump file using the Desktop terminal on Windows?

[elaine_rosenber (Elaine Rosenberg)]

Unfortunately, the documentation for neo4j-admin is what we have for loading a dump file into the DBMS. Starting a terminal window is the same as using the neo4j-admin command.

If your database does not contain private information, I would be curious why you cannot load it from the Neo4j Desktop UI? Can you share the dump file?