AW: creating databases in different folders

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

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?

Re: AW: creating databases in different folders

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

AW: AW: creating databases in different folders

: 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

Re: AW: creating databases in different folders

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

Re: AW: creating databases in different folders

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

RE: AW: AW: creating databases in different folders

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 +0200 I think

Re: AW: AW: creating databases in different folders

...@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

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 Subject: Re: AW: creating databases in different folders MySQL represents each database by means

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 Subject: Re: AW: creating databases in different folders MySQL represents each database by means

AW: AW: creating databases in different folders

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

RE: AW: creating databases in different folders

[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 specified path