Follow Me:

Friday 28 February 2014

What is .frm, .myi, .myd. txt file in PhpMyadmin and MySQl?

When creating the table in database,that time 3 text file is generated in local.That files are 
 .FRM  =>  It has the table structure of your table or table definition

 .MYI  =>   It has the indexes of your table

 .MYD =>   It contains your data

Generally you can find the data directory of your file with your .my.cnf file. The physical structure of db is some thing like a directory structure, where each database is a subdirectory under the main directory and has some files in it. Each table has its own file. Bascially one can see three types of files .frm, .myi, .myd.. But they are not same for all tables and db. They differ based on the engines you use and sometimes even differ with the os. There are lots of other factors that is in the backend behind the type of files you see. We will  see some basic differences.

For ex: if your db name is school and tables called class and student. The Physical structure will have a directory called school and files class.frm, class.myi, class.myd, student.frm, student.myi, student.myd.

Categories: ,

1 comment:


  1. Thanks for posting this useful content, Good to know about new things here, Let me share this, . linux training in pune

    ReplyDelete