Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery

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.

Enoch was right!
Enjoy the last years of Rome.

Replies are listed 'Best First'.
Re^3: PM Confessional
by Tux (Abbot) 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?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://883176]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others rifling through the Monastery: (3)
As of 2018-02-20 00:23 GMT
Find Nodes?
    Voting Booth?
    When it is dark outside I am happiest to see ...

    Results (266 votes). Check out past polls.