SSH file from server to local machine

Question

I know there is SCP and show that the file has been downloaded succefully but I can't find the file on my computer and for some reason it upload the file to different folder on my server instead of my local machine

scp -P 2222 username@server:/home/username/www/filename.sql .

I check many post on stackoverflow + lot of forums ... out of solution

Answer 1

I guess you may be running the command on your server (from within a ssh window on your local machine). You should be running it on your local machine (in a local shell window).

For clarity, it can help to make the command prompt include the hostname so you know which computer is executing the command.