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

2009-06-02 Thread Walter Heck - OlinData.com
You might try and hack something together using NTFS juction points. Unadvisable though, and probably unsupported. Walter On Mon, Jun 1, 2009 at 9:00 PM, Foo JH wrote: > Hi all, > > I'm using MySQL 5.0 on Windows 2003. > > Problem background: We use the same server for different applications. >

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

creating databases in different folders

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