The location of the mysql file varies depending on the storage engine; if the MyISAM storage engine is used, the default storage location is "MySQL Server 5.1\data"; if the InnoDB storage engine is used, the data is stored in the MySQL installation directory. folder.
Recommendation: "mysql video tutorial"
In which directory are the mysql database files located?
1. If MySQL uses the MyISAM storage engine, the database file types include .frm, .MYD, and .MYI. The default storage location is C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data
2. If MySQL uses the InnoDB storage engine, the MySQL database file types include .frm, ibdata1, and .ibd. There are two storage locations. The
.frm file is the default storage location. It is C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data. The default storage location of ibdata1 and .ibd files is the data folder in the MySQL installation directory
The above is the detailed content of In which folder are the mysql files located?. For more information, please follow other related articles on the PHP Chinese website!