Skip to content

Instantly share code, notes, and snippets.

@garenyondem

garenyondem/sqlite_backup.sh

Created May 15, 2022 15:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save garenyondem/8679cdfcca026c01a3a6f600cbc9b329 to your computer and use it in GitHub Desktop.
Save garenyondem/8679cdfcca026c01a3a6f600cbc9b329 to your computer and use it in GitHub Desktop.
Download ZIP
Cron-based sqlite backup
Raw
sqlite_backup.sh
#!/bin/bash -x
# Ensure script stops when commands fail.
set -e
# Backup & compress our database to the temp directory.
sqlite3 /path/to/db '.backup /tmp/db'
gzip /tmp/db
# Upload backup to S3 using a rolling daily naming scheme.
aws s3 cp /tmp/db.gz s3://mybucket/db-`date +%d`.gz
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment