Page 1 of 1

Extract individual projects and move to a different server

Posted: 08 Jan 2009, 20:33
by bazianm
Hi,

I am using MantisBT 1.1.6 for many projects. One client wants to bring Mantis in house so I will set it up for them on an in house server. The issue we run in to is how to migrate the information for a project (actually from two projects) from one server to the other. There is just too much data for me to reenter the information from one to the other.

One way I was thinking was to backup my entire database and restore it on the new server. I would them remove the projects and entries that do not relate to this client.

Is there an easier way to do this?
Is my idea viable?

Thanks in advance.

Re: Extract individual projects and move to a different server

Posted: 12 Jan 2009, 21:08
by mcraig88
How about a database dump/restore, then delete other projects/bugs? Not pretty, but would work.

Re: Extract individual projects and move to a different server

Posted: 14 Jan 2009, 16:16
by bazianm
Yeah. Pretty much what I was thinking. I was hoping there was another way.

Thanks

Re: Extract individual projects and move to a different server

Posted: 14 Jan 2009, 21:26
by bazianm
Just FYI... it worked perfectly. All I had to do was delete the other projects and everything was nice and clean.

Thank you for your assistance...

Re: Extract individual projects and move to a different server

Posted: 11 Mar 2009, 13:52
by nsecrier
I had to do a similar task and moving the DB from one server to another server was the best solution.
If you use MySQL db you can use the new GUI tools to migrate data between the server instances and you can also consolidate from multiple instances into a single one (use MySQL Migration Toolkit). It will allow you to overwrite 4MB BLOB limitation.