Hello,

I'm migrating and moving around a couple of sites to take advantage of Mojo's multi-site capabilities. The only problem is I'm stuck with a database that has a secondary site as its only site but in my new configuration I would like for that to become Site2.

In other words, in mp_Sites I want to change SiteID1 to SiteID2 so that a different site can become SiteID1. Basically swapping those two SiteIds.

Due to the constraints and keys, I was not able to change the values directly in SQL Manager. Maybe you know a trick for bypassing that error check to make a simple change from 1 to 2 and from 2 to 1 in the SiteID column? Changing the Data/Sites/x names is presumably also necessary.

Thanks!

Thanks Joe, that seems to have worked. One thing I noticed though, keeping in mind I need to set this up and test before it goes live, is that if I did not have subdomains to use as pointers, there would be no pages for the additional sites. Maybe the pages would exist but they are not be accessible in the normal way.

Is there a better way to design/build multiple sites (or even just a new site) without having to setup a fictitious subdomains that uses header mapping to "activate" it?

Thanks,