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?
remote_dir=/what/ever
dst=remote-system.host.name.com
scp $dst:`ssh $dst ls -1td $remote_dir/\* | head -1` /tmp/lastmod