Hello guys I wrote an article lately about automatic SQL database backup
For Linux Systems (Sorry Wind0z guys and gals...)
This is the one I'm using for my projects
https://habilisbest.com/sql-database-automatic-backups
Features:
Backups database names specified in a list
compresses and stores them
Uses filename format for easy retrieval [DatabaseName].YYYY-mm-dd.gz
Removes backups older than 28 days (to keep it nice and clean)
Writes log files
You can configure it to run every 12 hours with cron (crazy server owners...)
I run it every 3 days. Because, I don't give a damn about my players I'm confident in my Raspberry Pi server!
Would like your feedback and if you can think of any other features I can develop, please speak up!