943,929 Members | Top Members by Rank

Ad:
You are currently viewing page 1 of this multi-page discussion thread
Aug 17th, 2006
0

Data Lost!!

Expand Post »
I would like to apologize to everyone. I have been working in the background on a test database getting ready to upgrade to vBulletin 3.6. However, in doing so, I accidentally overwrote the live database instead of the test database. Unfortunately, we lost 5 hours of database updates.

I'm VERY sorry everyone!!
Similar Threads
Administrator
Staff Writer
Reputation Points: 1422
Solved Threads: 162
The Queen of DaniWeb
cscgal is offline Offline
13,645 posts
since Feb 2002
Aug 17th, 2006
0

Re: Data Lost!!

ACK!! It looks as if we didn't lose just 5 hours of data after all. We lost 12 hours. I'm sooooo sorry folks.
Administrator
Staff Writer
Reputation Points: 1422
Solved Threads: 162
The Queen of DaniWeb
cscgal is offline Offline
13,645 posts
since Feb 2002
Aug 17th, 2006
0

Re: Data Lost!!

*Spank!**Spank!*
DMR
Team Colleague
Reputation Points: 221
Solved Threads: 369
Wombat At Large
DMR is offline Offline
6,439 posts
since Dec 2003
Aug 17th, 2006
0

Re: Data Lost!!

It happens. I am just happy to find out that it was something like this that my posts today were missing I thought it was deleted on purpose
Team Colleague
Reputation Points: 36
Solved Threads: 2
PFO Founder
big_k105 is offline Offline
308 posts
since May 2003
Aug 18th, 2006
0

Re: Data Lost!!

Tee he he.
Featured Poster
Reputation Points: 1536
Solved Threads: 431
Posting Expert
iamthwee is offline Offline
5,865 posts
since Aug 2005
Aug 18th, 2006
0

Re: Data Lost!!

Quote ...
It happens. I am just happy to find out that it was something like this that my posts today were missing I thought it was deleted on purpose
Yeah me too it's almost actually a relief. he he
Reputation Points: 262
Solved Threads: 68
Veteran Poster
hollystyles is offline Offline
1,181 posts
since Feb 2005
Aug 18th, 2006
0

Re: Data Lost!!

IT happens, to paraphrase the t-shirt slogan...
Administrator
Staff Writer
Reputation Points: 1418
Solved Threads: 37
Freelance Word Punk
happygeek is offline Offline
5,569 posts
since Mar 2006
Aug 18th, 2006
0

Re: Data Lost!!

Yesterday, I spent an hour or two with Google to explain what's it all about these massive "Generic Host Process" errors and added it to my thread. I saw it's gone today, so I was breeding a while about "what did I wrong? Did I push that "submit" button really? Do they hate me now?" and re-read the forum guidelines if I violated something. Now I know I didn't, which is a big relief... Being used to deal with really ugly and old forum softwares (other than this here) I should have known better: Always (!) write important postings offline using an editor, or at least copy and paste the posting to some safe place. Will I learn the lesson this time? (I guess...not. :rolleyes: )
Ah...yes I forgot: Spank, spank, chewout, boil in hot oil, you're grounded for the next 3 ehm...seconds. :cheesy:
Reputation Points: 32
Solved Threads: 11
Posting Whiz in Training
Xpenetrator is offline Offline
277 posts
since Jul 2006
Aug 18th, 2006
0

Re: Data Lost!!

Everyone is entitled to a better description as to exactly what happened, and now that I am done yelling at myself, I can gather together enough composure to explain ...

The datbase server we have hosts two databases, the live database and a test database which I am playing around with right now preparing for the forum upgrade. I wanted to copy a version of DaniWeb onto the test database. So what I went ahead and did is get a 12 hour old backup version of DaniWeb (I make regular automated backups every 12 hours). I put that backup version on the database server. Then, I logged into MySQL and into the test database. I then imported the SQL file.

What I didn't realize was that the SQL file included a 'use' line which switched databases on me to the live one without notice! So I ended up overwriting the live database with a 12 hour old backup version.
Administrator
Staff Writer
Reputation Points: 1422
Solved Threads: 162
The Queen of DaniWeb
cscgal is offline Offline
13,645 posts
since Feb 2002
Aug 18th, 2006
0

Re: Data Lost!!

I guess, similar things happened to all here already. I know how easy big amounts of data are gone, just by a wiggling mouse pointer or a single second of lost concentration. I sent a lot of precious data down the sink, not only once. You junked 12 hours = a few postings, and it's not all your fault. I managed to junk whole CD recordings, completed mixes and other work that took much more than 12 hours :o . I guess no one is or should be really mad on you. :cheesy:
Reputation Points: 32
Solved Threads: 11
Posting Whiz in Training
Xpenetrator is offline Offline
277 posts
since Jul 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in DaniWeb Community Feedback Forum Timeline: Being able to mark a thread "Solved"....
Next Thread in DaniWeb Community Feedback Forum Timeline: DaniWeb Donations





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC