20 lines
879 B
Bash
Executable File
20 lines
879 B
Bash
Executable File
#!/bin/bash
|
|
# Remote backup: download database from server to local Mac
|
|
# Run via cron: crontab -e → 0 * * * * /path/to/remote-backup.sh
|
|
|
|
BACKUP_DIR="$HOME/Hera DOCS/Projects/Essential Oil Formula Cost Calculator/backups/remote"
|
|
mkdir -p "$BACKUP_DIR"
|
|
DATE=$(date +%Y%m%d_%H%M%S)
|
|
|
|
# Download database
|
|
ssh fam@oci.euphon.net "kubectl exec -n oil-calculator deploy/oil-calculator -- cat /data/oil_calculator.db" > "$BACKUP_DIR/oil_calculator_${DATE}.db" 2>/dev/null
|
|
|
|
if [ $? -eq 0 ] && [ -s "$BACKUP_DIR/oil_calculator_${DATE}.db" ]; then
|
|
echo "✅ Backup: $BACKUP_DIR/oil_calculator_${DATE}.db ($(du -h "$BACKUP_DIR/oil_calculator_${DATE}.db" | cut -f1))"
|
|
# Keep last 168 backups (7 days hourly)
|
|
ls -t "$BACKUP_DIR"/oil_calculator_*.db 2>/dev/null | tail -n +169 | xargs rm -f 2>/dev/null
|
|
else
|
|
echo "❌ Backup failed"
|
|
rm -f "$BACKUP_DIR/oil_calculator_${DATE}.db"
|
|
fi
|