cancel
Showing results for 
Search instead for 
Did you mean: 

Export database - AWS Community AMI

Hi everyone,

We are having troubles with the Neo4j Community AMI, https://eu-west-2.console.aws.amazon.com/ec2/v2/home?region=eu-west-2#LaunchInstanceWizard:. We need to export the data to other database, but we cannot use the apoc procedure:

CALL apoc.export.cypher.all("all-plain.cypher", { format: "plain", useOptimizations: {type: "UNWIND_BATCH", unwindBatchSize: 20} }) YIELD file, batches, source, format, nodes, relationships, properties, time, rows, batchSize RETURN file, batches, source, format, nodes, relationships, properties, time, rows, batchSize;l

It thows the next error:

Failed to invoke procedure `apoc.export.cypher.all`: Caused by: java.lang.RuntimeException: Export to files not enabled, please set apoc.export.file.enabled=true in your apoc.conf

We tried to install apoc in our server. the .jar file was present, and we followed this steps:

  1. Download the apoc-<version>.jar into the /var/lib/neo4j/plugins directory
  2. chown neo4j:neo4j apoc-<version>.jar
  3. chmod 755 apoc-<version>.jar
  4. Open the neo4j.conf at /etc/neo4j/neo4j.conf and replace the line #dbms.security.procedures.whitelist=apoc.coll.*,apoc.load.* with dbms.security.procedures.whitelist=apoc.coll.*,apoc.load.*,apoc.* and save it.
  5. Restart the Neo4j service by issuing the command systemctl restart neo4j

Note: Make sure that you have the right version of apoc jar downloaded. I'm using the neo4j version 3.5.5 and the apoc jar version I'm using is apoc-3.5.0.3-all.jar . Also make sure that you have the dbms.directories.plugins=/var/lib/neo4j/plugins uncommented in the /etc/neo4j/neo4j.conf

The problem is that each time we run:

systemctl restart neo4j

It resets the neo4j.conf to the original configuration.

Anyone knows how we can export this data?

Thanks in advance!

0 REPLIES 0
Nodes 2022
Nodes
NODES 2022, Neo4j Online Education Summit

On November 16 and 17 for 24 hours across all timezones, you’ll learn about best practices for beginners and experts alike.