Ranter
Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
Comments
-
@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. -
@alexbrooklyn My mom was always so worried about SQL injections she never taught me the benefits of a good backup system.
-
iAmNaN67506yYou are inviting all sorts of problems making changes in prod AND not having backups. It's not if, it's when. -
Oh @BobbyTables! I hope you got all of your injections (UK term for shot) before doing any production work.
-
May the force be with you... that was your warning shot from the database gods!
-
REDCODE246y@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. -
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.
Related Rants

Customer bought this in. They "turned on the wrong burner"
Java Joke......
I'll just tell the client it's where developers go to complain about difficult bugs in their code...
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.
rant
oops