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

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

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

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'

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