Add a Comment   Return to Previous Page

Fragile

Entry 641, on 2007-11-14 at 19:47:26 (Rating 1, Computers)

A recent incident reminded me of how fragile some of my data really is. I have been running MySQL databases on Mac OS X computers for years now, and I haven't been too careful about maintaining the databases - they just work. Or they did until I had a problem - ironically with my backup software - which forced a restart of one server. After the restart many of the tables in the databases on the server were corrupted so I had to repair them as quickly as possible (the servers are running 24/7).

I had some strange results from normally reliable recovery tools but in the end everything was working again OK with no data loss. Some functions of the databases were down for a few hours but I'm confident, now that I know the tricks, I could recover from a similar issue in the future much more quickly.

So my data is a bit more delicate that I thought. This is the only time I've ever had a problem with MySQL and I still think its the best database there is. But in future I will protect my data and spend a bit more time shutting down services gracefully and avoid the quick fix of a restart!

There are no comments for this entry.

You can leave comments about this entry using this form.

Enter your name (optional):
Enter your email address (optional):
Enter the number shown here:
Enter the comment:

To add a comment: enter a name and email (optional), type the number shown, enter a comment, click Add.
Note that you can leave the name blank if you want to remain anonymous.
Enter your email address to receive notifications of replies and updates to this entry.
The comment should appear immediately because the authorisation system is currently inactive.

I do podcasts too! You can listen to my latest podcast, here: OJB's Podcast 2026-04-14 How Far is that Star?: How would we really know how big the universe is? Or subscribe to my podcast RSS feed, on my RSS Feeds page.

If you're not sure what to view from the thousands of pages on my site, here are some suggestions: My Latest Airshow Report (photos and movies from Warbirds Over Wanaka, 2026), My Favourite Wines and Beers (tasting notes for some of my favourites), An Interesting Astronomical Observation (learn a bit about astronomy from these observing notes), See Some Photos (A short rail journey through the Taieri Gorge), Read Some Mac Tips (Learn about how to use your Mac, and fix some problems).

Latest Site News and Notifications (Desktop): You are currently viewing OJB's web site, version 2.4 which has some major changes, and possibly errors! Please report any problems to ojb@mac.com.