MySQL MyIASM files what are they for MYI,MYD,frm

One would hope to never need to know this, but an unfortunate soul who is trying to recover MySQL MyISAM tables may need this.


http://forge.mysql.com/wiki/MySQL_Internals_MyISAM

A quote from the above:
'MySQL creates files named Table1.MYD ("MySQL Data"), Table1.MYI ("MySQL Index"), and Table1.frm ("Format")'

Mythtv File Parsing for Metadata

From
http://www.mythtv.org/wiki/MythVideo_File_Parsing

Filenames

• A Movie Title.mpg
• Title s01e01 Subtitle.mpg
• Title 1x01 Subtitle.mpg
• Title Season 1 Episode 1 Subtitle.mpg

Filename/Path combinations

• Title/Season 1/01 Subtitle.mpg
• Title/Season 1/s01e01 Subtitle.mpg
• Title/Season 1/1x01 Subtitle.mpg
• Title/Season 1/Title s01e01 Subtitle.mpg
• Title/Season 1/Title 1x01 Subtitle.mpg
• Title/Season 1/Episode 1 Subtitle.mpg
• Title/Season 1/Season 1 Episode 1 Subtitle.mpg
• Title Season 1/01 Subtitle.mpg
• Title Season 1/s01e01 Subtitle.mpg
• Title Season 1/1x01 Subtitle.mpg
• Title Season 1/Title s01e01 Subtitle.mpg
• Title Season 1/Title 1x01 Subtitle.mpg
• Title Season 1/Episode 1 Subtitle.mpg
• Title Season 1/Season 1 Episode 1 Subtitle.mpg