What is the easiest way to backup a single database (all tables) to another server and even put a copy of the backup on the same server if possible.
edit: via CRON
I have root access to both servers.
Also, can you make it so the command names the file "DD-MM-YY.sql". (or a gzip ...)