On 4 Jul 2001, at 21:21, Jeremy Zawodny <[EMAIL PROTECTED]>
expounded about "Re: different subdir for database":

> On Thu, Jul 05, 2001 at 12:10:07PM +0800, Jaime Teng wrote:
> > Hi,
> > 
> > I have mysql on NT4 (soon to be win2000). one question is that the
> > database files all reside under drive c. NT does not have symbolic
> > link....
> 
> I seem to recall Microsoft making a big deal out of the fact that they
> "invented" symbolic links and added them to Win2000. Anyone used them
> with MySQL?

The "symbolic links" (called junctions by MS)in Win2k can only be used for 
directories, not for individual files. The other problem is that the 
utility to create them is in the (added cost) resource kit. However you can 
get a feeware utility to create them here:
<http://www.sysinternals.com/ntw2k/source/misc.shtml#junction>

and they do work, so using junctions you can have databases on different 
drives (since each mysql db is located in it's own directory). Simply 
create a target database directory, then create the junction (pointing to 
the target) in your data directory.

-jan
-- --
 Jan M.                                         PGP (See headers)
  
  How you behave towards cats here below
  determines your status in Heaven.
      -- Brian Smith, 'To Sail Beyond the Sunset'
                 (Robert Heinlein)




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to