JAMROOM
DB and System Backup
-
The DB and System Backup module backs up your Database, modules, skins and Profile Media on a daily basis to Amazon S3.
Overview
Requires system() access to mysqldump to work properly, as well as a working Amazon Web Services account:
https://aws.amazon.com/
The DB and System Backup module uses Reduced Redundancy storage on S3 to lessen backup storage costs.
the DB backups are on a 7 day rotation, so after a week there will always be 7 copies of the database tables.
For the data, if the file already exists on S3 and has not been changed in JR, it is not copied back up. The data backup is not "rotated". -
From "DB and System Backup" version 2.0 the "Amazon Web Services SDK" module is required.
Make sure you install the "Amazon Web Services SDK" module if updating.
Marketplace: "Amazon Web Services SDK"
https://www.jamroom.net/the-jamroom-network/networkmarket/537/amazon-web-services-sdk -
Q: Is there a pruning feature of any sort?
Q&A
A: There is no pruning of media files at this time - the DB files are pruned though and only the most recent 7 days are kept. Part of the issue of pruning media is that it (could) require a lot of queries into the local system and S3 to try to find all the matching media files that are no longer in the system, which on a large system could take a VERY long time. - See more at: https://www.jamroom.net/the-jamroom-network/networkmarket/22/db-and-system-backup
Q: Is there an email notification feature that will email you on backup completion, failure, success?
A: Email on success/failure is a good idea. Right now everything is logged to the activity log, so you can use the Activity Log Watch module to trigger an email on a success or failure.
Q: what if your previous backup is bad/corrupt? You would need to backup to a different one?
A: restore from a specific date would work for the DB, not for media files (but probably still worth it).
