Since redoing the MySQL box a while ago I found the chore of backing up the MySQL starting to become tedious and needed a brain dead process. So after some searching and filtering through countless examples I settled on a pretty nice script here: HOW TO AUTOMATICALLY BACKUP ALL MYSQL DATABASES ZIP THEM AND DELETE BACKUPS OLDER THAN N DAYS ON WINDOWS WITH A BATCH FILE. Not sure you could have a longer title in all caps but again, it does the job and with the site theme applied you don’t notice that the article is screaming at you.
2 things to watch for:
- You do not need to download the command version of 7zip, the standard version supports both GUI and command line.
- On the 7zip command use -t7z and not -tzip, you will get much better compression ratio’s at the expensive or the very compatible ‘Zip” format. How much? 32meg versus 5meg. If you are running 30 days on the local box it adds up quick.
I added a comment with these 2 tips for what it was worth.