OJBs Web Site: Blog Page

Note: You are currently viewing my old web site. There is a new version with most of this content at OJB.NZ.
The new site is being updated, uses modern techniques, has higher quality media, and has a mobile-friendly version.
This old site will stay on-line for a while, but maybe not indefinitely. Please update your bookmarks. Thanks.

Add a Comment (Go Up to OJB's Blog 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.

To add a comment: enter a name and email (both optional), type the number shown above, enter a comment, then 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.