RE: AW: creating databases in different folders

2009-06-02 Thread Jerry Schwartz
>> [JS] So far as I know, Windows supports mount points but not symbolic >> links. > >You are correct Jerry, Windows does not support symbolic links but for >MySQL purposes you can create an .sym file containing the full path to >the >new location and MySQL will read the file and look in the specif

RE: AW: creating databases in different folders

2009-06-02 Thread John Daisley
> > >>-Original Message- >>From: John Daisley [mailto:john.dais...@mypostoffice.co.uk] >>Sent: Tuesday, June 02, 2009 6:30 AM >>To: Foo JH >>Cc: schackenb...@termindoc.de; mysql@lists.mysql.com >>Subject: Re: AW: creating databases in different f

RE: AW: creating databases in different folders

2009-06-02 Thread Jerry Schwartz
>-Original Message- >From: John Daisley [mailto:john.dais...@mypostoffice.co.uk] >Sent: Tuesday, June 02, 2009 6:30 AM >To: Foo JH >Cc: schackenb...@termindoc.de; mysql@lists.mysql.com >Subject: Re: AW: creating databases in different folders > >MySQL represents e

Re: AW: creating databases in different folders

2009-06-02 Thread Foo JH
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 s

Re: AW: creating databases in different folders

2009-06-02 Thread John Daisley
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. Moving a database directory is very simple. Just follow these steps. (I think you said you wer

Re: AW: creating databases in different folders

2009-06-02 Thread Martijn Tonies
Hi, 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 po

Re: AW: creating databases in different folders

2009-06-02 Thread Foo JH
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