creating databases in different folders

[Foo JH]

Hi all,

I'm using MySQL 5.0 on Windows 2003.

Problem background: We use the same server for different applications.
All the applications share the same server as the database server. Each
application uses their own database. In MSSQL we put each database in
the corresponding application folder so that the application root folder
contains everything (including the database).

Now we're trying to do the same for MySQL as well, but I'm not sure how
I can specify that a database should be created in a particular
directory (and it's almost always not in C:\Program Files\MySQL Server).

Can anyone advise? Thanks.