I wanted to move batabases to a a new remote db from what we had previously where database and our core API server was hosted in the same instance.
To do this I have to scp which is basically ssh but for copying files.
You go to the location of your perm keys or just describe the location and then the
host alonside the
file location with a single ”:” between these two properties.
And the last string you’re adding to this command line is the location you want to download it to and of course whatever you want the file to be called.
This was the result when I downloaded the file.
scp -i dev_backend_key.pem email@example.com:/var/www/dump.sql /Users/your_name/backend_server
100% 673KB 1.5MB/s 00:00
NB: You can decide to pull the schema without the data or do both. I did both for my situation.