Automated Nightly DB Backup Script?

[saschwarz]

I'm using the database backup plugin from within the Admin screens to manually create database backups before/after modifications.

But I'd like to set up a cron job that I can run each night that:
1. puts my store into maintenance mode
2. does a full database dump to the local file system (I use rsync to copy the daily diffs to a remote server)
3. puts my store back into production

I figured this must be a common need but after searching the forums I didn't find anything. I was hoping someone could share their solution?

Best Regards,
Steve

[kobra]

I can email you one that does all but not the maint mode that you can cron

email m via my sig

[saschwarz]

Thanks a lot kobra.

It took me a while to find it but there is also this script which emails the compressed backup to the specified email address:
http://www.zen-cart.com/forum/showthread.php?t=60074

[kobra]

The one I sent you also does this:

Find this in the file and change to your email address

# Email Address to send mail to? ([email protected])
MAILADDR="[email protected]"

[DrByte]

I can email you one that does all but not the maint mode that you can cron

Perhaps posting it publicly may allow others to benefit from it as well.

[kobra]

DrByte,

Check your mail