Return to Jive Software

Skip navigation
Up to Discussions in Support
599 Views 4 Replies Last post: Feb 9, 2010 10:37 PM by edazhao RSS
edazhao Novice
edazhao
79 posts since
Jan 19, 2009
Currently Being Moderated

Feb 8, 2010 12:29 AM

About Clearspace DB migration

Hi Team

 

Recently we are planning to migrate Database from MS SQL2000 to MySQL5 and upgrade clearspace to latest version.

We tried to use the migration function that clearspace bundled but seems it will spend a lot of time(might be 40hours) since the size of our DB is about 20GB.

And the process crashed few times while long time migration for some reason.

I tested MySQL migration kit and it works well in migration. The whole process spent almost 4 hours. But I don't know how to connect the database transfered by mysql migration kit to Clearspace.

I was wondering is this way possible for the clearspace db migration?\

We will be very appreciated for any assistance.

Thank you very much.

 

Eda

long.tonthat Jive Employee
long.tonthat
12,607 posts since
Apr 1, 2008
Currently Being Moderated
Feb 8, 2010 6:21 PM in response to: edazhao
Re: About Clearspace DB migration

Eda, to confirm I understand correctly:
You've migrated the MS SQL database to Mysql?

 

Now, you're now trying to connect the Mysql database to Clearspace? If this is the case, you can simply re-run through Clearspace setup and reconfigure the database settings.

 

In initialize Clearspace's setup console, edit the {jiveHome}/jive_startup.xml and modify <setup>true</setup> to false. Restart the application and the next time you hit the site, you'll be welcomed with the Setup console.

-Long

edazhao Novice
edazhao
79 posts since
Jan 19, 2009
Currently Being Moderated
Feb 8, 2010 6:40 PM in response to: Long Ton That
Re: About Clearspace DB migration

Yes. But since our clearspace currently has some modification in setting.  And the configuration should be stored in JiveHome folder, right?

So I want to know if Clearspace reconfigure process will remove the customized setting?

Thanks.

 

Eda Zhao

Tel: 86-29-87607673 Ext 8015

 

From: Long Ton That communities@jivesoftware.com

Sent: Tuesday, February 09, 2010 10:21 AM

To: Eda Zhao

Subject: http://www.jivesoftware.com/jivespace/message/340507#340507/Support New message: "About Clearspace DB migration" http://www.jivesoftware.com/jivespace/message/340507#340507/7rABb-int-1qzN

 

Jivespace<http://www.jivesoftware.com/jivespace/index.jspa>

 

About Clearspace DB migration

reply from Long Ton That<http://www.jivesoftware.com/jivespace/people/long.tonthat> in Support - View the full discussion<http://www.jivesoftware.com/jivespace/message/340491#340491

long.tonthat Jive Employee
long.tonthat
12,607 posts since
Apr 1, 2008
Currently Being Moderated
Feb 9, 2010 6:17 PM in response to: edazhao
Re: About Clearspace DB migration

Hey Eda, any settings in the application that you may have changed are stored in the database... so if you point the application to the newly migrated database it should retain all the settings. As always, backup and test thoroughly before pushing to production.

edazhao Novice
edazhao
79 posts since
Jan 19, 2009
Currently Being Moderated
Feb 9, 2010 10:37 PM in response to: Long Ton That
Re: About Clearspace DB migration

Thank you very much. I’ll take a test once current DB migration process that with clearspace bundled finished. It has been running almost 48hours.

 

Eda Zhao

Tel: 86-29-87607673 Ext 8015

 

From: Long Ton That communities@jivesoftware.com

Sent: Wednesday, February 10, 2010 10:17 AM

To: Eda Zhao

Subject: http://www.jivesoftware.com/jivespace/message/341295#341295/Support New message: "About Clearspace DB migration" http://www.jivesoftware.com/jivespace/message/341295#341295/aPIC8-int-1qLN

 

Jivespace<http://www.jivesoftware.com/jivespace/index.jspa>

 

About Clearspace DB migration

reply from Long Ton That<http://www.jivesoftware.com/jivespace/people/long.tonthat> in Support - View the full discussion<http://www.jivesoftware.com/jivespace/message/341235#341235

More Like This

  • Retrieving data ...

Bookmarked By (0)

To better serve our customers we have included functionality to automatically follow up on a case after it has been idle for more than 5 days, and then auto close after an additional 3 days of inactivity. Choose No to acknowledge that this case will remain idle for longer than 5 days.
Making cases public allows other customers to learn from the solution of the case. It can also be used to gain feedback from others in the community. Ask our Support Engineers for more info, but we encourage you to make your cases public.