retrieving automated backup from google sql

Question

I would like to download an automated backup of my google cloud sql, my issue is, I have a client who accidentally deleted some data, and I am hoping using the latest automated backup I can pick and choose which to restore, by either restoring it to a different DB or some janky regex

From the options I see, I can only restore the whole thing.

Is there a way? I am in dire need of this capability.

one more thing, I am using postgres 9.6

Wahyu
– Wahyu

2017-05-02 21:26:46 +00:00
Commented May 2, 2017 at 21:26 — Wahyu
– Wahyu, Commented May 2, 2017 at 21:26

Wahyu · Accepted Answer · 2017-05-02 22:00:34Z

1

So turns out you can do it by:

Creating a new instance (not a new database)
Restore this instance to the backup you want

answered May 2, 2017 at 22:00

Wahyu

1033 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

retrieving automated backup from google sql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related