Where do the MySQL database files reside for WAMP?

Question

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 1

Explore variables from the output of following command:

mysql> show variables like '%dir%';

Answer 2

Data directories for mysql database :

Generally,

Windows wamp setup : mysql/data Linux (Ubuntu) : /var/lib/mysql

Configured Location: [ my.cnf configures it as datadir ]

Linux :

$ cat /etc/mysql/my.cnf | grep 'datadir'

Windows :

  Open mysql/my.cnf (search for `datadir` )

From mysql prompt : ( mysql> ) [ PREFERRED WAY ]

  mysql> show variable like 'datadir';

I suppose that covers pretty much all cases.