I support a couple of low-traffic sites that have reasonable user-loaded multimedia files and semi-set databases. My goal is to backup all data that is not versioned in a central location.
My current approach
I am currently using a nightly cronjob, which uses dumpdatato dump the entire contents of the database into JSON files in a project subdirectory. Media loading is already in the project directory (c media).
After resetting the database, the files are copied using rdiff-backup(makes an incremental backup) to another location. Then I load the rdiff-backup directory on a regular basis with the help of rsyncstoring a local copy.
Your ideas
What do you use to back up data? Submit your backup solution - if you have only a few hits per day on your site or if you maintain high traffic with shared databases and several file servers :)
Thanks for your input.
source
share