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

I'm not sure, I don't think so.

But why? The database manages everything for you: permissions, structure etc.

I think the only way to do it the way you want to is install MySQL onto EACH drive but, as Chroder says, I cannot see why you would want to do this. With PHP and MySQL, you can install multiple databases on the same drive - I currently have 26 different MySQL databases on my C drive.