sqlBackup is a modern, feature-rich Python tool designed to simplify and automate the backup of MySQL and MariaDB databases. Built for sysadmins, developers, and DevOps teams, it offers reliability, flexibility, and maintainability out of the box.
🚀 Highlights
- Comprehensive MySQL/MariaDB Backup:
Usesmysqldumpfor consistent backups, with support for stored routines and events. - Flexible Archiving:
Supports multiple archive formats: plain SQL, gzip (.gz), xz (.xz), tar.xz, zip, and rar. - Multi-Channel Notifications:
Get notified via Telegram, Email, Slack, SMS (Twilio), Viber, and more. - Remote Uploads:
Automatically upload backups to remote servers using SFTP, FTP, or SCP. Schedule uploads for daily, weekly, or custom intervals. - Wildcard Database Exclusion:
Easily exclude databases from backup using wildcard patterns (e.g.,test_*). - Modular and Maintainable:
Clean, modular codebase for easy customization and extension. - Graceful Interruption Handling:
Handles user interruptions (Ctrl+C) gracefully. - Comprehensive Logging:
Color-coded console output and rotating log files. - Robust Configuration Validation:
Validates all configuration parameters, file paths, credentials, and more before running backups. - Standalone Validation Tool:
Quickly check your configuration file for errors before running a backup.
🛠️ Getting Started
- See the README for installation and configuration instructions.
- Install via pip:
pip install sqlBackup