Thank god for nightly database backups.
I was working on Kirsten's English 111 page last night, and I needed to do some manual database manipulation (I hadn't yet written the front end for what I needed to do).
As I was hitting enter on a query to change a value in a record, I realized I had forgotten to add 'where classid=72'. And overwrote the notes for every entry in last year's syllabus.
Oops.
Thankfully, I backup the database to a file every morning, so I just cleared the table and imported the backup database.
Then I wrote the front-end, so I wouldn't mess up the database again. :)
Posted by Darren James Harkness on Wednesday, September 8, 2004 10:55 AM
Trackbacks...
Funnily enough I did that recently with a clients site. I built a CMS a while back and was playing around when I got an email that something was messed up with one of the pages. I looked at it and decided that maybe if I manually import it (update content set text = '[paste of page]' where id = xxx) it'd go in ok. Well, the pasted content contained odd characters which messed up the screen and somehow removed the 'where id = xxx', so now every page on the site looked like that one page :(
Again, lucky backups. Unlucky was the designer had spent all day (ie: backups at 2am, he worked from 7am till this happened at 3 or 4pm) tweaking and fixing. *Luckily* he still had all the files open on his computer, so he just had to copy them back in, and not re-create all the work again.
-- Posted by >> Arcterex » Wednesday, September 8, 2004 11:46 AMPost a comment
* under no circumstances will your email address be traded for a sack of quarters. No-sirree.