Because of the incident, database backup will be done on a weekly basis. Now, it's just a monthly backup. It's good that the last backup covers up to Jan. 3, 2010. What happened was that all the 314,000 posts were obliterated because of just a single SQL command. My heartbeat stopped when I saw tubagbohol absolutely empty of posts.
It's good that tubagbohol is using a virtual private server which has a feature of a segregated backup in a remote disk. The latest backup was restored into the site two hours after the fatal, heart-stopping destruction of the database.
This time I am even thinking of twice-a-week backup and store it in three separate external hard disks.
Linkback:
https://tubagbohol.mikeligalig.com/index.php?topic=24539.0