Where are mysql documents stored?

Mysql documents are stored in the data folder under the mysql installation directory. You can view it by executing the [show global variables like "�tadir%"] command.

If MySQL uses the MyISAM storage engine, the database file types include .frm, .MYD, and .MYI. The default storage location is C:\Documentsand Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data.

(Recommended tutorial: mysql video tutorial)

If MySQL uses the InnoDB storage engine, the database file types include .frm, ibdata1, and .ibd, and there are two storage locations indivual. The default storage location of .frm files is C:\Documents and Settings\All Users\ApplicationData\MySQL\MySQL Server 5.1\data, and the default storage location of ibdata1 and .ibd files is the data folder in the MySQL installation directory.

You can view it by executing the following command:

mysql> show global variables like "%datadir%" ;

##Related recommendations:

php training

The above is the detailed content of Where are mysql documents stored?. For more information, please follow other related articles on the PHP Chinese website!