Separating a secondary site to a different location

If you have questions about using mojoPortal, you can post them here.

You may want to first review our site administration documentation to see if your question is answered there.

This thread is closed to new posts. You must sign in to post in the forums.
6/30/2009 8:59:26 AM
eslachance
Gravatar
Total Posts 33
View Posts

Separating a secondary site to a different location

Hello all,

I'm wondering if there is any way to separate a secondary site within mojoportal and let it become its own standalone site, either on the same server or a different one.

I expect I would need to somehow export the database as well as the files somewhere, but I'm really not sure how to proceed (Note that I am going from a test environment with sqlite to a prod environment with sql server 2005).

6/30/2009 9:09:21 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Separating a secondary site to a different location

You can make a copy of the installation files and db, move it to another installation. If the host name is going to change then you should add the new host name mapping to the site before you copy it. You can run a query in the db to set the IsServerAdminSite flag to true on the site row in mp_Sites if its not already the root site in the previous installation. Then you will be able to delete the other site using site settings. I did this myself long ago, I had both mojoportal.com and joeaudette.com running from the same installation and db but I separated them into different installations and different dbs (both MySql).

However, changing from one db platform to another and migrating content across db platforms is another story. I have no solution for that at this point.

Hope it helps,

Joe

You must sign in to post in the forums. This thread is closed to new posts.