This is the website of Abulsme Noibatno Itramne (also known as Sam Minter). Comments here or emails to me at abulsme@abulsme.com are encouraged... or follow me on Twitter as @abulsme.

Categories

Calendar

AbulWiki Down

On Wednesday something screwed up my mysql database that I have AbulWiki on. I didn’t notice until this morning though. By that time my daily backups had run twice, so I didn’t have a last good version. To say the least, I freaked out a little bit.

I’ve spent the last couple hours on it and I was able to start up mysql in a safe mode and do a data dump and I don’t think I’ve lost any data after all. Which is good. Very good. I also found a data dump I’d done ten days ago in another place. Also good. But what is bad is that I still can’t get mysql to start except in the read only safe mode. Which means I can’t make the wiki actually run of course.

According to the errors in the logs, the issue is a corruption in one of the InnoDB tables. The start up in innodb_force_recovery mode lets me do a mysqldump and get everything. And it looks like there is no actual data loss. But then it looks like the next step is supposed to be to drop the tables that are causing errors on start up, and then restore from your backup. But whenever I try to drop tables, mysql crashes and restarts and the tables are still there.

After running in circles, I’m starting to think I just want to wipe out mysql and reinstall from scratch, then restore my (hopefully) good dumps. The mysql dump I just did in safe mode is refusing to be read by MySQL Administrator due to character set issues. Hmmm…. The one from 10 days ago can be read. As can a backup I did using the Admin tool instead of doing mysqldump on the command line. Actually, both of those were done with the Admin tool rather than mysqldump. Sigh. In either case though, I can’t do jack until I can get mysql to start in regular mode rather than innodb_force_recovery mode.

And I am late to work. I need to go do work stuff now rather than bang my head on this.

But it seems clear what I’ll be doing tonight when I get home.

Fighting with mysql and hoping that these data dumps I’ve done are really usable and I haven’t lost anything (or at least not much). Looking at the mysqldump ones (which are human readable even if the GUI restore tool isn’t happy with them) they look OK, but…

Sigh.

Bleh.

Not happy Sam this morning.

Gotta go to work.

Windy

There is a wind storm tonight in Seattle. The news was all about how they were going to close the bridges over Lake Washington because of the high winds. They were also talking about power outages.

Brandy was in a gas station earlier and overheard some Department of Transportation folks talking about how they were likely to do it “soon”. So I left work a little early so I’d be on the right side of the lake if that happened.

Traffic sucked a little more than usual heading home, but the bridge was open, and I got home, then worked from home for a bit.

The winds are dying down now. We didn’t lose power. And I don’t think they ever ended up actually closing the bridges.

Oh well.