How to schedule a cron job to backup a MySql database every week?
- by KevinM
What is a command line I can use to back up a MySql database every single week into a file name with the date (so that it doesn't collide with previous backups)?
Also, is this a reasonable backup strategy? My database is relatively small (a complete export is only 3.2 megs right now). The churn rate is relatively low. I need to be able to get the complete DB back if something goes wrong. And it would be extra cool if there's a way that I could see the changes that occur across a time span.