Re: AW: AW: creating databases in different folders

[Foo JH]

From the sound of things, apart from using symbolic links, all MySQL
databases MUST reside within the same data root folder.

Some further questions:
1. On the *NIX, *BSD platform, do you guys locate the databases in diff
folders and link it back to the data root on production systems?

2. If I 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-ml@stripped] 
> Gesendet: Dienstag, 2. Juni 2009 11:49
> An: schackenberg@stripped
> Cc: mysql@stripped
> Betreff: Re: AW: creating databases in different folders
> 
> 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?
>