Recovered from database Disaster / Corruption

Earlier today monit reported Lighttpd webserver problem. Due to MySQL database corruption site was down for almost 2hrs.

ADVERTISEMENTS

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):
mint-reports.png
(Traffic hit graph)

If you see any problem please write to me vivek ReMoVeMe AT nixCraft . COM.

🐧 Get the latest tutorials on SysAdmin, Linux/Unix, Open Source & DevOps topics via:
CategoryList of Unix and Linux commands
File Managementcat
Network Utilitiesdig host ip nmap
Package Managerapk apt
Processes Managementbg chroot disown fg jobs killall kill pidof pstree pwdx time
Searchinggrep whereis which
User Informationgroups id lastcomm last lid/libuser-lid logname members users whoami who w

ADVERTISEMENTS
2 comments… add one
  • Motin Mar 5, 2007 @ 2:58

    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…

  • 🐧 nixCraft Mar 5, 2007 @ 14:56

    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.

Leave a Reply

Your email address will not be published. Required fields are marked *

Use HTML <pre>...</pre>, <code>...</code> and <kbd>...</kbd> for code samples.