The Network under the Bright-Bright Sky

…it’s just a matter of time when you will be punished.

It’s probably because I didn’t have a gratitude, or that I didn’t offer sacrifices to the god of computer on full-moon and new-moon, and I got punished today as a warning.

I was upgrading the Wordpress to 2.6, primarily for testing the compatibility of xLanguage. Of course, the first step is to dump the existing data to the testbed platform. It’s was a very long time when I was doing this last time, but luckily I have left the migration script somewhere. Bang! It’s still working, great!

Then I “diff”ed the part that I customized, and overwrote the existing binaries with 2.6’s as instructed, then patched the “diff”, all green.

I was going back to the Admin panel, was trying to see if the patch still works on 2.6. Before I could get to there, I found that some entries are gone! Now when I was checking the migration script…

“Darn…” I felt an icy wind was breezing over my cold sweating face…Looks like I have managed to reversed the migration direction, I had the production blog database overwritten with an very old testbed data.

I still recalled my Daily backup server was down for a while, original plan is to leave it there until I went back home. And just now, I was pinging it while hoping miracle to happen. No it didn’t happen, the computer returned “ssh: connect to host backup port 22: Connection refused.”

Let’s take a look at the MySQL’s log folder, looks like the God of Computer didn’t abandon me yet.  The Binlog that I turned on earlier is still functioning; I can still dump every SQL statements ever executed on the server.

It took me some time to locate the last blog migration from the binlog, then replaying all the MySQL statements in between. Well, it actually took much longer than I expected to replay 2 month worth of statements, even though I had filtered out the WassUp unless transaction, it was still taking it more than 1 hour to replay the remaining statements.

Take home message: it’s important to have backup, and probably multiple backup. According to a non-scientific survey, almost 90% of data disaster was introduced by Human. Thank god for guiding me over the process, and I should fix my backup server ASAP.

改編《自義勇軍進行曲》
Original - March of the Volunteer

Liberate the ID! Liberate the data!
(more…)

- Friday -

Alarm sounded, woke up, 8:40, but feeling sleepy…”let’s take the next bus.”

Alarm sounded, woke up, 9:40, still feeling sleepy, “snooze for 20 more minutes.”

Alarm sounded, woke up, 10 o’clock, still feeling sleepy, “just 3 more minutes.”

Alarm didn’t sound, woke up, 10:15, the bus was gone. The next one would depart at 13:45.

It seems that I had a meeting at 11. Actually, there is a shiproom meeting at 11 everyday. But the I/C is out of town today and…I was assigned to be the deputy I/C.

Holy…I was rushing to the taxi. It was a lucky day as the taxi was waiting at the gate of my  community.

10:50, 37 RMB, at office. Looks like the boss was having a conversation with everyone. Then he said, “If you were coming back for the Shiproom, I am sorry. It’s canceled. I just announced that everyone could go home now, and absolutely no working for today…”

Well, that said, I was forced to play Warcraft 3 in the office.

P.S.:
Shiproom meeting: everything critical to shipping a product is discussed.
Friday was a holiday because we reached a major milestone.

Sorry…the life is as messy as hell. Life is busy, as always.

Just managed to finish the writeup for the Rebuild of Eva the Movie, it’s about some interesting comparisons aginst the old TV version around the technology in Eva.