Download an sql file using ssh

How are we doing? Please help us improve Stack Overflow. Take our short survey. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Ask Question. Asked 9 years, 11 months ago. Active 5 years, 5 months ago. Viewed 46k times. What commands I can use at ssh to export download mysql database using SSH? Improve this question. Add a comment. Active Oldest Votes. Improve this answer.

AlphaMale AlphaMale Thanks it worked but now the file is at root directory how can I move it to another folder? For example, the command used for this example is:. Open up a command line in Windows. Windows 10 already has SCP installed by default. The color contrasts with the yellow, and syntax highlighting is a nice change from the drab command line.

As you can see, you first need to confirm the connection using the RSA fingerprint of the remote server. Replace [UserName] with your own Windows username. Each RSA fingerprint is added on a new line. This allows you to clear them easily by deleting an entire line at once if you ever need to remove an entry. Navigate to the location you specified in your SCP command and the file should be visible. SCP is the most direct way to transfer files from remote servers to local systems.

It makes use of the same SSH protocols, so the connection is encrypted all the way through, making it immune to man-in-the-middle attacks. Hopefully, this tutorial will help you use it in an efficient, and easy manner. If this tutorial helped you move files from your remote server to your local machine, maybe consider sharing this knowledge with your friends by using our share shortcuts.

You can also leave any additional tips or questions in our comment section below. Thank you.