WAMP的MySQL数据库文件驻留在哪里? [英] Where do the MySQL database files reside for WAMP?

问题描述

当我开始学习PHP和MySQL时，对于数据库和MySQL其他文件在硬盘上的位置，我感到很好奇.我已经在Windows XP SP2平台上安装了WAMP.

I'm just curious as I am beginning to learn PHP and MySQL, as to where the database and other files of MySQL reside on the hard drive. I have installed WAMP on a Windows XP SP2 platform.

推荐答案

通常位于WAMP安装的/mysql/data目录中.您会识别出该位置，因为每个数据库都有一个同名的文件夹.

Usually in the /mysql/data directory of your WAMP installation. You'll recognize the location because every database has a folder with the same name there.

您可以使用my.cnf中的datadir设置更改数据目录的位置.通常将其移动到其他地方以确保定期备份那里的数据.

You can change the location of the data directory using the datadir setting in my.cnf. It is often moved elsewhere to ensure the data there gets backed up regularly.

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