Data documentation for MySQL database

In the MySQL database, the configuration document my.ini is stored by default in C:/Program Files/mysql/mysql Server 5.5, open the configuration document to find the following lines of information

#Path to installation directory. All paths is usually resolved relative to this.
Basedir= "C:/Program files/mysql/mysql Server 5.5/" #数据库的安装路径

#Path to the database root
Datadir= "C:/programdata/mysql/mysql Server 5.5/data/" #数据库数据文档的路径

There are two kinds of storage engines in MySQL

If you use the MyISAM storage engine, the database file type includes. frm,. MYD,. MYI

If you use the InnoDB storage engine, the database file type includes. frm, ibdata1,. IBD, storage location two, ibdata1,. ibd File default location is the Data folder in the MySQL installation directory.

MyISAM

　　. FTM stores the frame structure of the data table, with each table corresponding to a frm file with the same name.

. MYD Table Data File

. MYI Table Index File

. log log file

InnoDB

. frm ibid.

Ibdata1,ibdata2 ... A system space file that stores InnoDB system information and user database table data and indexes.