Extract individual projects and move to a different server

[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.

[mcraig88]

How about a database dump/restore, then delete other projects/bugs? Not pretty, but would work.

[bazianm]

Yeah. Pretty much what I was thinking. I was hoping there was another way.

Thanks

[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...

[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.