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:Windows (Vista, Server 2008)
Assigned to: 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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.059 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.