Benedikt Schackenberg wrote:
You can configure it in the my.cnf file: there you can set the data
directory.
Thanks for the quick reply.
My concern is that setting the data directory puts ALL databases in that
folder. What I plan to do is to put databases in separate folders.
Is that possible?
John Daisley wrote:
MySQL represents each database by means of a database directory located
within the data directory. You can move a database directory to a location
outside the datadirectory and replace it with a symlink.
Thanks for the tip John, esp. the detailed steps to take. It sounds
were to use Innodb, there is NO way to separate the files used
by different databases?
Benedikt Schackenberg wrote:
I think, that will not work with one database daemon. Then you have to
install for every database one daemon ;)
-Ursprüngliche Nachricht-
Von: Foo JH [mailto:jhfoo
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