#!/bin/bash
BACKUP_DIR="/backups/docker/n8n"
DB_FILE="/data/docker/n8n/database.sqlite"
TS=$(date +%Y%m%d)
/usr/bin/sqlite3 "$DB_FILE" ".backup ${BACKUP_DIR}/n8n-database-${TS}.sqlite"
/usr/bin/gzip -f "${BACKUP_DIR}/n8n-database-${TS}.sqlite"
/usr/bin/find "$BACKUP_DIR" -name "n8n-database-*.sqlite.gz" -mtime +90 -delete