>> [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
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
>
>
>
>>-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
>-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
> 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
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
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
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.
>
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
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
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
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
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
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
ald_clark" <[EMAIL PROTECTED]>
To: "Edgar Powell" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, November 24, 2003 9:48 AM
Subject: Re: Problems creating databases
> End your commands with a semicolon.
>
> Edgar Powell wrote:
>
> >Hi
End your commands with a semicolon.
Edgar Powell wrote:
Hi All,
When I type a command after the mysql prompt nothing happens and no error. For example:
mysql> CREATE DATABASE members
> SHOW DATABASES
>
What do you think is the problem.
This is an apache web server.
The OS is Redha
> When I type a command after the mysql prompt nothing happens and no
> error. For example:
> mysql> CREATE DATABASE members
> > SHOW DATABASES
> What do you think is the problem.
> This is an apache web server.
> The OS is Redhat
This is just a shot in the dark, but there are no semi-col
Hi All,
When I type a command after the mysql prompt nothing happens and no error. For example:
mysql> CREATE DATABASE members
> SHOW DATABASES
>
What do you think is the problem.
This is an apache web server.
The OS is Redhat
Edgar
ginal Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 09, 2002 9:23 AM
To: [EMAIL PROTECTED]
Subject: Re: NEWBIE - trouble creating Databases Acess Denied...
David,
Tuesday, July 09, 2002, 12:04:52 AM, you wrote:
DK> I keep getting Access Denied Errors wh
David,
Tuesday, July 09, 2002, 12:04:52 AM, you wrote:
DK> I keep getting Access Denied Errors when I try to login to MySql after
DK> running mysql_install_db script. I ran the mysql_install_db script, made
DK> suer the mysql process is running(checked it using netstat -a), changed the
DK> owner
-
From: "David Kramer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 09, 2002 12:04 AM
Subject: NEWBIE - trouble creating Databases Acess Denied...
> I keep getting Access Denied Errors when I try to login to MySql after
> running mysql_i
I keep getting Access Denied Errors when I try to login to MySql after
running mysql_install_db script. I ran the mysql_install_db script, made
suer the mysql process is running(checked it using netstat -a), changed the
ownership on the binaries and then tried to gain access using the command:
my
I guess thats a no. I wasn't sure if it was hidden in some other
documentation file. Is there a page that details things that can be
done in MS SQL Server and not mySQL?
Ack, at 9/23/01, Will French said:
>rtfm.
>
>Excerpt from mySQL manual.
--
Sincerely,
Rosyna Keller
Technical Support/Holy
ilto:[EMAIL PROTECTED]]
> Sent: Sunday, September 23, 2001 8:55 PM
> To: [EMAIL PROTECTED]
> Subject: Creating Databases
>
>
> Does mySQL not support this syntax?
>
> CREATE DATABASE newDB ON
> (
> NAME = 'newDB',
> FILENAME = '~/newDB.mdf',
> S
Does mySQL not support this syntax?
CREATE DATABASE newDB ON
(
NAME = 'newDB',
FILENAME = '~/newDB.mdf',
SIZE = 10MB,
MAXSIZE = 20MB,
FILEGROWTH = 1MB )
--
Sincerely,
Rosyna Keller
Technical Support/Holy Knight/Always needs a hug
Unsanity: Unsane Tools for Insane People
---
25 matches
Mail list logo
