Databases and backups
Image by jeromejtk via Flickr
Yesterday, I managed to delete the primary database that we use at work. I won’t go in to how this happened, other than to say: Fuck you MySQL Workbench. I was trying to get a map of the table relations within the database. Needless to say, it didn’t work. After the immediate pants-wiping, I restored the database from the backup. But the backup was from the previous morning, as the current backup hadn’t finished. Unfortunately, I couldn’t find the files from the mornings backup.
In short, losing data sucks. How often do database “pros” backup their data?
Other related posts:
- Perl module of the day Next up in the Perl Module of the Day series...