This documentation applies to Linux and source versions MySQL 5.7.44, 8.0.28 and 8.0.46. Before recovery, copy the data directory, Binlog, Redo/Undo and schema evidence, and work on a separate copy. Confirm other versions and special layouts separately.

Non-table Object Creation Commands

meta view-create <RAW_VIEW> 50744 <DATABASE> <VIEW> [summary];

Generate view creation evidence from the original view file, retaining algorithm, security and session context.

meta routine-create <MYD> <MYI> <ORIGINAL_DDL> <FRM> 50744 <DATABASE> <NAME> <FUNCTION|PROCEDURE> [summary];

Generate function or procedure creation evidence from matching original sources.

meta trigger-create <TRG> <TRN> 50744 [summary];

Generate trigger creation evidence, retaining SQL mode, character sets and client delimiters.

meta trigger-context <TRG> 50744 [summary];

Inspect trigger bodies, actions and session context.

import show <TASK>;

Inspect a native IMPORT task and recorded execution phases.

import record <TASK> <PHASE> <NATIVE_RESULT_PROFILE>;

Record native results of external engineer execution without executing IMPORT automatically.

Metadata Viewing Commands

b;

Initialize database metadata.

\l;

View the list of available databases.

use <database>;

Select and enter the specified database.

\dt;

View tables in the current database.

\d <table>;

View the definition of a specified table.

\d+ <table>;

View detailed metadata for a specified table.

meta ddl <file>;

View schema information from a CREATE TABLE file.

Data Export Commands

unload tab <table>;

Export data from a specified table.

unload db <database>;

Export data from a specified database.

unload ddl <database>;

Export table definitions from a specified database.

unload ibd <file> <DDL> [index_id];

Parse an IBD using matching DDL and export data-only SQL.

Recovery Commands

ckbinlog;/ckwal;

Check Binlog CRC and rotation continuity.

scan <table>;

Scan log or physical-history records for a specified table.

restore del <TxID>|all;

Generate recovery SQL for deleted records.

restore upd <TxID>|all;

Generate reverse-order recovery SQL for updated records.

restore tx <TxID>|all;

Recover observed reversible transaction combinations with ordering and conflict checks.

restore dead <TxID>|all;

Export delete-marked page candidates without inferring business deletion or commit status.

restore hist all;

Generate a table snapshot at a specified historical point from continuous ROW logs.

Dropped Table Scanning Commands

ds idx <sources> [chunks N];

Scan the source manifest and preserve page candidates.

ds show <task> [all|sources|candidates|objects|metadata];

View scan-task sources, candidates and metadata.

ds bind <task> <binding> <id>;

Create a recovery binding using explicit schema and attribution evidence.

ds unload <task> <id> [units N] [parent <recovery-task>];

Extract data using a frozen binding without overwriting existing output.

ds resume idx <task> [chunks N];

Continue from a native scan checkpoint.

ds resume unload <task> <id> [units N] [parent <recovery-task>];

Continue using native recovery records and file metadata.

Parameter Management Commands

show;

Display all current parameters and their values.

param <name> <value>;/p <name> <value>;

Set a specific parameter value.

reset;

Reset parameters and the session to defaults.

info;/i;

Display version and engine status.

help;/h;

Display help for available commands.

exit;/\q;

Exit PDU.

Diagnosis and Auxiliary Commands

diagnose ibd <file> [profile|-];

Read-only diagnosis of sources, layouts, metadata and recovery paths.

meta view <file> <exact_version>;

Extract metadata attributes from an original view file.

meta trigger <file> <exact_version> [summary];

Extract metadata attributes from an original trigger file.

meta objects <mysql.ibd> <database> <exact_version> [summary];

Extract non-table object attributes from bounded 8.0 sources without executing CREATE.

import qualify <IBD> <diagnosis> <import_config>;

Check native IMPORT eligibility separately from diagnosis.

MyISAM and Native IMPORT

myisam inspect <MYD> <MYI> <DDL> <VERSION> [FRM_OR_SDI|-];

Inspect MyISAM files and matching schema evidence read-only, without inheriting InnoDB physical-format support.

myisam unload|resume <MYD> <MYI> <DDL> <VERSION> <TASK> [FRM_OR_SDI|-] [MAX_NEW_UNITS];

Export or resume a MyISAM task using native completion records and file metadata.

import qualify <RAW_IBD> <DIAG_PROFILE> <IMPORT_PROFILE>;

Assess IMPORT eligibility independently; passing diagnosis does not replace eligibility.

import prepare <RAW_IBD> <DIAG_PROFILE> <IMPORT_PROFILE> <NEW_TASK>;

Prepare reviewable IMPORT operation evidence without automatically executing target-database operations.

import record <TASK> <PHASE> <NATIVE_RESULT_PROFILE>;

Record native results from an externally executed phase without revalidating exported data.

import show <TASK>;

View the IMPORT task and evidence.

Metadata for Other Objects

meta view <RAW_VIEW> <EXACT_VERSION>;

Read view metadata with the exact source version.

meta trigger <TRG> <EXACT_VERSION> [summary];

Read metadata from a trigger file.

meta trigger-create <TRG> <TRN> 50744 [summary];

Export trigger CREATE and session context from bounded 5.7.44 sources without executing them.

meta trigger-context <TRG> 50744 [summary];

View trigger context for MySQL 5.7.44.

meta trigger-map <TRG> <TRN> 50744 [summary];

View trigger mappings from TRG/TRN evidence.

meta routine|event <MYD> <MYI> <ORIGINAL_DDL> <FRM> <EXACT_VERSION> [summary];

Read routine or event metadata with original schema and version evidence.

meta objects <MYSQL_IBD> <DATABASE> <EXACT_VERSION> [summary];

Read object attributes from an 8.0 dictionary without generating complete CREATE statements.

ds objects <TASK> <DOMAIN> <GENERATION> <SOURCE_ID> <DATABASE> 80028|80046 [summary];

Read object attributes in a DropScan task using confirmed source identity, retaining unknown domains and generations.

Command Reference