MySQL Backup Manager is a simple Python-based tool that automates the backup of MySQL databases and stores them securely in an AWS S3 bucket. It allows users to schedule backups and store them in a specified directory or S3 bucket for easy access and management.
- ✅ Automatic MySQL database backup using
mysqldump - ✅ Configurable backup directory and database credentials
- ✅ Timestamped backup files for easy tracking
- ✅ Supports Windows Task Scheduler for automation
Before using this project, ensure you have the following installed:
- Python 3.x
- MySQL Server
mysqldumputility (included with MySQL)- PowerShell (for automation)
git clone https://github.com/rohitramteke1/mysql-backup-manager.git cd mysql-backup-managerpython -m venv venv venv\Scripts\activate # Windowspip install -r requirements.txtCreate a .env file in the project root and add:
DB_HOST=localhost DB_USER=root DB_PASSWORD=yourpassword DB_NAME=yourdatabase BACKUP_DIR=backupsmysql-backup-manager/ │── backups/ # Directory to store backup files │── .github/ # GitHub Actions/CI pipeline configuration │── venv/ # Virtual environment (ignored in Git) │── .env # Environment variables (ignored in Git) │── .gitignore # Ignored files (venv, backups, etc.) │── auto_backup.ps1 # PowerShell script for scheduled backups │── backup.py # Main script to perform MySQL backup │── restore.py # Script to restore backups │── tests/ # Folder for test files │ └── test_backup.py # Test file for the backup functionality │── requirements.txt # Python dependencies │── README.md # Documentation └── LICENSE # License file Run the following command to create a backup manually:
python backup.pyThe backup will be stored in the backups/ directory with a timestamped filename.
To schedule a daily backup at 2:00 AM:
e.g. schtasks /create /tn "MySQL Auto Backup" /tr "powershell -ExecutionPolicy Bypass -File <your-project-path>\auto_backup.ps1" /sc daily /st 02:00 schtasks /create /tn "MySQL Auto Backup" /tr "powershell -ExecutionPolicy Bypass -File D:\Projects\Personal\mysql-backup-manager\auto_backup.ps1" /sc daily /st 02:00📌 This step is optional for the project but demonstrates automation.
To restore a backup, use:
mysql -h localhost -u root -p yourdatabase < backups\db_backup_YYYY-MM-DD_HH-MM-SS.sqlContributions are welcome! Feel free to submit issues or pull requests to improve this project.
- Rohit Ramteke – Creator & Maintainer
- Syed Siddiqui – Educational case study and feedback | AI
This project is licensed under the MIT License - see the LICENSE file for details.