Bug #14960 Symbolic links do not work on Windows
Submitted: 15 Nov 2005 21:02 Modified: 21 Dec 2005 18:13
Reporter: Mark Leith Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.15-GA OS:Microsoft Windows (Windows)
Assigned to: Kent Boortz CPU Architecture:Any

[15 Nov 2005 21: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 21: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 2: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 15: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 8: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 18: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.