top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is the Purpose of files with extension 1) .frm 2) .myd 3) .myi in MySQL and what do these files contain?

+1 vote
365 views
What is the Purpose of files with extension 1) .frm 2) .myd 3) .myi in MySQL and what do these files contain?
posted May 9, 2014 by Karamjeet Singh

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

In MySQL, the default 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.
1. The ".frm" file stores the table definition. 2. The data file has a ".MYD(MYData)" extension. 3. The index file has a ".MYI(MYIndex)" extension.

answer May 12, 2014 by Mohit Sharma
Similar Questions
+1 vote
where do mysql bugs go, these days?

So, I've been tearing apart mysql-connector-odbc-5.1.11-1.fc18.x86_64 And I've tracked down some horrible breakage there that needs to be fixed upstream.

Given the state of mysql in the distro, and the pending move to mariadb, I'm wondering where the best place to report this bug would be. I find nothing but Oracle's bureaucratease, when I try to dig around mysql.com.

+1 vote
MySQL: data in the database without encrypt but I am view the data encrypt method after 1 day

I have some problem
I have store the data in the database without encrypt but i am view the data encrypt method after 1 day and doesn't know the details.

I am using php and mysql, Could the experts please comment on this, and offer some advice?

0 votes
open files in mysqld 5.1.53

I am trying to understand the incredible use of filepointers in our mysql server (5.1.53). under normal condition the server reports 10k-15k open files pointer. I run a 'flush tables' every 2h to avoid problems, the number of users/connections is constant
It is an automatic system but a few human users, a happy mix of myisam and innodb tables running
with no problems on mysqld 5.0 . But now sometimes i am hit with an insane increase hitting the ceiling at 60k. I do not like the idea to increase the limit further because i do not understand why this is happening (I seems to happen at random times).

I am running out of idea what my cause the unexpected increase, any idea what to watch ?

+2 votes
How I can get started working with PHP/MySQL inside of the WordPress app?

I have moderate level PHP programming skills. I am also interested in merging those skills inside of the WordPress app. With their advanced responsive design themes and many other functions it seems like a good idea. I have tried loading some PHP plug-ins in WP – but I don't seem to get them to do more than basics.

Can anybody help me on how I can get started working with PHP/MySQL inside of the WordPress app?

...