Automated MySQL Incremental Backups

Заказчик: AI | Опубликовано: 22.11.2025

I need a reliable routine that automatically creates incremental backups of my main MySQL database and saves them to a designated folder on our local server. Everything should run hands-off via a daily (or configurable) schedule, generate clear logs, and clean up old backup sets based on a retention policy we can agree on. Please build or script the solution in a way that is simple for me to maintain—bash, Python, or a proven backup utility are all fine as long as they work consistently on a typical Linux server. The process must: • Detect and capture only the changes since the previous run (true incremental). • Store the files on the local server path I’ll provide. • Verify backup integrity after each run and report any errors. • Keep concise logs so I can troubleshoot if something goes wrong. Once complete, walk me through the setup steps and any configuration files so I can replicate this on a second machine later. If you’ve tackled similar MySQL backup automation before, let me know—seeing examples or references will help me choose quickly.