Error when moving a file from my droplet to local

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?

Submit an answer
Answer a question...

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!

Sign In or Sign Up to Answer

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.

Site Moderator
Site Moderator badge
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.

Site Moderator
Site Moderator badge
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:

Regards, Alex

Want to learn more? Join the DigitalOcean Community!

Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.