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 ( [id://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.

Replies are listed 'Best First'.
Re^3: PM Confessional
by Tux (Canon) 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
Domain Nodelet?
Node Status?
node history
Node Type: note [id://883176]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others imbibing at the Monastery: (6)
As of 2024-03-28 10:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found