How can I roll back?

Neo4j Graph Platform
1

I typing the command by mistake

merge (c:Company)

set c.name='CTCP Đại lý Vận tải SAFI',

c.code='SFI',

c.currentShare=24887046,

c.ipoDate='29/12/2006',

c.ipoPrice=110000,

c.numberOfShareIPO=1138500

return c

And it create the new node and set all the old note to the new value.

How can I roll back please?

2

You merged without any constraints, so it found every Company node and set their values to the new ones.

There is no way to rollback. Do you have a backup?

3

I haven't do the back up.

Yes, This is my mistake.

4

You should have used CREATE instead of MERGE, then you would only have created a new node. MERGE first matches existing nodes and only creates a new one if no existing node was found.

5

Unfortunately, the only way is from a backup or a repriming of the data from the source. Been there, done that. Since then, my company takes a backup each night and restores in another environment. That way we can test any manual update scripts before applying in production.