>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...@extracktor.com] > Gesendet: Dienstag, 2. Juni 2009 11:49 > An: schackenb...@termindoc.de > Cc: mysql@lists.mysql.com > 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? > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
