Databases and backups

dp, 06 May 2010, View Comments
Categories: Servers
Tags: , , ,
MySQL Workbench

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?

Related posts:

  1. How to fix strange characters in MySQL database – Vinh Pham I admit, I borrowed this from How to fix strange...
  2. udev debugging toolbox « Web 0.2 This is a great read about working with udev, specifically,...

Comments

    blog comments powered by Disqus