Project

General

Profile

Forums » Help »

Move back issues from other projects

Added by Denial Dester over 10 years ago

Hello everybody,

I need your kindly support.

I have a big project in my Redmine with a lot of subprojects in it.
More than 300 issues have been moved from this project to another subprojects by mistake. And I haven't got a chance to rescue it by hands directly from Redmine. But I have a database dump which has been done before this accident.
So, my question is - Can I compare table "issue" from right database with damaged database and move issues back? Or May be has any tools or methods to move back issues to right project?
My Redmine version is 2.0.4. Database: PostgreSQL.

Thank you in advance.


Replies (3)

RE: Move back issues from other projects - Added by Jan Niggemann (redmine.org team member) over 10 years ago

Denial Dester wrote:

I haven't got a chance to rescue it by hands directly from Redmine

Why?

Can I compare table "issue" from right database with damaged database and move issues back?

Yes, you can update the relevant column of these issues to the correct one...

RE: Move back issues from other projects - Added by Denial Dester over 10 years ago

Why?

Because I don't remember in which projects and subprojects have to be each task.

I've upgraded column "project_id" in table "issues" but no luck :(

RE: Move back issues from other projects - Added by Ivan Cenov over 10 years ago

If you have SQL dump of teh database before moving, you may try to import it over existing database.

    (1-3/3)