ResourceSpace Database Location

[Brandon Epler]

Hello All,

I am fairly new the ResourceSpace so this may sound like a stupid question.  I am trying to move the ResourceSpace database from the C: to another partition on the server.  I am using mySQL 5.5 and I moved the C:/ProgramData/MySQL/MySQL 5.5/data folder to the new location. From here I specified in the my.ini to point to the new location G:/mySQL/data.  After doing so, I uploaded about 250MB worth of pictures but it is still consuming data on

my C drive.  If anyone can shed some light on this that would be great.

Thank you,

Brandon

[Roger Howard]

Hi Brandon,

There are two main types of storage in ResourceSpace.

database: your MySQL database stores all metadata such as keywords, field values, user account information, etc. Typically each asset/resource you ingest (upload) into ResourceSpace will consume a few kilobytes of storage within your database. When you relocated the MySQL data folder, you moved this.

filestore: the actual files uploaded into ResourceSpace are stored somewhere on the filesystem (a folder/directory), not within the database. This is why moving the database did not have the desired effect - because you didn’t relocate the filestore.

To relocate your filestore, there are several methods - choice will depend on your level of comfort, what Web server you use, and possibly other factors.

There are two variables you’ll need to set:

$storagedir
$storageurl

These are both documented in the config.default.php file, though historically there have been some issues with making this work easily on Windows. I’m not sure where that currently stands.

$storagedir — this would be a path, like “D:\filestore\” where you want the files to be kept.
$storageurl — this is a little tricky, because you need to configure your Webserver to point at $storagedir, and that process varies depending on if you’re using IIS, Apache, or Nginx. What web server do you use? If IIS, setup a Virtual Directory, pointing at the location in $storagedir, with the url “/filestore”




Another approach is to just relocate the *entire* Web root to your G: drive; this way you don’t need any special filestore config. For a newbie I’d recommend this approach.

[Brandon Epler]

Hello Roger,

Thank you for replying to this post so quickly.  I am using IIS and I would like to go with your suggestion to move the entire directory to the other partition. 

What would be the best process to move the entire web root?

Thank you,

Brandon

[Roger Howard]

I don’t have a Windows/IIS server handy, but generally speaking:

- Go into IIS Manager (I think that’s what it’s called)
- Go to the Sites section
- Right click your existing Site
- In the Physical path field, point it at a directory on your G: drive
- Copy all the files in your previous webroot (C:\inetpub ??) to your new directory on G
- Stop and Start IIS

I can’t really help beyond this - I’m not an IIS guy and I don’t want to give you advice that leads you to a broken install without being able to verify it myself. These are really general Web server questions, and while I know RS is a great and tempting product, free and powerful, it requires a base level of sysadmin knowledge to avoid getting into real trouble with it down the road.

[Jethro Dew]

You can also use a symbolic link which requires no changes to setup at all. Just move the files to your new drive and create a symbolic link (not a shortcut) called filestore in your ResourceSpace directory.

https://msdn.microsoft.com/en-us/library/windows/desktop/aa365680%28v=vs.85%29.aspx