site down since last Friday

Nov 10, 2014, 4:06 pm
#1
capristo's avatar
The Imperialist


Joined: Dec 2, 2007
Location: New Attnam
Interests: bananas
Posts: 2,195
I am really sorry about this guys. Here is what happened

  • On Oct 24th, the server crashed and I had to recover the data. We didn't lose anything but I had to reset the daily backup script.
  • When I reset the backup script, unfortunately I set the /path/to the script incorrectly
  • I also forgot to tell it to MAILTO me whenever there was a cron error, which would have alerted me to the previous mistake
  • And then this past Friday, my friend from high school who I share this server with, accidentally deleted all of my MySQL databases.

This completely sucks because if any one of those four things had not happened it would have been fine. But because of the combination of all four, we've lost all posts, shoutbox posts, Wiki edits, and users from Oct 24 - Nov 7.

I think the only active user who joined during that time was mistress, and fortunately since she knows Alveradok, I emailed him to explain and ask her to rejoin.

Thanks to 4zb4, Eagle, and Erno, I have some cached copies of some of the active topics during that time which I will try to restore asap have restored.

In the meantime you can continue posting as usual. I'm going to also pay extra so that our host automatically creates daily backups of the entire server on top of my backup script.
Nov 10, 2014, 4:09 pm
#2
capristo's avatar
The Imperialist


Joined: Dec 2, 2007
Location: New Attnam
Interests: bananas
Posts: 2,195
If you have Chrome and are able to, please check if you have any topics cached:

  • Open a new tab and go to the URL: chrome://cache/
  • Search for "attnam.com/topics" or "attnam.com/posts"
  • For any of these links, click and open in a new tab. It should show a bunch of random numbers and letters
  • Go to http://www.sensefulsolutions.com/2012/01/viewing-chrome-cach...
  • Copy the entire page contents and paste them, and then download the cached file (should be in .gz format)
  • Mail these .gz files to capristo@attnam.com

Thanks for the help.
Nov 10, 2014, 5:46 pm
#3
capristo's avatar
The Imperialist


Joined: Dec 2, 2007
Location: New Attnam
Interests: bananas
Posts: 2,195
Ok I've recovered everything I could. Please see previous post and help salvage anything from your cache if you can

Completely recovered topics (I think), including attachments:

- Teleporting objects
- pictures thread
- peaceful massacre of Attnam

Shoutbox posts - the 35 most recent

mistress's fan art upload

The timestamps on all of that might be off because I'm not sure what timezone everybody who sent me cache files was in



Based on the database indexes I'm guessing we lost
- 4 new topics
- 51 posts
- 28 shoutbox posts

Again I really apologize. I can blame my friend for deleting everything but really if I had had the backup script running properly this shouldn't have been a big deal
Nov 10, 2014, 6:30 pm
#4
Ernomouse's avatar
Master mine stomper


Joined: Dec 16, 2007
Occupation: Pouring molten bronze in sand
Location: In the cold end
Posts: 2,048
These things happen, we understand. Great job restoring the site with as little damage!

51 posts sound like a whole lot for the activity we get, I wonder what was among those...
Nov 11, 2014, 2:12 pm
#5
Joined: Sep 8, 2010
Occupation: Petty Functionary
Location: Drinking pea soup in the world map
Interests: Mangoes
Posts: 1,171
Thanks for working so hard to get us back up Cap!
Nov 12, 2014, 8:00 am
#6
Joined: Dec 4, 2007
Posts: 183
You're doing fantastic work, my friend!
Jump to