Bug #33687 Symbolic linked files is not implemented for Vista or Windows Server 2008
Submitted: 4 Jan 2008 10:56 Modified: 25 Mar 2008 5:01
Reporter: Mattias Jonsson Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: General Severity:S4 (Feature request)
Version: OS:Microsoft Windows (Vista, Server 2008)
Assigned to: CPU Architecture:Any
Tags: disabled, symbolic files, windows
Triage: Needs Triage: D5 (Feature request)

[4 Jan 2008 10: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 5:01] Valeriy Kravchuk
Thank you for a reasonable feature request.
[30 Apr 2008 15:35] Trudy Pelzer
Bug#19107 is a duplicate of this bug.
[20 Aug 2009 0:16] Adam Dixon
This also does not work in XP.
[20 Aug 2009 0:39] Mattias Jonsson
XP's NTFS does not support true symbolic linked files (as on unix), Vista and Server 2008 does.