Migrate the structure of an instance

[David Ryan]

Does someone know if there's a document outlining how to migrate the UI configuration and database structure from an existing ResourceSpace instance - specifically without exporting things such as the resources, the transaction logs, the metadata associated with the existing resources?

I have installing RS from scratch down to a fine art, but now I want to incorporate into my new vanilla install all the tweaks that I made to my old instance without copying across the 40,000 images and the millions of lines of logs.

For example - I added extra metadata fields, I added tabs, etc . . . and I want to import them and have them usable in my new instance without having to go through all the clicks again - possibly forgetting some key config changes I've made.

I have copied over the config.php for configuration tweaks and I have manually imported the SQL for some tables (for example tabs and metadata definition) but there's more that is needed.  Unfortunately I can't find anything that says what tables specifically are related to the structure of the application and what are explicitly related to the resources that have been imported.

Any help appreciated.

David

p.s. another way to think of my scenario is that I have spent years setting up RS for "The University of North Elbonia" and my friend in the "University of East Elbonia" thinks it's cool and wants to do the same.  I want to give them the structure of my instance, but nothing to do with my users, my resources, etc . . . 

[Dan Huby]

Hi David,

Sorry for the late response. It's quite intertwined. Particularly the node table which contains both fixed list metadata options (considered part of setup/schema) and per-resource data too.

I think I would clone the entire system, then delete resources in the UI. 

Or you could run "delete from resource" in the database, then run "php pages/tools/database_prune.php" to clean up orphaned rows in other tables, finally deleting the contents of the /filestore/ folder.

Dan