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.
-
iAmNaN71315yYou 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!
-
REDCODE245y@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
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