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
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.