1.

What Is The Purpose Of The Following Files Having Extensions: Frm, Myd, And Myi? What These Files Contain?

Answer»

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.

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.


Discussion

No Comment Found

Related InterviewSolutions