MySQL Bugs: #70702: MySQL Server 5.6 not reading change of datadir

Bug #70702	MySQL Server 5.6 not reading change of datadir
Submitted:	23 Oct 2013 13:46	Modified:	23 Nov 2013 15:30
Reporter:	Mark Rouse	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.6	OS:	Windows (64-bit)
Assigned to:		CPU Architecture:	Any

Description:
MySQL Server 5.6 installs with a default datadir as: C:\Program Files\MySQL\MySQL Server 5.6\data.  However, if I change this to k:\data2 in my.ini, everytime I restart MySQL server in Workbench it tells me that my datadir is still C:\Program Files\MySQL\MySQL Server 5.6\data.

How to repeat:
Change default datadir to another specified location and restart server.  Old location is still being used.

Thank you for the bug report. I couldn't understood what are you reporting:

First the default datadir is the below:

Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.14 MySQL Community Server (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> SHOW VARIABLES LIKE "%DIR%";
+-----------------------------------------+---------------------------------------------------------+
| Variable_name                           | Value                                                   |
+-----------------------------------------+---------------------------------------------------------+
| basedir                                 | C:\Program Files\MySQL\MySQL Server 5.6\                |
| binlog_direct_non_transactional_updates | OFF                                                     |
| character_sets_dir                      | C:\Program Files\MySQL\MySQL Server 5.6\share\charsets\ |
| datadir                                 | C:\ProgramData\MySQL\MySQL Server 5.6\data\             |

When you change the datadir in your my.ini have you moved the files to the new
datadir (of course after stop the server) and then re-started the server?. Thanks.

When I run the following: SHOW VARIABLES LIKE "%DIR%";

I get:

Variable        Variable_Name
datadir         C:\ProgramData\MySQL\MySQL Server 5.6\data\

in my my.ini datadir is set to datadir = "K:/data2".

I've restarted the server 16 times and it does not pickup the fact that the datadir should be datadir = "K:/data2".  As you can see from the SHOW VARIABLES LIKE "%DIR%" command it still defaults to the same folder, even though I have changed this.

Sorry meant:

Variable_Name |  Value
--------------------------------------------------------------
datadir       |  C:\ProgramData\MySQL\MySQL Server 5.6\data\

Please print here the output of the below command, change mysql56 if you are using another service name. Thanks.

c:\dbs>sc qc mysql56
[SC] QueryServiceConfig SUCCESS

SERVICE_NAME: mysql56
        TYPE               : 10  WIN32_OWN_PROCESS
        START_TYPE         : 2   AUTO_START
        ERROR_CONTROL      : 1   NORMAL
        BINARY_PATH_NAME   : "C:/Program Files/MySQL/MySQL Server 5.6/bin\mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" MySQL56
        LOAD_ORDER_GROUP   :
        TAG                : 0
        DISPLAY_NAME       : MySQL56
        DEPENDENCIES       :
        SERVICE_START_NAME : NT AUTHORITY\NetworkService

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".