Welcome to WebmasterWorld Guest from 54.82.57.154

Forum Moderators: open

Message Too Old, No Replies

hit execute too soon.

I HATE when that happens!

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

Moderator from US 

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

joined:Dec 10, 2005
posts:5722
votes: 99


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... :)
11:30 pm on Nov 5, 2012 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:Sept 17, 2002
posts:2251
votes: 0


Don't feel too bad about it as I'm sure most of us have done that at least once. I know I have.
11:36 pm on Nov 5, 2012 (gmt 0)

Senior Member from GB 

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

joined:Jan 30, 2002
posts:4889
votes: 17


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.
12:02 am on Nov 6, 2012 (gmt 0)

Moderator from US 

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

joined:Dec 10, 2005
posts:5722
votes: 99


Yup- just a friendly reminder to everyone of the importance of timely backups. And especially backups that you can actually restore.
12:06 am on Nov 6, 2012 (gmt 0)

Senior Member

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

joined:Feb 11, 2003
posts:5072
votes: 12


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.
1:45 am on Nov 6, 2012 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:May 31, 2005
posts:1108
votes: 0


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.
1:52 pm on Nov 8, 2012 (gmt 0)

Senior Member from US 

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

joined:Dec 9, 2003
posts:3416
votes: 0


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.
5:20 pm on Nov 8, 2012 (gmt 0)

Moderator from US 

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

joined:Dec 10, 2005
posts:5722
votes: 99


Yup- I usually do that too. The one time I don't do it...
11:19 pm on Nov 8, 2012 (gmt 0)

Senior Member

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

joined:Apr 19, 2002
posts:3350
votes: 37


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
7:34 am on Nov 9, 2012 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:July 26, 2006
posts:1623
votes: 0


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.
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members