Bash script to scp newest file in a directory on a remote server

Question

Ok so I kinda know how to do this locally with a find then cp command, but don't know how to do the same remotely with scp.

So know this:

scp -vp me@server:/target/location/ /destination/dir/.

That target directory is going to be full of database backups, how can I tell it to find the latest backup, and scp that locally?

Answer 1

remote_dir=/what/ever
dst=remote-system.host.name.com
scp $dst:`ssh $dst ls -1td $remote_dir/\* | head -1` /tmp/lastmod