Thread: mysql> undo;
View Single Post
Old 05-25-2004, 05:16 PM  
fuzebox
making it rain
 
fuzebox's Avatar
 
Industry Role:
Join Date: Oct 2003
Location: seattle
Posts: 22,238
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