Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

What do you think of the storage path of mysql documents

2025-04-03 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report