How do I get a dump of PaaS environment database to local machine

daniel.gebhard

I want to debug a certain error case on my PaaS environment, therefore I would like to work with this on my local machine. How do I create a dump of the database to be able to use it on my local machine?

fsmeier

Heyhey @daniel.gebhard ,

I asked our cloud team and basically there are multiple possibilities:

One is to use mysqldump being connected to the env via respective VPN.
Creds can be found in the AWS ECS -> Task Definitions -> zed\boffice.

If it's a live Prod, it makes sense to ask the support to provide the dump because dumping directly from live prod DB will lock it.
And support can do it in two ways:
1) in case there as internally used RO replica, they will dump it instead of the main one
2) they can restore 1h old snapshot and dump it instead of the main one.
And then they can put the dump into S3 where you will just need to download it to the local.

Hope this helps :)

All the best,

Florian

fsmeier

Heyhey @daniel.gebhard ,

I asked our cloud team and basically there are multiple possibilities:

One is to use mysqldump being connected to the env via respective VPN.
Creds can be found in the AWS ECS -> Task Definitions -> zed\boffice.

If it's a live Prod, it makes sense to ask the support to provide the dump because dumping directly from live prod DB will lock it.
And support can do it in two ways:
1) in case there as internally used RO replica, they will dump it instead of the main one
2) they can restore 1h old snapshot and dump it instead of the main one.
And then they can put the dump into S3 where you will just need to download it to the local.

Hope this helps :)

All the best,

Florian

daniel.gebhard

Hey @fsmeier,

thanks a lot! That helps me alot, local dump from DEV works perfectly.

Greetings,

Daniel