Cheap backups via google mail
If you need or want a cheap(free) remote backup option for a small website, consider using google’s generous mail service.
This script runs in the middle of the night each day:
#!/bin/bash
#Make dump of the database from mysql
mysqldump –user=dbuser –password=dbpass –databases dbname –opt –quote-names –complete-insert | bzip2 -c > /tmp/dbbackup.bz2
#Move yesterdays backup to .old, just in case [...]