MySQL Backup strategies

Mini Rant: I never gave much thought to backing up my database, and I suspect you haven’t given much thought to it, either. You think it won’t happen to you, but believe me, when something does happen it can do more than ruin your day. If you don’t have a backup, you can lose days, months, or even years of hard work. You can’t trust your host, no matter how good they are. And you can’t ignore the possibility of “pilot error.” Just yesterday, I was making some corrections and in my haste clicked the wrong button, erasing two days of work since my last manual backup and losing several new entries. Now that I’ve figured out how to automate my backups, all I can say is: Have a backup plan!