Network gone from listings..?

w00t · Posted: Jun 05, 2008 5:41pm Post subject: Network gone from listings..?

Umm.

It seems our network (ChatSpike) has just vanished from the networks listing?

Can someone perhaps tell me *why* this would be the case when it's been there for the last few years?

braindigitalis · Idler Joined: 22 Sep 2003 Posts: 443 Location: IRC

Yeah where has it gone?! Its vanished out of MyNetworks in the control panel, completely! all its history, its channel reviews, and everything!!! HELP!

(I was the maintainer for this entry)

Jason · Posted: Jun 05, 2008 7:19pm Post subject:

I pulled a backup file and didn't see it. Going to pull an older backup so I can get the network info and readd it.

I've converted the network table to innodb so that we don't see the table get corrupted like it's done recently.

PingBad · Guru Joined: 05 Feb 2005 Posts: 2075 Location: New Zealand

I've noticed in the last 3 yrs that I've been harrassing these forums that table corruption is becoming more and more common (just an observation, and not a dig at Jason's administrative abilities) - out of pure curiosity, I'm wondering if you have some sort of MySQL Master/Slave replication going on, jason? It might alleviate a lot of corruption issues in the future

Jason · Posted: Jun 05, 2008 7:29pm Post subject:

the problem is that myisam sucks if your server crashes. It doesn't deal with it well.

The box is crashing and I only do one db dump per day. I made a few changes, we'll see if it stabilizes or not.

Jason · Posted: Jun 05, 2008 8:49pm Post subject:

Restored about 100 networks from two different database dumps from the past.

braindigitalis · Idler Joined: 22 Sep 2003 Posts: 443 Location: IRC

Yay, thanks Jason Very Happy