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