Open MYD files in your browser
The rows of a MySQL or MariaDB table in the MyISAM engine, beside its .MYI index. Open a table or its database's folder right here, without a server. 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 MYD
MyISAM was MySQL's default engine from 3.23 to 5.5, and each of its tables is three files in its database's folder: the .MYD with its rows, the .MYI with its keys and how its rows are packed, and the .frm with its columns, an .sdi from MySQL 8 on. Old forums, WordPress sites and MySQL's own tables up to 5.7 kept their data this way, and many still do.
Inside, a .MYD holds rows of one length one after another, or packed rows in blocks, a long row's blocks chained and a deleted row's block kept for the next. Its .MYI holds the keys' B-trees and, in its head, how each column is packed.
Filepeek reads the files itself in your browser and opens the table, or the whole folder, in a grid to sort, filter and search, deleted rows left out. Export saves a table or the database as CSV, Excel, a SQLite file or a SQL dump. Tables packed by myisampack aren't read.
MyISAM table
.myd • .myi
Format
- MIME type
- application/octet-stream
- Made by
- MySQL and MariaDB, for MyISAM tables
- Released
- 2000
Inside the file
- Rows
- Fixed or dynamic
- Keys
- In the .MYI
- Columns
- In the .frm or .sdi
- Deleted rows
- Left out
Opens in every browser
Filepeek opens MYD and MYI 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 MYD
- 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 MYD and MYI files?
Drop them on this page with the .frm of the same name, or the .sdi from MySQL 8, or drop the whole database folder. The table opens as a grid, each row as MySQL prints it.
Do I need all three files?
Yes. The .MYD holds the rows, the .MYI says how they're packed, and the .frm or .sdi names the columns.
Why are some rows missing?
A deleted row stays in the .MYD until the table is optimized, its block marked as free, and Filepeek leaves it out as MySQL does.
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.
What about Aria's MAD and MAI files?
Aria, the engine MariaDB uses for its own tables, writes .MAD and .MAI files in a format of its own, which Filepeek doesn't read.