Utility Fog

Thursday, 15th of January, 2004

Well, some of you may have noticed that the server on which this resides had a hard disk crash (a physical crash - argh!) on the 27th of December, and so I had to pretty much reconstruct everything from scratch (I’m the server admin, more fool me…)
Thus I’ve been faking the entries so as to keep the playlists going, because I lost the entire database which the weblogs ran off.
Sordid details follow (check full entry), but basically tonight I managed to reinstate the old databases and hey presto! Back in action.

So above this little entry you now can see (or will in a minute) the playlist entries for the last three weeks. From now on, normal playlist updates will occur within a day of each show. Joy joy joy!

The back story:

Well this evening I finally got an email from the data recovery people (recovering data from a fucked-up hard drive is EXPEN$IVE!), and checked with some trepidation as I knew there’d been some data loss because of bad sectors.
He’d made everything available via ftp so I’ve spent the last couple of hours checking through everything, and in a recovered directory I found what looked like the mysql database files.
It took a good half-hour to reinstall mysql (after a couple of wrong turns - I’d copied over the mysql executables with the old ones, but they were the wrong version, so I had to reinstall the rpm…) and the mysql server on the new machine, then start the mysql server.
So imagine how I felt when I pulled up the Movable Type logon page once more, and it all worked! Logged in fine, and the four blogs I’m hosting all turned up, all entries and comments there…

I truly almost had a heart attack. All it took really was copying the entire contents of /var/lib/mysql

Comments are closed.