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
• Status: Verified
• Category: MySQL Server: General
• Severity: S4 (Feature request)
• OS: Windows (Vista, Server 2008)
• CPU Architecture: Any
• Tags: disabled, symbolic files, windows

[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.