In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.