How to setup symbolic links to networked drives in XP

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • ozarks

    How to setup symbolic links to networked drives in XP

    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

    #2
    Re: How to setup symbolic links to networked drives in XP

    ozarks wrote:[color=blue]
    > 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![/color]
    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!

    Comment

    • steve

      #3
      Re: How to setup symbolic links to networked drives in XP

      "johnomorri s" wrote:[color=blue]
      > 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"[/color]
      database[color=blue]
      > 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[/color]
      does[color=blue]
      > not work.
      >
      > I have tried referencing the networked drive by the mapped drive
      > designator ("Z:\"), by remote machine name[/color]
      ("\remote_host\ "), and by[color=blue]
      > IP address. Has anyone set this up? Is there something I am[/color]
      missing?[color=blue]
      >
      > Thanks![/color]

      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

      Comment

      • ozarks

        #4
        Re: How to setup symbolic links to networked drives in XP

        johnomorris@ade lphia.net (ozarks) wrote in message news:<cb4bf239. 0411020902.2a66 b486@posting.go ogle.com>...[color=blue]
        > 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![/color]

        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.

        Comment

        Working...