Does anyone here have a sample script to backup a database and related files then email it to an email account (gmail)?
The largest part of such a script is pretty well mapped out in this Dreamhost Wiki article on Automated Backup, though the script in the article is set-up for using ftp to deliver the backup. It shouldn't be too difficult to start with that, and add the email process if you are interested.
I use http://sourceforge.net/projects/automysqlbackup/ , it's great. But I have to confess that I don't know whether or not it can send you the actual file by email. But I think so.
Like my help? Enter promo code 2FORME and you get the maximum off for your plan, minus 2$ - for me.