Bug #14960 Symbolic links do not work on Windows
Submitted: 15 Nov 2005 22:02 Modified: 21 Dec 2005 19:13
Reporter: Mark Leith
Status: Closed
Category:Server Severity:S2 (Serious)
Version:5.0.15-GA OS:Microsoft Windows (Windows)
Assigned to: Kent Boortz Target Version:

[15 Nov 2005 22:02] Mark Leith 
Description:
Using symbolic link files as documented within the manual on Windows does not work. Once
the .sym file, even with a server restart, you can not USE the database or CREATE a table
within the database.

Various naming conventions have been tried such as:

C:\mydata\
C:\\mydata\\
C:/mydata/

How to repeat:
Create a directory under C:\ called "mydata"

Create a .sym file called "mydata.sym" within your C:\Program Files\MySQL\MySQL Server
5.0\data directory. Within this file paste:

C:\mydata\

Save the file, restart MySQL and then issue:

"SHOW DATABASES;"
 or 
"CREATE TABLE mydata.t1 (i INT);"
[15 Nov 2005 22:06] Mark Leith 
Note that the max version of the server (mysqld-nt-max.exe) should be used when trying to
use sym link files, however they do not work with mysqld-nt-max either.
[22 Nov 2005 3:32] Dave Pullin 
This is the same bug as http://bugs.mysql.com/14310

(but I like this one better as it a higher severity! This problem is killing my migration
to V5 ... any chance of a fix soon?)
[8 Dec 2005 16:14] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/33173
[11 Dec 2005 9:03] Kent Boortz 
Correction will be in released 4.1.17 and 5.0.17.
This was a revert of a faulty change.
[21 Dec 2005 19:13] Jon Stephens 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Documented bugfix in 4.1.17 and 5.0.17 changelogs. Closed.