How to setup symbolic links to networked drives in XP

[ozarks]

I want to setup a database symbolic link within Windows XP to a
network drive which has significanlty more space available and can't
seem to get it working. Here is my setup....

- I am running MySQL 4.1.7

- I have tried this with both the 'mysqld-max' and 'mysqld-max-nt'
servers

- Per the MySQL manual (section 7.6.1.3) I setup a 'foo.sym' file in
the C:\MySQL\data directory which references the "linked" database
direcotry.

- If I setup the .sym file to reference another disk local to the
machine (e.g. D:\ running the server it works fine.

- If I setup the .sym file to reference to a networked drive it does
not work.

I have tried referencing the networked drive by the mapped drive
designator ("Z:\"), by remote machine name ("\\remote_host\"), and by
IP address. Has anyone set this up? Is there something I am missing?

Thanks!

[2metre]

ozarks wrote:

I want to setup a database symbolic link within Windows XP to a
network drive which has significanlty more space available and can't
seem to get it working. Here is my setup....

- I am running MySQL 4.1.7

- I have tried this with both the 'mysqld-max' and 'mysqld-max-nt'
servers

- Per the MySQL manual (section 7.6.1.3) I setup a 'foo.sym' file in
the C:\MySQL\data directory which references the "linked" database
direcotry.

- If I setup the .sym file to reference another disk local to the
machine (e.g. D:\ running the server it works fine.

- If I setup the .sym file to reference to a networked drive it does
not work.

I have tried referencing the networked drive by the mapped drive
designator ("Z:\"), by remote machine name ("\\remote_host\"), and by
IP address. Has anyone set this up? Is there something I am missing?

Thanks!

I'm not good on Windows networks or MySQL on Windows, but this sounds
like it might be a permissions problem. ie You have connected to the
remote drive under your user account, but MySQL runs as a service.

Just a quick hunch, so, please, no-one shoot me if I'm nowhere near the
ballpark!

[steve]

"johnomorris" wrote:

I want to setup a database symbolic link within Windows XP to a
network drive which has significanlty more space available and
can’t
seem to get it working. Here is my setup....

- I am running MySQL 4.1.7

- I have tried this with both the ’mysqld-max’ and
’mysqld-max-nt’
servers

- Per the MySQL manual (section 7.6.1.3) I setup a
’foo.sym’ file in
the C:\MySQL\data directory which references the "linked" database direcotry.

- If I setup the .sym file to reference another disk local to the
machine (e.g. D:\ running the server it works fine.

- If I setup the .sym file to reference to a networked drive it does not work.

I have tried referencing the networked drive by the mapped drive
designator ("Z:\"), by remote machine name ("\remote_host\"), and by IP address. Has anyone set this up? Is there something I am missing?
Thanks!

Hate to disappoint you, but from everything I have read, this is not
possible in Windows (although mysql docs say it is). I could be proven
wrong...

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-setup-...ict166585.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=560126

[ozarks]

jo*********@adelphia.net (ozarks) wrote in message news:<cb**************************@posting.google. com>...

I want to setup a database symbolic link within Windows XP to a
network drive which has significanlty more space available and can't
seem to get it working. Here is my setup....

- I am running MySQL 4.1.7

- I have tried this with both the 'mysqld-max' and 'mysqld-max-nt'
servers

- Per the MySQL manual (section 7.6.1.3) I setup a 'foo.sym' file in
the C:\MySQL\data directory which references the "linked" database
direcotry.

- If I setup the .sym file to reference another disk local to the
machine (e.g. D:\ running the server it works fine.

- If I setup the .sym file to reference to a networked drive it does
not work.

I have tried referencing the networked drive by the mapped drive
designator ("Z:\"), by remote machine name ("\\remote_host\"), and by
IP address. Has anyone set this up? Is there something I am missing?

Thanks!

I corrected this problem by going into the service properties and
instead of using the "Local System account" I used a domain login that
had read/write on the remote machine with the dirve I was networking.
I have this working with the mysqld-nt server.