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

[ishan]

this sonds like somthing not supported by MySQL, if u want some thing like this u can use SQLite