petersteinberger.com

rsnapshot is the TimeMachine for servers. Get it via macports.
Next, configure /opt/local/etc/rsnapshot.conf.
Change snapshot_root to a directory you like (probably within /Users/xxx/Backups/)
Uncomment cmd_ssh
Set the Backup Interval to
interval manual 20 (use tabs!)
Last, configure the server address. You want root for that, so be sure that public key auth is working on your remote machine.
backup root@yourserver.com:/ SubPathInBackupDir/ exclude=proc,exclude=sys,exclude=tmp
Done! Invoke with sudo [...]

be a bit creative on job conditions. people will love u.

cat ~/.ssh/id_rsa.pub | ssh user@domain.com "cat >> .ssh/authorized_keys2

Update: Even better, @zzamboni pointed me to << commandlinefu >>
the place to record those command-line gems that you return to again and again — Just use the searchbar on top
Howto copy text to clipboard: (mac only, for linux, use xclip, see here)
cat textfile | pbcopy
I’ll update this blog post as I stumble upon something new.

If phpmyadmin shows you that your table needs repair, just repair it (databases are wonderful
EDIT:  Realized that the linked blog article is just crap. Repair via phpmyadmin is nice, but you’re better of trying it with sqladmin.