23 Jun 2008, 03:10
#1
New Zenner
- Join Date:
- Feb 2008
- Posts:
- 8
- Plugin Contributions:
- 0
Automated Nightly DB Backup Script?
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
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
