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.
- 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
.ibd
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.