Restoring from Backup

Abe Olandres Editor-in-chief April 28, 2005 · 1 min read

Listen to article

The realme P4 series features the country's first 10,001mAh phone HKC releases world's largest 12K ultrawide curved monitor PH, Israel open a new digital learning hub in Manila MSI cements NVIDIA partnership with first RTX Spark laptop Google slated to drop $80B on AI after record-breaking revenues

backup Several comments and posts were lost due to mySQL DB corruption for reasons still unknown to me. I have to track all the posts that were lost and the comments and shouts made in the past two days. Some of them I was able to re-port while others (esp. the comments) are in lost forever.

It was partly my fault. I forgot I had an auto-backup plugin which saved all the posts and comments in SQL format so what I should have done was just revert to it. Instead I used the cPanel daily backup from the server which is 24 hours stale. Such is life.

(Update: the /tmp partition of the server was full and caused mySQL cached queries to return an error.)

React to this article:

Abe Olandres

Editor-in-chief

Abe is the founder and Editor-in-Chief of YugaTech with over 20 years of experience in the technology industry. He is one of the pioneers of blogging in the country and is considered by many as the Father of Tech Blogging in the Philippines.

8,006 Articles