Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to look at the storage path of mysql documents, which is very detailed and has a certain reference value. Interested friends must finish reading it!

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

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

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

You can view it by executing the following command:

Mysql > show global variables like "datadir%"

The above is all the content of how to look at the storage path of mysql documents, thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.