Its the easiest way to do backups. Just set up a cron job (we could write one that would run in scoop, that might be nice, with a var for where to backup the db to... mmm... I'll write that one down.
To use mysqldump to backup the db:
prompt$ mysqldump -u scoopuser -p scoopdb > scoopdbbackup.sql
Password: <shh!>
...
prompt$
And thats it! Wouldn't be hard to write a little cron for that, at all.
Regarding a backup scoop cron: I think a var would be really handy that could be keep_snapshot_every and have values similar to the cron stuff, 1d, 1w, 1y, etc. Then the cron would do a full backup every night (or every time its set to run) and keep a snapshot every week. For the nightly backups, they would get deleted one week later, to save space. That way, you'd have nightly backup for a week, and keep_snapshot_every timeframe backups for as long as you've been running cron. Sound like a good idea? oooh. Another var, compress_backups! I really like this idea. Hear hear janra!
-hurstdog
