jacobtomlinson/sqlite-to-s3
Backup and restore sqlite databases from s3
Image
1
1.6K
jacobtomlinson/sqlite-to-s3 repository overview
Docker SQLite to S3 
This container periodically runs a backup of a SQLite database to an S3 bucket. It also has the ability to restore.
Usage
Default cron (1am daily)
docker run \
-v /path/to/database.db:/data/sqlite3.db \
-e S3_BUCKET=mybackupbucket \
-e AWS_ACCESS_KEY_ID=AKIAIOSFODNN7EXAMPLE \
-e AWS_SECRET_ACCESS_KEY=wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY \
-e AWS_DEFAULT_REGION=us-west-2 \
jacobtomlinson/sqlite-to-s3:latest
Custom cron timing
docker run \
-v /path/to/database.db:/data/sqlite3.db \
-e S3_BUCKET=mybackupbucket \
-e AWS_ACCESS_KEY_ID=AKIAIOSFODNN7EXAMPLE \
-e AWS_SECRET_ACCESS_KEY=wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY \
-e AWS_DEFAULT_REGION=us-west-2 \
jacobtomlinson/sqlite-to-s3:latest \
cron "* * * * *"
Run backup
docker run \
-v /path/to/database.db:/data/sqlite3.db \
-e S3_BUCKET=mybackupbucket \
-e AWS_ACCESS_KEY_ID=AKIAIOSFODNN7EXAMPLE \
-e AWS_SECRET_ACCESS_KEY=wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY \
-e AWS_DEFAULT_REGION=us-west-2 \
jacobtomlinson/sqlite-to-s3:latest \
backup
Restore
docker run \
-v /path/to/database.db:/data/sqlite3.db \
-e S3_BUCKET=mybackupbucket \
-e AWS_ACCESS_KEY_ID=AKIAIOSFODNN7EXAMPLE \
-e AWS_SECRET_ACCESS_KEY=wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY \
-e AWS_DEFAULT_REGION=us-west-2 \
jacobtomlinson/sqlite-to-s3:latest \
restore
Environment Variables
| Variable | Description | Example Usage | Default | Optional? |
|---|---|---|---|---|
S3_BUCKET | Name of bucket | mybucketname | None | No |
S3_KEY_PREFIX | S3 directory to place files in | backups or backups/sqlite | None | Yes |
AWS_ACCESS_KEY_ID | AWS Access key | AKIAIO... | None | Yes (if using instance role) |
AWS_SECRET_ACCESS_KEY | AWS Secret Key | wJalrXUtnFE... | None | Yes (if using instance role) |
AWS_DEFAULT_REGION | AWS Default Region | us-west-2 | us-west-1 | Yes |
DATABASE_PATH | Path of database to be backed up (within the container) | /myvolume/mydb.db | /data/sqlite3.db | Yes |
BACKUP_PATH | Path to write the backup (within the container) | /myvolume/mybackup.db | ${DATABASE_PATH}.bak | Yes |
Tag summary
Content type
Image
Digest
Size
21.8 MB
Last updated
almost 10 years ago
docker pull jacobtomlinson/sqlite-to-s3