Backups are important. Through human error or hardware failure, you're going to need a backup at some point.
I have over 10 years of coding & server experience. Just in the past year, I've made & fixed a ton of mistakes:
Backups saved me each time.
I've asked hundreds of people how they do backups. Here's what a huge majority do for backups:
Set-it and forget-it CRON tasks.
But this strategy misses so many considerations! We also really need to:
And for MySQL specifically?
The majority of us are using mysqldump in ways that slow down or stop our databases.
Additionally, having only periodic backups guarantees that we'll lose data.
Luckily there are quite a few ways to backup and recover your MySQL database:
I'm making Backops to help us backup our databases. Here's the game plan on what Backops will do:
We're going to start with a limited Beta for Laravel Forge users in early 2019.
If this sounds interesting to you, sign up here for updates and to get your place in line for access!