Emergency Data Recovery: Corrupt MySQL InnoDB → Zero-Loss Extraction in 48 h

 Midnight Crisis

Power spike → MySQL 8.0 InnoDB tablespace corrupted; mysqld refuses start; last backup 18 h old. CFO demands zero transaction loss before market opens.

48-Hour Rescue Plan

• Remote triage (30 min) → copy corrupted ibd files to isolated EC2.
• Undrop-for-InnoDB toolkit extracts records directly from tablespace.
• Percona Toolkit pt-table-checksum validates extracted rows.
• Parallel insert into new cluster → 18 h gap closed.
• Forensic PDF: root cause, prevention checklist.

Deliverables

• Recovered SQL dump + checksum CSV.
• Forensic report (PDF) signed with GPG