Welcome to WebmasterWorld Guest from 54.147.10.72

Forum Moderators: open

Message Too Old, No Replies

hit execute too soon.

I HATE when that happens!

     

LifeinAsia

11:19 pm on Nov 5, 2012 (gmt 0)

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 5+ Year Member Top Contributors Of The Month



I always hate it when I click the execute button when doing an UPDATE (or DELETE) statement before typing the WHERE conditional.

Now restoring the backups... :)

GaryK

11:30 pm on Nov 5, 2012 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Don't feel too bad about it as I'm sure most of us have done that at least once. I know I have.

brotherhood of LAN

11:36 pm on Nov 5, 2012 (gmt 0)

WebmasterWorld Administrator brotherhood_of_lan is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month



Yeah, I read somewhere that a typist makes an error on average about 360 characters. Surely the same must be the case for DB operations...

I've mucked up bad a few times but nothing that was ever permanent, but took time to remedy.

LifeinAsia

12:02 am on Nov 6, 2012 (gmt 0)

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 5+ Year Member Top Contributors Of The Month



Yup- just a friendly reminder to everyone of the importance of timely backups. And especially backups that you can actually restore.

wheel

12:06 am on Nov 6, 2012 (gmt 0)

WebmasterWorld Senior Member wheel is a WebmasterWorld Top Contributor of All Time 10+ Year Member



rm -Rf *

Done as root at the top of my webserver.

shutdown -h now

Shutting down my desktop from a terminal. Except the PC didn't shutdown. Stared stupidly as I realized...crap. I just remotely shut down my webserver. Two fixes to that. First, I thankfully had a KVM IP switch on my webserver so I cycled the power and restarted it IIRC. Secondly, put everything except the PC (screen, printer, etc) on it's own power bar and now I just hit the power bar at the end of the night - turns off everything except the box.

Dijkgraaf

1:45 am on Nov 6, 2012 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Usually when I'm about to do an UPDATE or DELETE I first write it as a SELECT statement and verify that only the rows I'm about to delete or UPDATE are selected.

whoisgregg

1:52 pm on Nov 8, 2012 (gmt 0)

WebmasterWorld Senior Member whoisgregg is a WebmasterWorld Top Contributor of All Time 10+ Year Member



Usually when I'm about to do an UPDATE or DELETE I first write it as a SELECT statement and verify that only the rows I'm about to delete or UPDATE are selected.


Same here -- it's a good habit to get into.

LifeinAsia

5:20 pm on Nov 8, 2012 (gmt 0)

WebmasterWorld Administrator lifeinasia is a WebmasterWorld Top Contributor of All Time 5+ Year Member Top Contributors Of The Month



Yup- I usually do that too. The one time I don't do it...

topr8

11:19 pm on Nov 8, 2012 (gmt 0)

WebmasterWorld Senior Member topr8 is a WebmasterWorld Top Contributor of All Time 10+ Year Member



luckily i don't use the console i use MySQL workbench to do DB stuff and it won't allow a DELETE without a where clause, it gives an error. not for update though

Bewenched

7:34 am on Nov 9, 2012 (gmt 0)

WebmasterWorld Senior Member 5+ Year Member



Don't feel bad, just last week I was trying to clean up double spaces and in the replace forgot to put a single space to replace it with and it wiped all the spaces from our product names... Lol.. yea thank goodness for backups.
 

Featured Threads

Hot Threads This Week

Hot Threads This Month