Home »

What is the purpose of the following files having extensions 1) .frm2) .myd 3) .myi? What do these files contain?

Question List › Category: PHP › What is the purpose of the following files having extensions 1) .frm2) .myd 3) .myi? What do these files contain?
0 Vote Up Vote Down
ethanbrown author asked 10 years ago
1 Answers
0 Vote Up Vote Down
shah_kajal184 author answered 8 years ago

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.

Please login or Register to Submit Answer