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?
Question
DavidSomeone
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?
Link to comment
Share on other sites
10 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.