Generic backup script

backup.sh · 1.2 KiB · Bash Raw

#!/usr/bin/env -S bash -eu

DB_PATH="/opt/my-app/data/db.sqlite"
RCLONE_REMOTE="s3:my-bucket/my-app"
BACKUP_DB_PREFIX="my-app_db"
BACKUP_DB_SUFFIX=".sqlite"
DATA_PATH="/opt/my-app/data"
BACKUP_DATA_PREFIX="my-app_data"
BACKUP_DATA_SUFFIX=".tar.gz"
BACKUP_PATH="/opt/my-app/backup/"
DAYS_TO_KEEP_LOCAL=7
DAYS_TO_KEEP_REMOTE=30

BACKUP_DB_FILENAME="${BACKUP_DB_PREFIX}$_(date +%Y%m%d_%H%M%S)${BACKUP_DB_SUFFIX}"
BACKUP_DATA_FILENAME="${BACKUP_DATA_PREFIX}_$(date +%Y%m%d_%H%M%S)${BACKUP_DATA_SUFFIX}"

mkdir -p "$BACKUP_PATH"

sqlite3 "$DB_PATH" ".backup \"$BACKUP_PATH/$BACKUP_DB_FILENAME\""

tar -C $(dirname "$DATA_PATH") -cf "$BACKUP_PATH/$BACKUP_DATA_FILENAME" --exclude='db.sqlite*' data

rclone copyto "$BACKUP_PATH/$BACKUP_DB_FILENAME" "$RCLONE_REMOTE/$BACKUP_DB_FILENAME"
rclone copyto "$BACKUP_PATH/$BACKUP_DATA_FILENAME" "$RCLONE_REMOTE/$BACKUP_DATA_FILENAME"

rclone delete "$RCLONE_REMOTE" --min-age ${DAYS_TO_KEEP_REMOTE}d
find "$BACKUP_PATH" -name "${BACKUP_DB_PREFIX}*${BACKUP_DB_SUFFIX}" -type f -mtime +$DAYS_TO_KEEP_LOCAL -delete
find "$BACKUP_PATH" -name "${BACKUP_DATA_PREFIX}*${BACKUP_DATA_SUFFIX}" -type f -mtime +$DAYS_TO_KEEP_LOCAL -delete

echo "Backup completed on $(date)"

1	#!/usr/bin/env -S bash -eu
2
3	DB_PATH="/opt/my-app/data/db.sqlite"
4	RCLONE_REMOTE="s3:my-bucket/my-app"
5	BACKUP_DB_PREFIX="my-app_db"
6	BACKUP_DB_SUFFIX=".sqlite"
7	DATA_PATH="/opt/my-app/data"
8	BACKUP_DATA_PREFIX="my-app_data"
9	BACKUP_DATA_SUFFIX=".tar.gz"
10	BACKUP_PATH="/opt/my-app/backup/"
11	DAYS_TO_KEEP_LOCAL=7
12	DAYS_TO_KEEP_REMOTE=30
13
14	BACKUP_DB_FILENAME="${BACKUP_DB_PREFIX}$_(date +%Y%m%d_%H%M%S)${BACKUP_DB_SUFFIX}"
15	BACKUP_DATA_FILENAME="${BACKUP_DATA_PREFIX}_$(date +%Y%m%d_%H%M%S)${BACKUP_DATA_SUFFIX}"
16
17	mkdir -p "$BACKUP_PATH"
18
19	sqlite3 "$DB_PATH" ".backup \"$BACKUP_PATH/$BACKUP_DB_FILENAME\""
20
21	tar -C $(dirname "$DATA_PATH") -cf "$BACKUP_PATH/$BACKUP_DATA_FILENAME" --exclude='db.sqlite*' data
22
23	rclone copyto "$BACKUP_PATH/$BACKUP_DB_FILENAME" "$RCLONE_REMOTE/$BACKUP_DB_FILENAME"
24	rclone copyto "$BACKUP_PATH/$BACKUP_DATA_FILENAME" "$RCLONE_REMOTE/$BACKUP_DATA_FILENAME"
25
26	rclone delete "$RCLONE_REMOTE" --min-age ${DAYS_TO_KEEP_REMOTE}d
27	find "$BACKUP_PATH" -name "${BACKUP_DB_PREFIX}*${BACKUP_DB_SUFFIX}" -type f -mtime +$DAYS_TO_KEEP_LOCAL -delete
28	find "$BACKUP_PATH" -name "${BACKUP_DATA_PREFIX}*${BACKUP_DATA_SUFFIX}" -type f -mtime +$DAYS_TO_KEEP_LOCAL -delete
29
30	echo "Backup completed on $(date)"
31