Overview

PDU provides data recovery methods for various MySQL failure scenarios. Choose the appropriate recovery method based on your situation.

Choose Your Recovery Scenario

Export data directly from a data-directory copy when the instance cannot start.

Choose file extraction or surviving-page recovery using IBD and schema evidence.

Recover a selected database while preserving required instance-level metadata.

Extract parseable complete active records from MYD, MYI and matching definitions.

Recover data from before DELETE using Binlog.

Recover data from before UPDATE using Binlog.

Choose a recovery path from surviving page views, Undo history and complete Redo.

Reconstruct one table at a specified historical point using a CREATE/TRUNCATE starting point observed in the logs.

Use DropScan to scan surviving pages and record possible table definitions, object generations and dependencies for large values.

Scan InnoDB pages in a stable image and extract surviving records after schema binding.

Diagnose read-only, capture deleted files that remain open and prepare reviewable IMPORT tasks.

Handle views, triggers, routines, events and sparse-dictionary object attributes separately.

Recovery Scenario	Materials	Output
Recover from Corrupted Instance	data directory · FRM / SDI	Data SQL and DDL
Recover from Corrupted Data File	IBD · DDL	Data SQL
Recover Single Database Directory	data directory · metadata	Database data SQL
Recover MyISAM Data Files	MYD / MYI · DDL	Complete active records
Recover Deleted Records	Binlog · DDL	Recovery SQL
Recover Updated Records	Binlog · DDL	Reverse recovery SQL
Recover Data from Undo and Redo	base copy · Undo / Redo	Page views and recovery SQL
Recover a Historical Binlog Snapshot	ROW Binlog · endpoint DDL	Historical table row set
Recover Scattered InnoDB Pages	image · binding	Sparse records and dependencies
Recover Dropped Tables Without Backup	image · DDL	Surviving data SQL
Diagnosis and Native IMPORT Assistance	IBD · profiles	Diagnosis and operation tasks
Recover Metadata for Other Objects	TRG / FRM / DD	Object attributes and definitions

Configure the data directory and output paths, start PDU and initialize, then select the database and recovery method.

MYSQL_DATADIR=/recovery-input/mysql/data
BINLOG=/recovery-input/mysql/binlog
RESMODE=tx
RESTYPE=delete

param datadir /recovery-input/mysql/data;
b;
\l;
use appdb;
\dt;