December 2005, Database Rollback

[Grandmaster]

Re: Another rollback - WHAT?

I just realized the 7-page long PDC '05 thread as well as all the CTP threads following Beta 1 were lost too.
Google Cache versions: http://www.google.com/search?hl=en&lr=&safe=off&q=+site:forum.osnn.net+osnn+pdc+thread

Any way to bring the content back? :s

EDIT: I'm working on getting something done...

*waiting*

 

[NetRyder]

Re: Another rollback - WHAT?

The PDC '05 thread has been fully recovered, cleaned up, and posted.
http://forum.osnn.net/showthread.php?p=665977

I'll be working on the monthly Vista CTP threads as I get the time.

 

[Grandmaster]

Re: Another rollback - WHAT?

Just how did you manage to get it? Kept on crawling Google?

 

[madmatt]

Re: Another rollback - WHAT?

Nope. Didn't you use it as a favicon for your site at one point?

I still have the 16x16 icon that you made.

 

[NetRyder]

Re: Another rollback - WHAT?

Just how did you manage to get it? Kept on crawling Google?

1) Did a Google Search for "site:forum.osnn.net" followed by the specific terms I was looking for. That restricted the search only to our forum.
2) Opened up cached versions of all the pages in each thread in different tabs and saved all of them.
3) Cleaned them all up by opening in Wordpad and doing a Find-and-Replace to remove all the highlighting and other extraneous stuff that Google adds to the cached pages.
4) Uploaded them all.

After the first couple of pages, it went really quick actually. The PDC thread was the longest one (7 pages) and it's up now. The individual CTP threads are much shorter, so I'll be able to get those done faster.

 

[Grandmaster]

Re: Another rollback - WHAT?

1) Did a Google Search for "site:forum.osnn.net" followed by the specific terms I was looking for. That restricted the search only to our forum.
2) Opened up cached versions of all the pages in each thread in different tabs and saved all of them.
3) Cleaned them all up by opening in Wordpad and doing a Find-and-Replace to remove all the highlighting and other extraneous stuff that Google adds to the cached pages.
4) Uploaded them all.

After the first couple of pages, it went really quick actually. The PDC thread was the longest one (7 pages) and it's up now. The individual CTP threads are much shorter, so I'll be able to get those done faster.

All hail Google and Kunal

That pretty much means we should be able to recover any thread as long as it was old enough and spidered...

 

[madmatt]

Re: Another rollback - WHAT?

That's how I found my signature.

 

[NetRyder]

Re: Another rollback - WHAT?

All hail Google and Kunal

That pretty much means we should be able to recover any thread as long as it was old enough and spidered...

Yep, so if you think of any threads that were particularly useful for future reference, just save the cached copies on your drive. They're not going to be online forever. I believe Google removes them after a certain period of time if the actual page itself no longer exists.

This could almost become another Legacy Mod effort, but it's far more painful this time.

 

[madmatt]

Re: Another rollback - WHAT?

The Windows Update thread was a good one. I'll dig.

 

[NetRyder]

Re: Another rollback - WHAT?

Another tip - it looks like MSN's search results might be more "fresh" in certain cases. I had heard about this before, but experienced it for the first time today. Sazar's Trading Post guidelines thread isn't in the Google search results, but I was able to retrieve the contents of the post from the MSN Search cache. So try both of them if you're looking for something to salvage.

Also, MSN doesn't do the query highlighting on the cached pages, so the cleanup process can almost be skipped. Find, save, upload. Not bad.

 

[Grandmaster]

Re: Another rollback - WHAT?

Another tip - it looks like MSN's search results might be more "fresh"

I had heard about this before, but experienced it for the first time today. Sazar's Trading Post guidelines thread isn't in the Google search results, but I was able to retrieve the contents of the post from the MSN Search cache. So try both of them if you're looking for something to salvage.

Also, MSN doesn't do the query highlighting on the cached pages, so the cleanup process can almost be skipped. Find, save, upload. Not bad.

Like I said in another thread, I'm impressed I guess MSN search is finally catching up with Google. (And in this case, surpassing it)

 

[Xie]

Re: Another rollback - WHAT?

Love the way we bounce back everytime. Great job EP, X, NetRyder and all the rest of you.


*not so sad about losing all those razr posts/folks hehe

 

[NetRyder]

Re: Another rollback - WHAT?

Mission accomplished!
http://forum.osnn.net/forumdisplay.php?f=63

...well, at least until I think of any other threads that need to be recovered.

 

[falconguard]

Re: Another rollback - WHAT?

Solid Nets! But you lost the fan club avatar:cry:

 

[NetRyder]

Re: Another rollback - WHAT?

Solid Nets! But you lost the fan club avatar:cry:

It was starting to get a little too confusing.

 

[kcnychief]

Re: Another rollback - WHAT?

1) Did a Google Search for "site:forum.osnn.net" followed by the specific terms I was looking for. That restricted the search only to our forum.
2) Opened up cached versions of all the pages in each thread in different tabs and saved all of them.
3) Cleaned them all up by opening in Wordpad and doing a Find-and-Replace to remove all the highlighting and other extraneous stuff that Google adds to the cached pages.
4) Uploaded them all.

After the first couple of pages, it went really quick actually. The PDC thread was the longest one (7 pages) and it's up now. The individual CTP threads are much shorter, so I'll be able to get those done faster.

That is a great tactic. How could some of us non-mods to this, in regards to hosting and storage space?

Just for ha-ha's, I found a couple off the top of my head that we could revive

 

[Electronic Punk]

Re: Another rollback - WHAT?

Good work mate
I'll be doing manual backups every night until I hear that X has his script working.

 

[Geffy]

Re: Another rollback - WHAT?

nice work NetRyder, I would give you rep, but I have to spread it around first apparently

 

[kcnychief]

Re: Another rollback - WHAT?

ew, 10mb attachment limit

 

[muzikool]

Re: Another rollback - WHAT?

The cached threads from MSN Search are much easier. Good thinking.

Technically, we could restore post counts and reputation based on the latest cached pages just before the crash. I know, I know it doesn't matter blah blah blah blah...