site down since last Friday

Nov 10, 2014, 4:06 pm

#1

The Imperialist

Joined: Dec 2, 2007
Location: New Attnam
Interests: bananas
Posts: 2,309

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

The Imperialist

Joined: Dec 2, 2007
Location: New Attnam
Interests: bananas
Posts: 2,309

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

The Imperialist

Joined: Dec 2, 2007
Location: New Attnam
Interests: bananas
Posts: 2,309

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

Master mine stomper

Joined: Dec 16, 2007
Occupation: Shoveling. But metal.
Location: Blazing in the steppes
Interests: Absolutely fuck-all.
Posts: 2,050

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

archangel

Joined: Sep 8, 2010
Occupation: Petty Functionary
Location: Drinking pea soup in the world map
Interests: Mangoes
Posts: 1,216

Thanks for working so hard to get us back up Cap!

Batman? wrote

its been so long since i had gotten that far i didnt think it through. arrrr!!!!!!

Nov 12, 2014, 8:00 am

#6

blink dog

Joined: Dec 4, 2007
Posts: 184

You're doing fantastic work, my friend!