CiviCRM Community Forums (archive)

I've found two useful, though not quite complete posts that have helped in this - They are scripts for deleting domains and renaming them - though I think they are for older versions, so I've had a little hassle along the way.

Bear in mind that this is not the production version and I have a good set of backups!

I'm using a local installation to do the separation - that is to say for each domain I delete all the domains that I'm not interested in then rename the domain to domain number 1, then dump the database, create a new database appropirately named, populate it using the sql script produced by the dump and then change that sites civicrm settings file to use the new database.

To delete a domain I've used this script:

http://wiki.civicrm.org/confluence/display/CRMDOC/Delete+a+domain

Although it appears to be for an earlier version than 2.0.2 and therefore throws a number of errors - for tables that don't exist I've just skipped.

To pick up the new tables I just tried to delete the domains in civicrm_domain and worked through the constraint errors until I had deleted all the entries in all the tables. I may give a go at noting this more accurately to that I can re-write the script for 2.0.2

Then, because I read somewhere that the upgrade script assumes the domain id to be 1 I used this script to change the domain name:

http://wiki.civicrm.org/confluence/display/CRMDOC/Change+CiviCRM+domain_id

THis seems to be for the same version so has the same extra tables and presumably misses out the same lot. So although I now appear to have a version that upgrades to 2.1 I assume that I have some errors.

Now that I know that it will work, I'll work through the process again and create working scripts for 2.0.2

UNLESS - someone already has versions of these scripts for 2.0.2!!!

That's for later. This is perhaps the only sunny week end in England since spring and I'm craving some sun!