I am trying to move a MySQL database onto the pool so that it is duplicated etc. By default MySQL installs and puts it's databases on the C drive which is fine for the application but not for the databases as the system is on WHS2011 with only a 60Gb partition. To do this you need to edit the configuration file to change the database folder. The relevant entries are:
# Path to database root
datadir="C:/ProgramData/MySQL/MySQL Server 5.6/Data\"
which I've tried changing, after creating the folders, to:
datadir="//Server/Databases/MySQL\" and datadir="J:/Serverfolders/Databases/MySQL\" (J being the Drivepool virtual drive) to no avail.
Unfortunately the error messages are not verbose but it tries to create a test file in the folder which fails.
I have a similar problem when using IIS Manager to try to add a website that is on the pool. It does not work when using either the share, which it may just not support, or the virtual drive letter.
Everything works fine if I direct it to the D drive (remainder of the system SSD and not pooled) but that is limited in size and not duplicated.
Any idea how I can achieve either of these things?