在哪里可以找到MySQL数据库文件 [英] Where to find MySQL Database file

问题描述

我已经安装了wamp服务器.我正在使用Web应用程序并使用MySQL数据库.我想知道我的数据库文件在wamp文件夹中的位置.我的意思是MS Access具有.mdb文件，SQL Server具有.mdf文件，类似地，我想知道哪个是mySQL文件，其中存储了我的数据以及可以在哪里找到它，以便保留其备份.

I have installed the wamp server. I am working on a web application and using the MySQL database. I want to know that where my database file resides in the wamp folder. I mean MS Access has .mdb file, SQL Server has .mdf file, similarly I want to know that Which is mySQL file in which my data is being stored and where I can found it, so that I can keep its backup.

推荐答案

MySQL的文件格式为 .frm

MySQL has a file format of .frm

MySQL数据库文件的存储目录为在MySQL配置文件my.cnf或my.ini中定义.实际的文件名和后缀取决于哪个存储引擎 [ ^ ].当数据库服务器停止时，您应该备份整个MySQL数据目录，或者使用mysqldump程序创建数据库的快照.参见: http://dev.mysql.com/doc/refman/5.5/zh_cn/backup-and-recovery.html [ ^ ]

The directory where MySQL database files are stored is defined in the MySQL configuration file my.cnf or my.ini. The actual file names and suffixes depend on which storage engines[^] you are using. You should backup the whole MySQL data directory when the database server is stopped, or use the mysqldump program to create a snaphot of the database. See: http://dev.mysql.com/doc/refman/5.5/en/backup-and-recovery.html[^]

这篇关于在哪里可以找到MySQL数据库文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！