MySQL数据库文件实际驻留在哪里? [英] Where do the MySQL database files actually reside
本文介绍了MySQL数据库文件实际驻留在哪里?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
/ mysql / data
目录下。 。您可以识别位置,因为每个数据库都有一个同名的文件夹。 您可以使用来更改数据目录的位置, datadir
设置在 my.cnf
中。它经常移动到其他地方,以确保数据定期备份。
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.
解决方案
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.
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.
这篇关于MySQL数据库文件实际驻留在哪里?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文