New server install with existing database/files

[Steve]

What is the procedure for installing ResourceSpace on a new server, but using the database and associated filestore from a previous installation?  We are interested in moving to a new server.  It appears ResourceSpace will make a new, empty database on install, but we already have that from the existing installation.

[Arne Hermann]

This is fairly simple. You will want to do a complete DB export from mySQL and then import that DB into the new installation's DB. The filestore can just be copied straight to the new installation. You will need to make sure that your file permissions are correct on the target after moving the filestore.

A couple of points though. Note that this assumes you are installing to the same version of RS.  If your filestore and DB is large, you may want to do this from the mySQL command line if you have access to that. If not, (and it's large) you may want to do the import in stages. If you're not familiar with mySQL, you may want to have someone experienced with it do that for you. Still, I'd try this first.  If you have phpMyAdmin installed, you can simply go to the EXPORT menu for the entire database . Select "Custom - display all possible options" in the Export Method.  In Output, choose "save to file". For format, choose "SQL". Under "Format-specific options" choose "Dump table / data" (you only want to export the data not the structure).  Save the file, login to phpMyAdmin on the new install and use the IMPORT function which should be pretty obvious.  Then copy the filestore. Obviously, you need to ensure your config.php is setup/changed for the new DB server on the target.

Hope this helps; feel free to ask more specific questions and I'll try to help.

-Arne

[Steve]

Thanks for the info.  What if the new install is a later version of ResourceSpace?

[Arne Hermann]

Well, then you have to check to see if there are any differences in the DB structure. I noted that from V4 to V7 there were a few. Others can better address this but I suspect that if you're migrating only up a small version change, the DB structures will either be identical (in which case, np) or very minor changes/additions to fields. There *might* be a tool that will tell you quickly or some info in the forums but I'd be inclined to export both structures to text files and then use a DIFF program like WinDIFF or "diff" in Linux to compare the files. In most cases though, even if there's a new field in a table, the IMPORT function will still import the data but you won't have a value in the "new" field in the target.  Whether or not this is a problem would have to be addressed by the devs I think.

GL,

-Arne

[Jethro Dew]

You need to copy:

 The Filestore 

 The Database

 Your config file.

Just replace the new database on the new server with your existing database and then the filestore and config etc.

Then you can just login and use as normal. ResourceSpace uses a DBStruct check which will dynamically build the database if it can't find the rows required. This means that you don't need to worry what version of resourcespace you are running as it will build the bits it needs.

Kind Regards

Jethro

[Stuart Bithell]

I would also recommend reindexing after doing this, too.

[Steve]

Thanks all for the suggestions.

[Kevin Chung]

When I import the database and attempt to upload a file. I am getting Filename invalid error.   Am i missing part of the process?