Automated database backup solution?

[LurkerLou]

I want to backup the database nightly but not want to sit at a computer and do it manually. Is there an automated way to do this? I do most of my work on a Mac.

 

[Paul B]

http://xenforo.com/community/resources/auto-database-backup-script.1664/

 

[MattW]

Back it up to where?

Here is a set of scripts I released on here: http://xenforo.com/community/resources/auto-database-backup-script.1664/

EDIT: Ninja'd again!

 

[Floren]

I want to backup the database nightly but not want to sit at a computer and do it manually. Is there an automated way to do this? I do most of my work on a Mac.

What happens if your disks fail? Backing up just the database is not enough. You need to backup the entire site, including the physical files, attachments etc. A proper solution would be an rsync of your /html directory and a db backup.

 

[LurkerLou]

I back up the site whenever I make a change to it. The DB I will be backing up nightly.

 

[Floren]

I back up the site whenever I make a change to it. The DB I will be backing up nightly.

Are you aware of the attachment files posted by your users? There are physical data file changes done every day, not just your database.

 

[LurkerLou]

Attachments are disabled.