How do I set up a regular backup of my database?

[Jeanco]

I know I can do it manually in phpMyAdmin, but is there a way to set up a scheduled back-up say once a day?

It would be even better if I could set up some sort of cycle where at any one time I'd have 7 versions backed up (Monday-Sunday) and each day that backup would overwrite its old version (that is, on Monday the db backup would be saved over the old Monday backup, and on Tuesday it would be saved over the Tuesday backup).

Just in case something goes unnoticed for a couple days I would have the ability to jump back to a given day within a week.

Thanks

[eron19]

Take a look at this:
http://www.ducea.com/2006/05/27/back...tomysqlbackup/

[Jeanco]

Thanks, I'll take a look