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

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

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

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:
What is the purpose of the following files having extensions: frm, myd, and myi? What these files contain?
extensions: frm, myd, and myi.
Advertisements
what are the codes for uploading and downloading files in and from database?
What is an Abstract Class and what is it's purpose?
What is the purpose of org.hibernate.SessionFactory?
What is the purpose of data science ?
what's the purpose of constructor in abstract class?
What is the purpose of declaring a variable as final?
files
files
What are the concepts and purpose of Spring configuration file.
What is the purpose of garbage collection in Java, and when is it used?
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
what are the jar files should i add to resolve the Exception(Class org.apache.jsp.index_jsp Not Found) ?
How to delete a directory which is having some files already.
How to create a new text file that contains the file names of the copied files in a new directory? - Java Beginners
Files
files
files
files
files
files
header files
Uploading files
validation files
Text Files
ModuleNotFoundError: No module named 'myio'
JSP View Files
Struts 2 configuration files
delete retailer jsp file (sir..is this a good logic.. jsp file is useful for what purpose)
ModuleNotFoundError: No module named 'myip'
ModuleNotFoundError: No module named 'myip'
Afae - An All-purpose Editor for Eclipse
Copy Files - Java Beginners
configuration files are used in Struts
Java files - Java Beginners
What is SDK?
What is NVL?
library files - Development process
configuration files - Java Beginners
Reading files in Java
What is normalization?
ModuleNotFoundError: No module named 'files'
What is XAMPP?
Dynamic include of multiple files
files uploding and downloading codes
List files recursively in linux
getting files from VSS
Mutliple files upload
invoking exe files on sound

Ads