- #!/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
|
