DB Backup/Restore Strategies

I know that Xano only supports full Instance backups for three days. This is helpful, but the backups revert everything, including function stacks in every branch. Curious to hear what approaches anyone is using to backup just their data and have the ability to restore in case of an issue. Some ideas our team had:

  1. Sign up for direct DB access and write a process to extract the databases periodically and store them in a GCP bucket.
  2. Create a task that pulls the data via the function stack, converts to CSV, then ships them off to GCP for storage.

Curious if anyone is doing either of these and if if you'd had success with it? Any other approaches out there that people have had success with?

Other
2 replies