Although the physical location of a MySQL physical data location could be found in a my.ini file (In my case, it is located at
C:\Program Files\MySQL\MySQL Server 5.1
But without having to refer to the my.ini file, you can still find out the physical location of the data file by running the following short SQL.
?1 SELECT @@datadir;
If you would still prefer to refer to my.ini file, the following is a typical my.ini file from my system. The path to the physical location of database is defined in this file as:
datadir=”C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/”
