更新时间:2023-10-22 19:15:04
您可以检查my.ini
文件以查看数据文件夹的位置.
You can check my.ini
file to see where the data folder is located.
通常有一个文件夹{mysqlDirectory}/data
Usually there is a folder {mysqlDirectory}/data
MySQL数据存储:
MySQL data storage:
Commands.frm
Commands.myd
Commands.myi
*.frm文件包含表定义.您的* .myi文件是MyISAM索引文件.您的* .myd文件包含表数据.
The *.frm files contain the table definitions. Your *.myi files are MyISAM index files. Your *.myd files contain the table data.
编辑/更新. 由于问题中显示的兴趣,此处提供了更多信息,该信息也可以在评论中找到.
Edit/Update. Because of the interest shown in the question here is more info which is found also in the comments.
在Windows 8.1中,默认情况下,MySQL数据库存储在以下位置:C:\ProgramData\MySQL\MySQL Server 5.6\data
In Windows 8.1, the MySQL databases are stored (by default) here: C:\ProgramData\MySQL\MySQL Server 5.6\data
文件夹C:\ ProgramData是一个隐藏文件夹,因此必须将其键入Windows资源管理器地址才能到达.在该数据文件夹中,数据库被命名为/{database_name_folder}/{database_tables_and_files}
.
The folder C:\ProgramData is a hidden folder, so you must type it into Windows Explorer address to get there. In that data folder, the databases are named /{database_name_folder}/{database_tables_and_files}
.
例如
C:\ProgramData\MySQL\MySQL Server 5.6\data\mydatabase\mytable.frm
C:\ProgramData\MySQL\MySQL Server 5.6\data\mydatabase\mytable.ibd
感谢@ marty-mcgee此内容
Thank @marty-mcgee for this content