Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa PHP What is the purpose of the following files having extensions: frm, myd, and myi? What these files contain?
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


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


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


Advertisement
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



Related Tutorials/Questions & Answers:
Advertisements
 

 

 

DMCA.com