Bug #33687 Symbolic linked files is not implemented for Vista or Windows Server 2008
Submitted: 4 Jan 2008 11:56 Modified: 25 Mar 2008 6:01
Reporter: Mattias Jonsson
Status: Verified
Category:Server: General Severity:S4 (Feature request)
Version: OS:Microsoft Windows (Vista, Server 2008)
Assigned to: Target Version:
Tags: symbolic files, windows, disabled
Triage: Needs Triage: D5 (Feature request)

[4 Jan 2008 11:56] Mattias Jonsson 
Description:
Microsoft Windows Vista and Server 2008 do support symbolic linked files that is usable
with MyISAM/Archive and Partitioning for DATA/INDEX DIRECTORY, but it is not supported in
mysqld. It does work manually (see Bug#30459). May be related to Bug#28753 - wrong
implementation of symbolic links on window, which are for symbolic linked directories.

This bug was created for separating the feature request from the partitioning bug in
Bug#30459.

How to repeat:
Use DATA DIRECTORY or INDEX DIRECTORY and it will be ignored (tested on Microsoft Windows
Vista Ultimate, [Version 6.0.6000])

SELECT VERSION();
VERSION()
5.1.23-rc-pro-log
SHOW VARIABLES LIKE 'HAVE_SYMLINK';
Variable_name	Value
have_symlink	YES
CREATE TABLE t1 (a INT) ENGINE=MyISAM DATA DIRECTORY="C:/mysqltest/datadir" INDEX
DIRECTORY="C:/mysqltest/indexdir";
Warnings:
Warning	0	DATA DIRECTORY option ignored
Warning	0	INDEX DIRECTORY option ignored

Suggested fix:
Use the CreateSymbolicLink function in the Win32 API:

http://msdn2.microsoft.com/en-us/library/aa363866.aspx
[25 Mar 2008 6:01] Valeriy Kravchuk 
Thank you for a reasonable feature request.
[30 Apr 2008 17:35] Trudy Pelzer 
Bug#19107 is a duplicate of this bug.
[20 Aug 2:16] Adam Dixon 
This also does not work in XP.
[20 Aug 2:39] Mattias Jonsson 
XP's NTFS does not support true symbolic linked files (as on unix), Vista and Server 2008
does.