MySQL Bugs: #47447: Can't start server from command line.

Bug #47447	Can't start server from command line.
Submitted:	19 Sep 2009 9:22	Modified:	20 Sep 2009 17:16
Reporter:	Peter Laursen (Basic Quality Contributor)	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.1.38	OS:	Windows (Win7 - 64 bit)
Assigned to:		CPU Architecture:	Any
Tags:	qc

Description:
I cannot start server (5.1.38-64 bit for Windows) from command line. I have UAC on 2-lowest level. cmd.exe is startet with explicit admin option.

How to repeat:
C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqld --no-defaults
090919 10:29:24 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Se
rver 5.1\data\Peter-PC.lower-test
090919 10:29:24 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Se
rver 5.1\data\Peter-PC.lower-test
mysqld: Can't change dir to 'C:\Program Files\MySQL\MySQL Server 5.1\data\' (Err
code: 2)
090919 10:29:24 [ERROR] Aborting

090919 10:29:24 [Note] mysqld: Shutdown complete

Renaming files path makes no difference (so it is not SPACES in the files path). Also

C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqld-nt --no-defaults
C:\Program Files\MySQL\mysql-snapshot\bin>mysqld --no-defaults

.. both work fine with 5.0.85 and latest 5.1.40 snapshot from MySQL Labs respectively.

Suggested fix:
not sure ..

Changed OS description from "4 bit" to "64 bit" (obviously).

Also I should have told that when started as service it starts OK.

Problem persists with 5.1.39 from ftp://mirrors.dotsrc.org/mysql/Downloads/MySQL-5.1/
(maaybe not officially released byt file ftp://mirrors.dotsrc.org/mysql/Downloads/MySQL-5.1/mysql-5.1.39-winx64.msi exists)

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqld --no-defaults
090919 14:33:55 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Se
rver 5.1\data\Peter-PC.lower-test
090919 14:33:55 [Warning] Can't create test file C:\Program Files\MySQL\MySQL Se
rver 5.1\data\Peter-PC.lower-test
mysqld: Can't change dir to 'C:\Program Files\MySQL\MySQL Server 5.1\data\' (Err
code: 2)
090919 14:33:55 [ERROR] Aborting
090919 14:33:55 [Note] mysqld: Shutdown complete

C:\Program Files\MySQL\MySQL Server 5.1\bin>net start mysql51
Tjenesten MySQL51 starter.
Tjenesten MySQL51 er startet.

C:\Program Files\MySQL\MySQL Server 5.1\bin>

okok .. got the point!

there is no folder C:\Program Files\MySQL\MySQL Server 5.1\data\ as the server was installed with the installer for windows.  /datadir is in 'Program data'.

C:\Program Files\MySQL\MySQL Server 5.1\bin>mysqld --no-defaults --datadir="c:\p
rogramdata\mysql\mysql server 5.1\data
.. works

I think I saw a few similar reports recently. The whole mess started when default /datadir posisiton was moved to work around problems with UAC (and I had my share in that).  

Not easy to decide on I think.  There are PROs and CONs with every solution.

I am closing.  The command options work.

Problems is of course some inconsistency between the installer and the server binary and - also - that numerous examples in documentation assume a *nix file structure.

However it is all known and is an ever ongoing discussion. This report adds nothing new.