Search the Community

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?