[tmbchr]™

Website Problems, Duh!



In case you haven’t had the pleasure of witnessing them firsthand, my hosting company has been having some severe issues lately. Some server seems to have gotten fried and a whole bunch of customers got sucked down into the vortex, including the main database for this website. Fortunately though, they have a pretty awesome backup service that automatically stores things in a (seemingly) separate location every day for the past week, and then I think every month for the past five months beyond that. So eventually, I just decided to roll back to a previous version of my database rather than wait to hear from tech support on how to resolve my issue. Chances are, they would have just told me to do that anyway, since the table that held my posts was “marked as crashed” and couldn’t be automatically repaired. I’m not a big MySQL guru, but I know that’s a pretty bad thing.

Anyway, we should be back in action here and my apologies for both the downtime and for anybody’s comments who may have been wiped in the rollback.

,





6 Reader Responses

  1. Tim Boucher Says:

    On second thought, through some MySQL manipulation, I think I have successfully re-instated most of the old comments from before the site went totally haywire!

  2. JohnEmerson Says:

    Having spent some time maintaining servers, ‘ouch!’. A downed vps setup sets off sympathy fire right down every nerve in my body.

  3. Michael Says:

    yeah, whenever your site has problems, I always am afraid that you’ve been shut-down by the Archons, and your involved in some sort of high-speed car chase for your survival… this time, no. But next time, who knows?

  4. Tim Boucher Says:

    You also have no way of knowing that I haven’t been replaced by someone else or by a super-intelligent simulation.

    But then, you also have no way of knowing that wasn’t the case all along!

  5. Thomas Conlon Says:

    the transaction log knows all

  6. Daniel Says:

    The part that sucks about something like that happening is that unless you’re really on top of things, some hosting companies just like to shuffle away the blame. Not all, of course, which is lucky. I recently signed up with Pingdom to at least get alerted whenever my server goes down. If my web host gives me any problems, I’ll just send him the Pingdom logs. Of course, doesn’t help me get anything back up, but at least I know about the problem.



SURROUND YOURSELF WITH STRENGTH.