Backup & Recovery

# HTTP API
curl -X POST http://localhost:7474/admin/snapshot

{
  "snapshot_id": "20240115-103000",
  "path": "/data/snapshots/20240115-103000",
  "size_bytes": 1073741824
}

curl http://localhost:7474/admin/snapshots

# Stop database
docker stop qilbeedb

# Restore snapshot
cp -r /data/snapshots/20240115-103000/* /data/

# Start database
docker start qilbeedb

# Stop database
docker stop qilbeedb

# Backup data
tar -czf qilbeedb-backup-$(date +%Y%m%d).tar.gz /data/qilbeedb/

# Start database
docker start qilbeedb

# Stop database
docker stop qilbeedb

# Restore data
tar -xzf qilbeedb-backup-20240115.tar.gz -C /

# Start database
docker start qilbeedb

# Create snapshot (database stays online)
curl -X POST http://localhost:7474/admin/snapshot

# Backup snapshot directory
cp -r /data/snapshots/latest /backup/

# Add to crontab
0 2 * * * /usr/local/bin/qilbee-backup.sh

# qilbee-backup.sh
#!/bin/bash
BACKUP_DIR="/backup/qilbeedb"
DATE=$(date +%Y%m%d)

# Create snapshot
curl -X POST http://localhost:7474/admin/snapshot

# Backup to S3
aws s3 sync /data/snapshots/latest s3://my-backups/qilbeedb/$DATE/

# Restore to test instance
docker run -d --name qilbeedb-test \
  -v /backup/latest:/data \
  qilbeedb/qilbeedb:latest

# Verify data
curl http://localhost:7475/health
curl http://localhost:7475/admin/stats