Mar 202009
A MySQL database creates a number of different data files in the mysql data directory (typically /var/lib/mysql). The following are the differences between the data files created:
| File Extension | Purpose |
|---|---|
| .frm | table definition |
| .MYD | table data |
| .MYI | table indices |
I believe these files are created for both MyISAM and InnoDB table types because the MySQL documentation references these types with respect to MyISAM and I definitely see them on my InnoDB tables.
I couldn’t find this information directly in the MySQL documentation and google wasn’t much help either so hopefully this post will save someone else some search effort.
>hopefully this post will save someone else some search effort.
It did, thanks for your definition !
Thanks for your post. It did help me.
Thanks from me, as well … answered this MySQL newbie’s questions right away …
Thanks from another satisfied reader
Thanks, I was looking for this info too.
As database is created , one folder is created mapping with database name.
As you create tables in it for each table these three files are created
.frm:- table definition
.MYD:-table data
.MYI:-table indices
if you copy that folder from wamp\mysql\data\(database name folder) to your pc.
and then delete that database from console,, after that put again (database name folder) to wamp\mysql\data\ that path,,,,it recovers the all table structure with table data…
Thanks a lot for the information.
Thx
..
Very useful information. Could we recover .MYD or .MYI files, if these files had been missed?
Thanks A lot Dude…….This article helped me a lot.
For INNODB, only 1 file of type .frm will be created. For MyISAM all the above 3 files will be created. Incase of INNODB, .frm file holds data and indexes.
i have an also a whichs disks is full so how can i move these .myd and .myi files from disk and database safely?
Thanks dude.
Thanks. It helped.