inno export

Export record-level data from a tablespace.

Usage

# CSV export (default)
inno export -f users.ibd

# JSON export
inno export -f users.ibd --format json

# Hex dump
inno export -f users.ibd --format hex

# Export specific page
inno export -f users.ibd -p 3

# Include delete-marked records only
inno export -f users.ibd --where-delete-mark

# Include system columns
inno export -f users.ibd --system-columns

Options

OptionDescription
-f, --filePath to InnoDB data file
-p, --pageExport records from a specific page only
--formatOutput format: csv, json, or hex (default: csv)
--where-delete-markInclude only delete-marked records
--system-columnsInclude DB_TRX_ID and DB_ROLL_PTR columns
-v, --verboseShow additional details
--page-sizeOverride page size
--keyringPath to MySQL keyring file

Supported Types

See the Data Type Decoding guide for the full list of supported column types and encoding details.