All in the <head>

– Ponderings & code by Drew McLellan –

– Live from The Internets since 2003 –

About

My Goodness, My Guinness, MySQL

13 November 2003

That was all a bit alarming. If you didn’t catch my site in the last five hours or so, I just had me some database problems. It looks like the comments table in my MySQL database became corrupt (for no identifiable reason) and all my comments stopped working. Worse still the homepage was giving errors until I noticed and posted a message without comments enabled, which it managed to display.

Of course, I’d been meaning to take a backup of my database. It’s dead easy to do a mysqldump to export the entire database to a file, but had I? You bet I hadn’t. I have now though.

The cause is unknown, but the solution was easy:

repair table txp_Discuss

... and that was it. Fixed. Problems are much less stressful when the solution is easy. Good job MySQL people.

Related in as much as I know need to increase my alcohol intake, it would appear that Guinness is good for you. Hooray! I always knew it.

- Drew McLellan

Comments

Tags

Comments

Photographs

Work With Me

edgeofmyseat.com logo

At edgeofmyseat.com we build custom content management systems, ecommerce solutions and develop web apps.

Recent Links

Affiliation

  • Web Standards Project
  • Britpack
  • 24 ways

About Drew McLellan

Photo of Drew McLellan

Drew McLellan has been hacking on the web since around 1996 following an unfortunate incident with a margarine tub. Since then he’s spread himself between both front- and back-end development projects, and now is Director and Senior Web Developer at edgeofmyseat.com in Maidenhead, UK (GEO: 51.5217, -0.7177). Prior to this, Drew was a Web Developer for Yahoo!, and before that primarily worked as a technical lead within design and branding agencies for clients such as Nissan, Goodyear Dunlop, Siemens/Bosch, Cadburys, ICI Dulux and Virgin.net. Somewhere along the way, Drew managed to get himself embroiled with Dreamweaver and was made an early Macromedia Evangelist for that product. This lead to book deals, public appearances, fame, glory, and his eventual downfall.

Picking himself up again, Drew is now a strong advocate for best practises, and stood as Group Lead for The Web Standards Project 2006-08. He has had articles published by A List Apart, Adobe, and O’Reilly Media’s XML.com, mostly due to mistaken identity. Drew is a proponent of the lower-case semantic web, and is currently expending energies in the direction of the microformats movement, with particular interests in making parsers an off-the-shelf commodity and developing simple UI conventions. He writes here at all in the head and, with a little help from his friends, at 24 ways.

Recommended