Please explain .frm .myd .myi in mysql?
Monday, November 2, 2009 17:49Posted in category MySql Interview Questions
No Comments
Each MyISAM table is stored on disk in three files. The files have names that begin with the table name and have an extension to indicate the
file type.
- The ‘.frm’ file stores the table definition.
- The data file has a ‘.MYD’ (MYData) extension.
- The index file has a ‘.MYI’ (MYIndex) extension.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
