Intro
This data recovery project for Buffet Olives required the reconstruction of critical content lost in a WordPress installation. The solution involved extracting raw SQL data, organizing it into usable formats, and delivering it in both Excel and HTML for future use and referencing.
Case Summary
WordPress Data Recovery – Buffet Olives
Year: 2023
Overview
After content loss in a WordPress environment, Buffet Olives needed assistance retrieving and restoring archived content including PDFs, images, and metadata entries.
Platform & Stack
- Platform: WordPress (legacy database)
- Database: Direct SQL extraction from MySQL dump
- Tools: Excel, PHP scripts, HTML/CSS
- Output: Static browsable webpage + Excel sheets with attachment references
Features
- SQL data extraction from damaged or lost tables
- Data normalization and cleanup
- Conversion to Excel with proper formatting
- Generated HTML page showcasing entries with links to PDFs/images
- Lightweight and offline-browsable deliverables
Hosting & Deployment
- Local data processing and secure delivery
- No changes to production site — all work handled externally
- Output optimized for archival and low-maintenance use
Result
Restored access to essential documents and structured content previously lost — allowing Buffet Olives to preserve historical data and maintain operational transparency.