Recovered from database Disaster / Corruption
Earlier today monit reported Lighttpd webserver problem. Due to MySQL database corruption site was down for almost 2hrs.
We restored all data, again, without any loss of files or posts/articles except comment made after 24th Jan 2007! Entire site is roll-back to last good backup which was made on 23-Jan-2007.
Thanks to NAS backup.
As usual disaster strike at midnight (3AM):

(Traffic hit graph)
If you see any problem please write to me vivek ReMoVeMe AT nixCraft . COM.
Want to stay up to date with the latest Linux tips, news and announcements? Subscribe to our free e-mail newsletter or RSS feed to get all updates.
You can Email this page to a friend.
You may also be interested in other helpful articles:
- Humor: Unusual data disaster horror stories for 2007
- Repairing Linux ext2 or ext3 file system
- Mount a Linux filesystem on a SAN from multiple nodes at the same time
- How to deal with common PHP database problems
- Oracle Database available for Debian/Ubuntu and other Linux distributions
Discussion on This Article:
Leave a Reply
We encourage your comments, and suggestions. But please stay on topic, be polite, and avoid spam. Thank you very much for stopping by our site!


Do you use a good system to detect and get notified of disasters that you can recommend? I would sleep better if I could just check my e-mail after midnight…
I’m using Nagios, Munin, Monit and few custom made perl/shell scripts. You need to play with these tools all of them are quite effective.