I'm looking for a backup solution for multiple web applications that exist in code (flat files) and an associated mysql database. I'd like the code backups to be grouped with the DB backups by name/location. I'd also like redundancy, with backups going to a local drive and a remote network drive.

I'm just about done writing a bash script that does a combination of tar/gz and mysqldump per application. Once it's done, I'll throw it in a cron job, and enable/disable sites by name in the script.

Before I go further down this path, does anyone recommend a solid package that already exists? Does Bacula fit the bill?

Another tool that seems popular is amanda/zmanda eg http://www.zmanda.com/quick-backup-setup.html