Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re^2: PM Confessional

by Jenda (Abbot)
on Jan 19, 2011 at 17:48 UTC ( #883176=note: print w/ replies, xml ) Need Help??


in reply to Re: PM Confessional
in thread PM Confessional

That's why I (prettymuch always) stick the handwritten updates and deletes between BEGIN TRANSACTION and ROLLBACK and if and only if I get a sane "N rows affected" message do I select and run just the statement.

Saved my butt a few times.

Jenda
Enoch was right!
Enjoy the last years of Rome.


Comment on Re^2: PM Confessional
Select or Download Code
Re^3: PM Confessional
by Tux (Monsignor) on Jan 20, 2011 at 07:18 UTC

    Sane way of operating. It will also protect you fro the less obvious mistake of writing

    delete from table where key > 0;

    instead of

    delete from table where key < 0;

    which is only one key apart. I know someone else who did that.

    This thread is not about errors someone else made, but I will still tell one from the recent past:

    After months of preparing and exercising all the needed commands for the move of one production platform to a newer platform of a more modern architecture, someone (not in our company) issued the main "rsync" command (which also had a --delete) THE WRONG WAY AROUND and deleting two days of work. The restore from backup took 6 hours and regained 1 day of work.


    Enjoy, Have FUN! H.Merijn

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://883176]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (4)
As of 2015-07-05 16:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (67 votes), past polls