Login

mvnForum

mvnForum Homepage Welcome Guest
  Search  
  Index  | Recent Threads  | Unanswered Threads  | List Polls  | Public Albums  | Who's Online  | Help

  mvnForum
  Category: mvnForum
  Forum: Support and troubleshooting
  Thread: Retrieving Data

Quick Go »


No member browsing this thread
Thread Status: Active
Total posts in this thread: 5 		Post new Thread
Author
Previous Thread This topic has been viewed 1322 times and has 4 replies Next Thread
Male nimishprasad
Stranger




Joined: May 21, 2008
Post Count: 2
Status: Offline
Reply to this Post  Reply with Quote 
Retrieving Data
Hi,

My org is going to decommission the server whr mvnforum is now deployed and we do not know as yet when it will be made available on a different server. This includes the DB server too. I need to retrieve all the data that is existing today including the attachments and stuff. Please let me know how this can be done.

TIA,
Nimish
[Jun 30, 2008 3:07:08 PM] Show Printable Version of Post    View Member Profile    Send Private Message [Link] Report threatening or abusive post: please login first  Go to top 
Male tqphong
mvnForum developer



Vietnam
Joined: Sep 16, 2004
Post Count: 85
Status: Offline
Reply to this Post  Reply with Quote 
Re: Retrieving Data
If not mistaken, all of tables in mvnforum have a default-field: "CreationDate" which is data created real time. In my opinion, you can retrieve data based on this field.
[Jul 1, 2008 2:54:53 AM] Show Printable Version of Post    View Member Profile    Send Private Message    Hidden to Guest    minesking [Link] Report threatening or abusive post: please login first  Go to top 
Male minhnn
mvnForum Developer
Member's Avatar

Vietnam
Joined: Oct 16, 2002
Post Count: 2956
Status: Offline
Reply to this Post  Reply with Quote 
Re: Retrieving Data
What version of mvnForum, OS and database server you are running?

Generally to migrate from one server to another server, you need:

- Use the backup tool of your database server to backup database.

- Backup folder mvnForumHome

- Backup folder mvnplugindata in your context

- Backup all of your context for reference later.
----------------------------------------
Minh Nguyen
mvnForum Developer
Want a free, open source Java Jsp/Servlet forum, get mvnForum at http://www.mvnForum.com

http://www.DienDanLinux.org
[Jul 1, 2008 8:51:40 AM] Show Printable Version of Post    View Member Profile    Send Private Message    Hidden to Guest    http://www.MyVietnam.net    minhnn_mvn [Link] Report threatening or abusive post: please login first  Go to top 
Male nimishprasad
Stranger




Joined: May 21, 2008
Post Count: 2
Status: Offline
Reply to this Post  Reply with Quote 
Re: Retrieving Data
We are running mvnForum 1.0.0 RC4 Update 2 on a unix box. The database is Oracle.

I was thinking more on the lines of probably executing a query or something like that and extract all the data onto a spreadsheet or word doc or something like that. Is that possible? At this point we are not even sure if they will use mvnforum again.

Nimish
----------------------------------------
[Edit 2 times, last edit by nimishprasad at Jul 1, 2008 4:12:39 PM]
[Jul 1, 2008 4:10:56 PM] Show Printable Version of Post    View Member Profile    Send Private Message [Link] Report threatening or abusive post: please login first  Go to top 
Male minhnn
mvnForum Developer
Member's Avatar

Vietnam
Joined: Oct 16, 2002
Post Count: 2956
Status: Offline
Reply to this Post  Reply with Quote 
Re: Retrieving Data
I guess Oracle have a tool that help you backup all of your database, and you also need to backup mvnForumHome and your context. With these backup files, you could restore it later.
----------------------------------------
Minh Nguyen
mvnForum Developer
Want a free, open source Java Jsp/Servlet forum, get mvnForum at http://www.mvnForum.com

http://www.DienDanLinux.org
[Jul 31, 2008 7:43:23 AM] Show Printable Version of Post    View Member Profile    Send Private Message    Hidden to Guest    http://www.MyVietnam.net    minhnn_mvn [Link] Report threatening or abusive post: please login first  Go to top 
Show Printable Version of Thread  Post new Thread

RSS feeds Current timezone is GMT
Jan 9, 2009 6:15:16 AM

Powered by mvnForum Portlet 1.2 GA (Build: 27 June 2008)
Copyright © 2002-2008 by MyVietnam.net