Error when moving a file from my droplet to local

Posted on August 31, 2021

Storage

Building on DigitalOcean

By fcorrea

I want to copy to my local pc a backup of my database, wich is called db_backup.sql

I’m using scp like this: scp my_user@my_ip:/db_backup.sql C:\

I have windows 10 in my local pc so I’m just moving it to the C:\ partition.

The error I keep getting is: ssh: Could not resolve hostname c: Temporary failure in name resolution

Any ideas on how to solve this, or what am I doing wrong?

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

KFSys

September 1, 2021

Accepted Answer

Hi @fcorrea,

The best solution would be to do the SCP command from your Local Machine. Basically, open PuTTy or an SSH terminal if you have one(Newer versions of Windows allow you to have Ubuntu subsystem installed and from there you can use the terminal). Once you do, just run

scp root@YourDropletIPAddress:/path/to/sql_file /path/to/save/file

This will connect on port 22 to your Droplet and download the file at the location you specified.

alexdo

September 1, 2021

Hello, @fcorrea

You can transfer files from a local computer to a Droplet using a variety of different protocols and file transfer clients. We recommend using SFTP (SSH File Transfer Protocol) with FileZilla because it is a free, open-source, cross-platform tool with a user interface that supports newer users.

You can check the following tutorials:

https://www.digitalocean.com/community/tutorials/how-to-use-filezilla-to-transfer-and-manage-files-securely-on-your-vps

https://docs.digitalocean.com/products/droplets/how-to/transfer-files/

Regards, Alex