Description:
The question is how do you install this custom and direct the data folder to another location prior to install?
I am looking for some command line options which can be run via administrator CLI aka CMD command in Windows 2008R2.
The goal is to be able to install MySQL 5.5 or newer to D:\MySQL and this includes the data folder. As it stands now with default installation using custom you can specify the program installation dir/folder but the data forces itself to C:\ProgramData\MySQL..\.. and we don't want this because we use images to maintain system configuration and force all applications to the D partition or drive and this allows us to recover a server when there are issues much easier because we can leave the D drive alone and re-image from Acronis.
Many times MS OS patches hose a server and even rolling them back never restores the server to it's previous state so there is value in this type of configuration for all.
Another BIG reason providing an option to install MySQL on drives other than C drive is because MS has a folder which tremendously bloats over time called the winsxs folder located in C:\Windows\System32\winsxs and it can fill up a C drive quickly due to applications and patches getting installed sometime forcing a rebuild of a server since there is no way to purge this.
The developers of MySQL could do us all a favor and provide a field to specify the data folder or publish the command line options to force the data folder to another location other than C:
Service will not start with data folder on D:\MySQL\Data even if the my.ini specifies the correct path because the data folder the service is looking for is on the C: drive.
Thanks,
JK
How to repeat:
Install the product on Windows 2008R2 using the custom to request installer use D: drive. Try to install with path D:\MySQL and the program will complete.
Then unhide the hidden folders in Tools\Options from explorer window.
Browse to C: and find location where the data folder gets installed even after requesting the location be D:\MySQL to C:\ProgramData\MySQL..\..
Suggested fix:
Publish the solution or work around to this or create a patched installer which allows administrator to specify the data folder install path.
