themotte / tildes

Other
11 stars 16 forks source link

Automatic backup solution #19

Open zorbathut opened 4 years ago

Deimos commented 4 years ago

There's a script included that dumps the entire database to a file, compresses it, encrypts it with GPG, and then uploads to an FTP: https://github.com/themotte/tildes/blob/master/tildes/scripts/backup_database.py

It keeps backups locally for 7 days, and remotely on the FTP for 30 days and will delete any older than that in both places.

Make sure you read the requirements at the top, because it will probably just crash with some random error if those aren't set up.

The way to run it in my crontab just looks like: cd ~/backup && /opt/venvs/tildes/bin/python /opt/tildes/scripts/backup_database.py --host <ftp hostname> --gpg-recipient <gpg recipient email address>