MySQL Bugs: #1741: Server on Windows 2K and data on Windows NT does not work

Bug #1741	Server on Windows 2K and data on Windows NT does not work
Submitted:	3 Nov 2003 5:07	Modified:	3 Nov 2003 22:36
Reporter:	André Lehmann	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S2 (Serious)
Version:	4.0.16	OS:	Windows (Windows 2K/NT)
Assigned to:		CPU Architecture:	Any

Description:
When installing mysql server on a Windows 2000 machine, and installing the data on a Windows NT machine, the server will not launch.

How to repeat:
Put the database on an NT machine.
Install mysql server on a 2K machine.
Edit my.ini in C:\WINNT, add the following lines:

--------------------
[mysqld]
basedir=c:/mysql
datadir=s:/data
--------------------
assuming that s is mapped to the NT machine (but \\[NT machine]\data has the same result)

launch the server on the windows 2k machine. It will not start.

Using the 'max' version with ".sym" files does not help. 

Suggested fix:
Installing the data on a windows 2k machine ;-)!

Are you starting mysqld as a service?  If so, have you configured the service to start using a domain login rather than the local system account?  Have you tried //MACHINE/Share/path/to/data/directory (ie: forward slashes rather than backslashes)?

On my XP machine I mapped the Win2k directory named win2000 with the
letter Y. Below my.ini file:

# The MySQL server
[mysqld]
skip-innodb
basedir = e:/mysql/
datadir = y:/data/

Copied the whole directory data on the new Y mapped directory and
renamed on XP the data directory.

Now I start the server on XP, create a database and table:

Microsoft Windows XP [versão 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

E:\mysql\bin>mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.16-nt-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database mytest;
Query OK, 1 row affected (0.00 sec)

mysql> use mytest;
Database changed
mysql> create table myu (id int);
Query OK, 0 rows affected (0.09 sec)

Now I verify the files on Win2k:

Microsoft Windows 2000 [Versão 5.00.2195]
(C) Copyright 1985-1999 Microsoft Corp.

E:\>dir win2000\data\mytest\*.*
 O volume na unidade E não tem nome.
 O número de série do volume é 8C9C-D751

 Pasta de E:\win2000\data\mytest

04/11/2003  04:18       <DIR>          .
04/11/2003  04:18       <DIR>          ..
04/11/2003  04:18                8.550 myu.frm
04/11/2003  04:18                    0 myu.MYD
04/11/2003  04:18                1.024 myu.MYI
               3 arquivo(s)          9.574 bytes
               2 pasta(s) 12.414.726.144 bytes disponíveis

BTW MySQL only supports mapped drives and not supports
UNC paths like:  \\MyWorkstation\win2k.

Please verify the privileges on both machines and if you
are using the correct path for the datadir variable.