Export AuraDB as CYPHER for later import in local DB

[villadsclaes2]

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.

[villadsclaes2]

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 · Accepted solution]

I needed to add YIELD like this: 

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

[glilienfield]

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