Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us.

Post New Thread Reply

Register GFY Rules Calendar
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >
Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed.

 
Thread Tools
Old 05-25-2004, 05:09 PM   #1
fuzebox
making it rain
 
fuzebox's Avatar
 
Industry Role:
Join Date: Oct 2003
Location: seattle
Posts: 22,114
mysql> undo;

Post here if you've ever found yourself wishing for this feature
fuzebox is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 05-25-2004, 05:11 PM   #2
tical
Confirmed User
 
Join Date: Feb 2002
Location: Las Vegas
Posts: 6,504
hehe

before you do anything crazy always mysqldump

i learned that the hard way
tical is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 05-25-2004, 05:16 PM   #3
fuzebox
making it rain
 
fuzebox's Avatar
 
Industry Role:
Join Date: Oct 2003
Location: seattle
Posts: 22,114
Quote:
Originally posted by tical
hehe

before you do anything crazy always mysqldump

i learned that the hard way
Hehe yes... On my big production database I usually run a nightly mysqldump as well, has saved my ass before.

My big problem is with quick little queries, it's happened before, I always stick a semicolon before "WHERE".

Ie...

mysql> delete from user ; where id=22;
Query OK, 122475 rows affected...

fuzebox is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 05-25-2004, 05:21 PM   #4
JSA Matt
So Fucking Banned
 
Join Date: Aug 2003
Location: San Diego, CA
Posts: 5,464
Quote:
Originally posted by fuzebox
mysql> delete from user ; where id=22;
Query OK, 122475 rows affected...
LOL Check your queries before pressing enter!
JSA Matt is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 05-25-2004, 05:22 PM   #5
NickPapageorgio
Confirmed User
 
Join Date: Apr 2004
Location: NC
Posts: 8,323
Quote:
Originally posted by fuzebox
Hehe yes... On my big production database I usually run a nightly mysqldump as well, has saved my ass before.

My big problem is with quick little queries, it's happened before, I always stick a semicolon before "WHERE".

Ie...

mysql> delete from user ; where id=22;
Query OK, 122475 rows affected...

Ouch...
__________________
NickPapageorgio is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 05-25-2004, 05:24 PM   #6
woj
<&(©¿©)&>
 
woj's Avatar
 
Industry Role:
Join Date: Jul 2002
Location: Chicago
Posts: 47,882
Quote:
Originally posted by fuzebox

mysql> delete from user ; where id=22;
Query OK, 122475 rows affected...

ouch... good thing you had a backup though.. :-/
__________________
Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000
Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager
Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager
woj is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 05-25-2004, 05:24 PM   #7
s9ann0
Confirmed User
 
Join Date: Sep 2001
Location: Boston
Posts: 4,873
i needed that one time when I put & instead of && in a delete and nuked a whole db
s9ann0 is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 05-25-2004, 05:27 PM   #8
bawdy
Confirmed User
 
Join Date: Feb 2002
Posts: 1,424
yeah transactions/rollback and stored procedures would be welcomed additions to mysql... still if u typo and execute the sql you're shit out of luck
bawdy is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 05-25-2004, 05:36 PM   #9
fuzebox
making it rain
 
fuzebox's Avatar
 
Industry Role:
Join Date: Oct 2003
Location: seattle
Posts: 22,114
I think my right pinky finger is faster than any other...

My brain thinks "that's not right" but my hand has already executed it.
fuzebox is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 05-25-2004, 05:39 PM   #10
JDog
Confirmed User
 
Join Date: Feb 2003
Location: Canby, OR
Posts: 7,453
Quote:
Originally posted by fuzebox
mysql> delete from user ; where id=22;
Query OK, 122475 rows affected...

That's great, this is gonna be a mysql horror story thread. I've done the same thing before! It sucks to nuke the whole database.

jDoG
__________________
NSCash now powering ReelProfits.com
ALSO FEATURING: NSCash.com :: SoloDollars.com :: ReelProfits.com :: BiminiBucks.com :: VOD
PROGRAMS COMING SOON: Greedy Bucks :: Vengeance Cash
NOW OFFERING OVER 60 SITES
CONTACT :: JAMES SMITH :: CHIEF TECHNOLOGY OFFICER :: ICQ (711385133)
JDog is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-02-2004, 11:30 PM   #11
jwerd
Confirmed User
 
Industry Role:
Join Date: Jun 2003
Location: Costa Rica
Posts: 1,953
Quote:
Originally posted by NickPapageorgio
Ouch...
Definately took the words out of my mouth :P
__________________
Yii Framework Guru - Seasoned PHP vet - Partner @ XXXCoupon.com
jwerd is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-02-2004, 11:36 PM   #12
Illicit
wtf ?
 
Join Date: Dec 2003
Location: GFY
Posts: 11,895
definately
__________________
Insert Sig Here
Illicit is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-02-2004, 11:39 PM   #13
Lane
Will code for food...
 
Join Date: Apr 2001
Location: Buckeye, AZ
Posts: 8,496
Quote:
Originally posted by bawdy
yeah transactions/rollback and stored procedures would be welcomed additions to mysql... still if u typo and execute the sql you're shit out of luck
transactions/rollback is supported for innoDB type tables if i'm not mistaken
__________________
Lane is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Post New Thread Reply
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >

Bookmarks



Advertising inquiries - marketing at gfy dot com

Contact Admin - Advertise - GFY Rules - Top

©2000-, AI Media Network Inc



Powered by vBulletin
Copyright © 2000- Jelsoft Enterprises Limited.