MySQL database file location

[jeephp]

Hi all
I have a Windows 2003 Server and have installed MySQL 4.3.13-nt on it.
I want to create 3 databases on it called d_one, d_two and d_three etc.

My problem is that I want to use separate folders for each database. Let’s say,
I want to store the database files for d_one at c:\database1 folder, d_two at d:\database2 folder and database d_three at e:\database3 folder.

Is this possible to achieve this? If yes then can I get some guidance on how to go about this.

Thanks
Paresh

[coopster]

MySQL will automatically create a separate folder for each database and on a Windows installation it is typically under the /mysql/data/ directory, where mysql is the directory into which you have your MySQL installation setup.