Module: Managing a DB Exercise #2 not able to load movieDB

General Graph Academy
1

I am trying to run the instruction shown below on my computer running Ubuntu 18.04:

  1. Download this file. This file contains the Cypher statements to load the database with movie data.
  2. Invoke cypher-shell sending movieDB.cypher as input. You should see something like the following:

I input the following command inside the folder containing mobieDB.cypher:

cypher-shell -u neo4j -p a-password < movieDB.cypher

The terminal pauses and then give blank output. I look in /var/lib/neo4j/data/databases and the only db in there is graph.db. Running the command in step 11 returns no nodes as well.

Is anyone else running into this issue? What should I do to load the DB?

2

Hello ,

Can log into cypher-shell without providing the movieDB.cypher ?

That is:

cypher-shell -u neo4j -p password

where password is whatever password you set for the database?

Elaine

3

Yes, I can log in successfully.

MATCH (p:Person) WHERE p.name='Tom Cruise' RETURN p.name, p.born;

After logging in, this returns 0 rows.

4

Does the moviedb.cypher file have Cypher statements in it? Is it possible that the download did not complete properly?

Elaine

5

It did not. Turns out my first statement piped output of cypher-shell INTO mobieDB.cypher (had > instead of <) so it was filled with printed data instead of cypher statements...duh.

6

Good news!

Good luck with the rest of the course. It is a bit challenging.

Elaine