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"
BACKUP_DB_FILENAME="${BACKUP_DB_PREFIX}$_(date +%Y%m%d_%H%M%S)${BACKUP_DB_SUFFIX}"
DATA_PATH="/opt/my-app/data"
BACKUP_DATA_PREFIX="my-app_data"
BACKUP_DATA_SUFFIX=".tar.gz"
BACKUP_DATA_FILENAME="${BACKUP_DATA_PREFIX}_$(date +%Y%m%d_%H%M%S)${BACKUP_DATA_SUFFIX}"
BACKUP_PATH="/opt/my-app/backup/"
DAYS_TO_KEEP_LOCAL=7
DAYS_TO_KEEP_REMOTE=30

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	BACKUP_DB_FILENAME="${BACKUP_DB_PREFIX}$_(date +%Y%m%d_%H%M%S)${BACKUP_DB_SUFFIX}"
8	DATA_PATH="/opt/my-app/data"
9	BACKUP_DATA_PREFIX="my-app_data"
10	BACKUP_DATA_SUFFIX=".tar.gz"
11	BACKUP_DATA_FILENAME="${BACKUP_DATA_PREFIX}_$(date +%Y%m%d_%H%M%S)${BACKUP_DATA_SUFFIX}"
12	BACKUP_PATH="/opt/my-app/backup/"
13	DAYS_TO_KEEP_LOCAL=7
14	DAYS_TO_KEEP_REMOTE=30
15
16	mkdir -p "$BACKUP_PATH"
17
18	sqlite3 "$DB_PATH" ".backup \"$BACKUP_PATH/$BACKUP_DB_FILENAME\""
19
20	tar -C $(dirname "$DATA_PATH") -cf "$BACKUP_PATH/$BACKUP_DATA_FILENAME" --exclude='db.sqlite*' data
21
22	rclone copyto "$BACKUP_PATH/$BACKUP_DB_FILENAME" "$RCLONE_REMOTE/$BACKUP_DB_FILENAME"
23	rclone copyto "$BACKUP_PATH/$BACKUP_DATA_FILENAME" "$RCLONE_REMOTE/$BACKUP_DATA_FILENAME"
24
25	rclone delete "$RCLONE_REMOTE" --min-age ${DAYS_TO_KEEP_REMOTE}d
26	find "$BACKUP_PATH" -name "${BACKUP_DB_PREFIX}*${BACKUP_DB_SUFFIX}" -type f -mtime +$DAYS_TO_KEEP_LOCAL -delete
27	find "$BACKUP_PATH" -name "${BACKUP_DATA_PREFIX}*${BACKUP_DATA_SUFFIX}" -type f -mtime +$DAYS_TO_KEEP_LOCAL -delete
28
29	echo "Backup completed on $(date)"
30