v1.3.1

Newly Features
🗄️ Support for Microsoft SQL Server

🔐 Support for SQL and Windows authentication methods

♻️ Support for different backup types (📦 Full, 🔁 Differential, 📜 Log)

🧩 Option to specify a named or default instance

💾 Backup to .bak files with compression support

🔒 Integration with encryption and ✅ verification features

v1.3.0

🚀 New Features List
🛢️ Database Support
✅ MySQL/MariaDB Backup

📌 Full backup using mysqldump
📜 Backup of stored procedures, triggers, and events
🎯 Options to backup all databases or a specific list
🔗 Integration with compression & encryption
⚙️ Configurable database connection settings (host, port, credentials)

✅ PostgreSQL Support

📌 Backup with pg_dump
💾 Custom format backups for efficient storage
🎯 Support for all databases or a specific list
🔍 Backup verification & reporting
⚙️ Configurable PostgreSQL connection settings

🔥 Advanced Backup Features
🚫 File Exclusion Patterns

🏷️ Support for regex & glob patterns to exclude files
📂 Comma-separated patterns for easy setup
🔄 Works with tar (compressed) & rsync (uncompressed) backups
🚀 Improves space efficiency by avoiding unnecessary files

💾 Deduplication

⚡ Storage optimization by removing duplicate files
🔑 SHA-256 hashing to identify identical files
🔗 Hard link usage for space-saving while maintaining structure
📊 Tracking database to manage deduplication across backup sets

🔐 Security Enhancements
🔒 Encryption Support

🛡️ AES-256-CBC encryption for securing backup files
🔑 PBKDF2 key derivation for stronger protection
🧂 Salt generation & storage for each encrypted file
🔄 Seamless integration with backup & restore processes
🔏 Password protection for sensitive backups

🛠️ Backup Verification

🧩 SHA-256 checksum for each file
🔍 Automatic integrity verification post-backup
🔄 Integrity checks during restore
📊 Detailed reports for verification failures
🚨 Prevention against corrupted backups

💾 Disk Space Monitoring
📊 Pre-Backup Space Check

🔍 Automatic disk space verification
📏 Configurable minimum space threshold
🚨 Prevention of backup failures due to low space
📊 Detailed disk usage statistics

📢 Disk Usage Reporting

📩 Disk space information included in notifications
📊 Reporting of total, used, and available space
📉 Percentage-based usage indication
⏰ Early warnings for low disk space

📣 Enhanced Notification System
📧 Improved Email Notifications

📌 Status-based email subjects (SUCCESS ✅ / FAILED ❌)
💾 Disk space usage report included
🔍 Detailed error reporting for failures
📊 Comprehensive backup stats in emails

📲 Enhanced Telegram Notifications

✅ Visual indicators for backup success/failure
📊 Disk space metrics in messages
📑 Structured format for readability
🚨 Error details for troubleshooting

Version 1.2

🚀 BackupSync v1.2 – New Features & Enhancements

🔄 Incremental Backup Support
✅ New Feature: Backup only changed files instead of full backups
⚡ Efficiency: Significant savings in disk space and backup time
🤖 Automatic Management: Seamless transition between full and incremental backups

🔄 Restore Functionality
💻 Command Line Tool: Added ./backup_sync.sh restore command
🧠 Smart Restoration: Automatically applies all necessary backups when restoring from incremental backups
🎯 Flexible Targeting: Restore to the original location or a different target

⚙️ Enhanced Configuration
🆕 New Parameters:
🔘 ENABLE_INCREMENTAL: Toggle incremental backup feature on/off
📆 INCREMENTAL_MAX_FULL: Number of days between full backups

📢 Improved Notification System
📨 Detailed Information: Backup type (full/incremental) specified in email and Telegram notifications
📊 Statistics: Added information about the number of changed files in incremental backups

🧹 Smart Cleanup System
🔗 Dependency Management: Old backups are cleaned while preserving relationships between full and incremental backups
🚨 Orphaned Backup Detection: Automatically detects and removes incremental backups whose parent full backup has been deleted

🛠️ Technical Changes
🔖 Backup Markers:
📌 .full_backup – Marks full backups
📌 .incremental_backup – References the full backup that an incremental backup is associated with

🗂️ Incremental Backup Methods:
📦 Compressed Mode: Lists and backs up only changed files using tar
🔗 Uncompressed Mode: Creates efficient hard links using rsync's --link-dest feature

☁️ Cloud Storage Improvements: Proper uploading of incremental backup references to cloud services

📜 Enhanced Logging: Backup type and change statistics added to log files

🚀 This update optimizes disk space usage and significantly speeds up the backup process. The improved restore functionality makes it easier than ever to recover data from backups!