Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
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 romping around the Monastery: (3)
As of 2014-09-18 04:31 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (108 votes), past polls