Home  >  Article  >  Database  >  In which folder are the mysql files located?

In which folder are the mysql files located?

藏色散人
藏色散人Original
2020-11-03 09:25:2912559browse

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.

In which folder are the mysql files located?

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn