Export AuraDB as CYPHER for later import in local DB

[villadsclaes2 (Villadsclaes)]

I have used

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

But i just want a long cypher that creates all the nodes and relationships and assign new IDs to them.

[glilienfield (Gary Lilienfield)]

According to the docs, You need to include ‘cypherStatements’ in the ‘yield’ statement. It should have the cypher.

[villadsclaes2 (Villadsclaes)]

I got the CYPHER from Aura with this:

CALL apoc.export.cypher.all(null,{stream:true})

Which gives me an entire table. How do I just get the cypherStatements?

[villadsclaes2 (Villadsclaes)]

I needed to add YIELD like this:

CALL apoc.export.cypher.all(null,{stream:true})
YIELD cypherStatements
Return cypherStatements