Automatic backup solution

[zorbathut]

No description provided.

[Deimos]

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>