IMPORT or RESTORE specific vertex types or edges?

GSQL
#1

I have read the BACKUP and IMPORT / EXPORT specifications, and these are clearly meant to do a full backup and restore. But is there a way to just restore a specific vertex type and edge types? Here is the scenario: You have a weekly restore of a test instance from a prod instance. Some work is done directly in the test instance for a specific vertex type.

So rather than wipe out everything, I would like the following:

  1. export test
  2. restore from prod
  3. restore just a specific vertex type and edges from the test export

Is that possible?

#5

Hi Mark,

It is possible, but may take you a few steps.

You can

  1. dump the text edge on disk in CSV format with a query
    https://docs.tigergraph.com/dev/gsql-ref/querying/output-statements-and-file-objects#file-println-statement

  2. after restore from prod server, load the CSV files in with a loading job.

Thanks.

1 Like