搜索关键字：

• mysql .frm .myi .myd
• mysql .frm .myi .myd percona

参考内容：

• .frm 保存的是表的结构
• .MYD 保存的是表的数据记录
• .MYI 保存的是表的索引

=

• .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

Engines Specific:

Innodb:

Innodb has only .frm files and it has its own tablespace where it contains indexes and datas and its shared in databases.

MyISAM:

MyIsam has all the three files. where .myi has your indexes, .myd has your table datas and .frm has its table definition.

==

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.

==

参考链接：

• http://stackoverflow.com/questions/879176/how-to-recover-mysql-db-from-myd-myi-frm-files
• http://www.mindfiresolutions.com/Physical-Mysql–what-are-these-FRM-MYI-MYD-Need-this-1587.php
• http://dba.stackexchange.com/questions/30505/why-does-mysql-produce-so-many-temporary-myd-files
• =
• https://dev.mysql.com/doc/internals/en/frm-file-format.html
• http://dev.mysql.com/doc/refman/5.1/en/backup-methods.html
• http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html
• =
• http://blog.rootsmith.ca/linux/mysql-data-files-myd-myi-and-frm/
• =
• http://bytes.com/topic/mysql/answers/883099-how-restore-mysql-table-using-myd-myi-frm-files
• http://network.convergenceservices.in/forum/20-mysql/1686-restore-a-mysql-database-from-frm-myd-and-myi-files.html
• https://www.percona.com/blog/2008/12/17/recovering-create-table-statement-from-frm-file/
• =
• 通过拷贝frm myd myi opt文件来实现mysql的备份和还原
• http://database.51cto.com/art/201108/281396.htm
• =
• http://serverfault.com/questions/367255/linux-mysql-is-it-safe-to-copy-mysql-db-files-with-cp-command-from-one-db-to