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

Where can I see the mysql file? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

The location of mysql files varies depending on the storage engine; if you use the MyISAM storage engine, the default location is "MySQL Server 5.1\ data"; if you use the InnoDB storage engine, it is stored in the data folder under the MySQL installation directory.

Which directory is the database file for mysql in?

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

2. If MySQL uses InnoDB storage engine, MySQL database file types include .frm, ibdata1, .ibd, and there are two storage locations.

The default location for .frm files is C:\ Documents and Settings\ All Users\ Application Data\ MySQL\ MySQL Server 5.1\ data, and the default location for ibdata1 and .ibd files is the data folder under the MySQL installation directory.

Thank you for reading! After reading the above, do you have a general idea of where to read the mysql file? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are 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.