Online Training Spring Hibernate Training in Delhi R Programming Training Course Big Data and Hadoop Training Java Training  
 

What is the purpose of the following files having extensions: frm, myd, and myi? What these files contain?

Ads

 
 

Share on Google+Share on Google+

brijesh
What is the purpose of the following files having extensions: frm, myd, and myi? What these files contain?
1 Answer(s)      6 years and 9 months ago
Posted in : PHP

What is the purpose of the following files having extensions: frm, myd, and myi? What these files contain?

Ads
View Answers

November 15, 2010 at 12:24 PM


Hi all,

In MySql, the default table type is MyISAM.

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.

Thanks


Ads