Site BLOG PAGE🔎 SEARCH  Ξ INDEX  MAIN MENU  UP ONE LEVEL
 OJB's Web Site. Version 2.1. Blog Page.You are here: entry641 blog owen2 
Blog

Add a Comment   Up to OJB's Blog List

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:number
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 2024-08-22 Stirring Up Trouble: Let's just get every view out there and fairly debate them..
 Site ©2024 by OJBOJB's BlogMicrosoft Free ZoneMade & Served on Mac 
Site Features: Blog RSS Feeds Podcasts Feedback Log04 Nov 2024. Hits: 43,695,069
Description: Blog PageKeywords: BlogLoad Timer: 12ms