The recent data loss

Manages technical infrastructure for the board and website; make administrative requests here

Moderator: Erik Mortis

Post Reply
User avatar
Ari Rahikkala
Posts: 4326
Joined: Sun Jan 21, 2001 12:56 pm
Contact:

The recent data loss

Post by Ari Rahikkala »

Sooo... usually when someone screws up at something technical and it breaks things for others they're really elaborate about exactly what happened. That'd be pretty pointless now because the mistake was quite simple.

I was working on getting back the old posts that had gotten truncated in the forum move. I was using at the same time a development database into which I would do a fresh import of the data from the old forum in case I managed to mangle the data in it, and a renamed posts table in the live database so I could try to figure out how to import the fixed data from one table to another. This morning, after I'd been at it for a couple of hours, cursing the names of various things that had been causing me trouble... I accidentally did a fresh import of the data from the old forum into the live database instead of the development one.

So, yeah. The forum timewarped into the moment of the move from shireroth.kuroshiro.net. The data loss was irrevocable - the only thing that I know of that could have brought it back is memory-hacking the mysql server or its storage, and I have neither the skill nor the privileges for that.

Luckily I'd taken a backup before I started any work at all last night, so we only lost one day's posts instead of a week's. So, you know, could have been worse.

Note that since the bank and wiki are also in the same database, they have also time-warped to last night.

I am sorry. I'll be more careful next time I work on the database.
No-one should be without a parasol, Sirocco.
User avatar
Aurangzeb Khan
Posts: 3251
Joined: Tue Jan 30, 2007 12:22 pm
Location: The Citadel, Ardashirshahr

Re: The recent data loss

Post by Aurangzeb Khan »

As a wise man once said - shit happens. I don't think anyone said anything particularly interesting yesterday anyway, so you chose as good a day as any for a technical cock up. Still, nice save with the back-up, eh. :document
User avatar
Jonas
Posts: 5334
Joined: Mon Feb 19, 2007 9:53 am

Re: The recent data loss

Post by Jonas »

No problem, Ari.
From a distance I'm concerned about the rampant lawyerism manifesting itself in Shireroth currently. A simple Kaiserial slap on the wrist or censure by the community should suffice. - Jacobus Loki
Can't you see? I'm crazy! :tomcutterhamonfire :smashy
User avatar
Jacobus Loki
Posts: 4205
Joined: Mon Oct 02, 2006 1:00 pm

Re: The recent data loss

Post by Jacobus Loki »

One of the advantages of missing a day.

Nothing compared to the monster worms and hacks of ancient days.....
Post Reply

Return to “Ministry of the Interior”

Who is online

Users browsing this forum: No registered users and 5 guests