# Database Backup Cron Jobs
# Add these to your crontab with: crontab -e

# Daily backup at 2 AM
0 2 * * * /media/pts/Website/Church_HOP_MusicData/backup-database.sh >> /media/pts/Website/Church_HOP_MusicData/backups/cron.log 2>&1

# Weekly full backup on Sundays at 3 AM (keep for 30 days)
0 3 * * 0 /media/pts/Website/Church_HOP_MusicData/backup-database.sh && cp /media/pts/Website/Church_HOP_MusicData/backups/church_songlyric_latest.sql.gz /media/pts/Website/Church_HOP_MusicData/backups/weekly_$(date +\%Y\%m\%d).sql.gz

# Clean up weekly backups older than 30 days
0 4 * * 0 find /media/pts/Website/Church_HOP_MusicData/backups -name "weekly_*.sql.gz" -mtime +30 -delete
