aeonsleo aeonsleo - 3 years ago 170
MySQL Question

Where do the MySQL database files actually reside

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.

Answer Source

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download