News for hackers. Stuff that matters.
Re:Some SQL Tricks of an Application DBA by gav on Wednesday July 29, 2020 @02:23PM (#23989964)
I do the same thing.

However, it won't save you if realize that there's an issue after you commit. Maybe I'm just paranoid but I like to have both a snapshot before a major change, plus I'm fond of having a spare (via delayed replication or log shipping).

Re:Some SQL Tricks of an Application DBA by gmfawcett on Wednesday July 29, 2020 @02:28PM (#23990024)
Ah, I forgot to include the twelve stages of proactive, redundant backups. :) I usually do the same thing -- local snapshots if the database is small and the app is less critical... or a careful review of the central db backup history and a documented rollback plan if it's a bigger system.