Open IBD files in your browser

A MySQL or MariaDB table's own file, its rows kept in InnoDB's pages. Open a database's folder right here as a folder of its tables, without a running server or a restore. Nothing leaves your device.

Or drop it anywhere on this page

What you'll see

Your database opens as a folder in the file list, its tables and views with their rows counted, and each table you pick opens in the grid.

wp_posts.ibd

MySQL 8.0 • InnoDB • DYNAMIC • 18,240 rows • 96 MB

  • Every table and view in a folder • Rows counted
  • Keys lead to the rows they point at
  • Search • Every table at once
  • Export • Save a table or the whole database

About IBD

MySQL and MariaDB keep each database as a folder in their data directory, and each InnoDB table in a file of its own, an .ibd, the default since MySQL 5.6. Up to MySQL 5.7, and in every MariaDB, the table's columns are in an .frm beside it, while MySQL 8 keeps them inside the .ibd itself. WordPress, Magento, Drupal, Nextcloud and most PHP apps keep their data this way.

Inside, an .ibd is pages of 16 KB: the rows on the leaves of a B-tree in the order of the primary key, long values on pages of their own, in the row format DYNAMIC, COMPACT or REDUNDANT. A column added or dropped in place by ALTER TABLE leaves rows of more than one shape, which InnoDB tells apart row by row.

Filepeek reads the pages itself in your browser and opens the database's folder as its tables, each in a grid to sort, filter and search, with keys leading to the rows they point at. Every column reads as MySQL prints it, JSON and columns changed in place too, and Export saves a table or the whole database as a SQLite file, a SQL dump or one Excel workbook. Tables in ROW_FORMAT=COMPRESSED or encrypted with the server's key aren't read.

InnoDB table

Format

MIME type
application/octet-stream
Made by
MySQL and MariaDB, for InnoDB tables
Released
2003

Inside the file

Pages
16 KB each
Rows
On a B-tree's leaves
Row formats
DYNAMIC, COMPACT, REDUNDANT
Columns
In the .frm, or inside from MySQL 8

Opens in every browser

Filepeek opens IBD files in Chrome, Edge, Firefox and Safari. On their own, browsers only download them, and only a MySQL or MariaDB server reads them.

  • YouChromeOpens through Filepeek
  • YouEdgeOpens through Filepeek
  • YouFirefoxOpens through Filepeek
  • YouSafariOpens through Filepeek

Apps that open IBD

  • WindowsMySQL or MariaDB, with the folder in its data directory
  • MacMySQL or MariaDB from Homebrew, with the folder in its data directory
  • iPhone and iPadNo app opens it
  • AndroidNo app opens it

Questions

How do I open an IBD file without MySQL?

Drop its database's folder on this page, or the .ibd with its .frm, or choose Peek an IBD. Its tables show as a folder in the file list, each with its rows counted, and the one you pick opens as a grid, on any computer or phone.

Do I need the .frm file?

From MySQL 8 on, an .ibd carries its own columns and opens alone. MariaDB's and older MySQL's keep them in the .frm of the same name, so drop the two together, or the whole folder.

Can I get my data back from a data folder?

Yes, when the server won't start or no dump was made, the folder's files still hold the rows. Copy the database's folder from the data directory, like /var/lib/mysql/shop, with the server stopped, and drop it here. Export then saves it as a SQL dump or a SQLite database.

Can I get my data out as Excel or CSV?

Yes. Export saves the table on show as CSV, Excel, JSON or Parquet, and every table at once as a ZIP of CSVs, one Excel workbook with a sheet for each table, a SQLite database or a SQL dump.

Why doesn't a table show its rows?

A table in ROW_FORMAT=COMPRESSED, or encrypted with the server's keyring, can't be read without the server, and a MyISAM table's rows are in its .MYD and .MYI. The database's details name each table that wasn't read and why.

What about ibdata1?

ibdata1 is InnoDB's shared system tablespace, with its undo logs and, on servers set up without a file per table, every table's rows. Filepeek reads the tables in their own .ibd files.

More data formats

All supported file types

Tell us what happened

Where the file came from helps us most

With itNever the file or its name
Thank you

Opens in a new tab

Keys

Everywhere

EXIF

Verify

License

Signature