PDA

View Full Version : What happened



webmaster
03-24-2007, 08:34 AM
On Friday evening, I discovered that the site was offline and inaccessible. I tried restarting the server, but it couldn't boot. The hosting company installed a new HD and put the old HD in to alow any data recovery. Unfortunately, all the home directories and backups on the drive appeared to be gone. Simultaneously, I began the slow process of uploading the rather large backup of the site and restoring it from backup.

That backup appears to have been a late January backup, unfortunately. I thought I had a backup created after restoring from the earlire attack, but it looks like I don't. I'm going to double-check when I get home--I am out of town over the weekend (Great time for the site to go down, eh?!)--but I suspect this is it. Mea culpa!

Things like this aren't all bad. It provides a strong incentive to have an off-site backup strategy (daily backups are kept on the server, and I periodically download a daily backup to my desktop machine), and that's something I will be thinking more about in the coming days, probably automating some kind of FTP backup. I'll also be re-upgrading the BB to the latest vBulletin version when I get home.

Sorry for your lost posts (or accounts, for those of you who recently registered) and the confusion that this has caused by my absence when the site came back online.

swgh
03-24-2007, 09:07 AM
Thank you for the explanation webmaster. I did wonder what happended. Thank you for restoring it to it's formar glory.

Is there any chance this may happen again? And if so, is there only possible way to prevent it? I know all programs crash, but I am only wondering thats all.

twomers
03-24-2007, 10:58 AM
I thought you were dead :(

Sentral
03-24-2007, 12:01 PM
Thank you for the explanation webmaster. I did wonder what happended. Thank you for restoring it to it's formar glory.

Is there any chance this may happen again? And if so, is there only possible way to prevent it? I know all programs crash, but I am only wondering thats all.
It's partially the webmaster's fault and the hosting company. The webmaster doesn't have control over what the hosting company does. So yes, it could happen again. However, the webmaster didn't have an offline backup (on his local HD, not the server's HD). Yes, it could have been prevented.

dwks
03-24-2007, 02:31 PM
Is there any way to automatically save all of google's cached pages? If you did so you could update the database to reflect all of the posts and threads etc . . .

KONI
03-24-2007, 02:44 PM
Even if that would be possible, you'd have to write a script that parses the threads, extracts the information and creates SQL queries. The whole thing gets a lot more complicated because the user ID's are the same anymore, there might be posts from users who don't exist anymore etc ...

If the host doesn't have a more recent backup then the posts are gone ... and even if he would have and we could use it, then we might risk to lose the posts that have been made today and in the near future.

dwks
03-24-2007, 02:49 PM
Yeah, I know, it was just wishful thinking. :)

You could get a page of 100 search results and look for the url before "Cached</a>" and use wget (under Linux) to get it . . . well, you could if you were using Linux, which I'm not at the moment.

Cactus_Hugger
03-24-2007, 08:57 PM
and use wget (under Linux)wget is available (http://www.google.com/search?&q=windows%20wget) under windows. Great little tool.

I've always thought backups on the same media as the original were fairly worthless. Then again, I don't backup much, so I probably don't have the right to speak. Not sure if I'd worry about trying to restore the loss- people have already started posting again, and interleaving the gap in might be... interesting. (Clashing IDs and such.) Or we'd lose our giant speculation thread, and hey - there'll be this interesting gap of no posts for a whole month. ^_^ In a few months/a year, only a few will know why. (If anyone cares...) That, or we saved CBoard some disk space for the month of Febuary.

DavidP
03-25-2007, 08:25 AM
I had the same little idea about just using pages that might have been cached...so i went to the Coral website

Coral Content Distribution Network (http://www.coralcdn.org/)

Coral's whole job is to take webcaches and use them as back ups to other sites when other sites go down, people can come to Coral and look at what was cached.

Didn't seem to work....Coral had cached the site, like expected, but it didnt have any of the old posts. I guess either it had done a really recent cache, and so the older cache wasn't there anymore, or it had downloaded the actual PHP files and sent real queries to the server....instead of caching previous results...

Oh well.