[Leaplist] database backup tips?

[Jason Boxman]

On Friday 30 January 2009 17:47:25 tom foster wrote:
<snip>
>
> * I'm not sure on which machine to run the
>   cronjob--remote, or local, or both?  one on the
>   remote to dump and compress, one on the local to
>   slurp and decompress and wget?

I'd run it on the backup system and simply use ssh to execute a remote 
command:

ssh user at host 'mysqldump ...' | cat > /tmp/mydump.sql

I think that'd work, though untested.  It'll pipe the whole thing over SSH to 
the local system for you.  (You'll need ssh keys configured for it to work 
via cron, though.)

I do something similar right now as a post-run script with Dirvish.


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.