53

I just almost shat myself.

I altered the wrong database table column...truncated data we are required to keep for government compliance.

Luckily I had exported that table earlier today and was able to recover it all. I'm in need of a very strong drink right about now.

Comments
  • 5
    You're working on prod databases without backups?
  • 11
    @alexbrooklyn We only have prod and uh...yeah about the backups...previously devs/admins were less than thorough about that kind of stuff.

    I'm in the process of cleaning stuff up so we can do a database upgrade and get real backups in place.
  • 16
    From @BobbyTables to Wobbly tables 😛
  • 10
    @alexbrooklyn My mom was always so worried about SQL injections she never taught me the benefits of a good backup system.
  • 9
    You are inviting all sorts of problems making changes in prod AND not having backups. It's not if, it's when.
  • 7
    Do it again! It's skydiving for nerds.
  • 2
    @ihatecomputers bungee jumping! Cliff diving!
  • 0
    Oh @BobbyTables! I hope you got all of your injections (UK term for shot) before doing any production work.
  • 2
    @ihatecomputers biggest adrenaline rush I've had in a long time
  • 2
    May the force be with you... that was your warning shot from the database gods!
  • 2
    @BobbyTables even if you are cleaning up the ground to make a decent backup system, always make a damn backup. Never work in production. It's the rule number 1 and a lot of peoples don't follow it.
  • 2
    Happened to me once too. Now I always use reader account especially with UI based SQL client. When I need write, I login, backup, update, then logout immediately. Really traumatizing experience.
Add Comment