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

AW: AW: creating databases in different folders

2009-06-02 Thread Benedikt Schackenberg
etreff: RE: AW: creating databases in different folders > > >>-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 >

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: AW: creating databases in different folders

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

RE: AW: AW: creating databases in different folders

2009-06-02 Thread Martin Gainty
leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. > From: schackenb...@termindoc.de > To: jhfoo...@extracktor.com > CC: mysql@lists.mysql.com > Subject: AW: AW: creating databases in different folders > Date: Tue, 2 Jun 2009 12:15:31 +02

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

AW: AW: creating databases in different folders

2009-06-02 Thread Benedikt Schackenberg
: 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

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

AW: creating databases in different folders

2009-06-02 Thread Benedikt Schackenberg
You can configure it in the my.cnf file: there you can set the data directory. -Ursprüngliche Nachricht- Von: Foo JH [mailto:jhfoo...@extracktor.com] Gesendet: Dienstag, 2. Juni 2009 05:00 An: mysql@lists.mysql.com Betreff: creating databases in different folders Hi all, I'm using My