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.

phpbb_posts.MYD

MySQL 5.5 • MyISAM • dynamic • 48,912 rows • 62 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 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

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.

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