'Mantis: Selective restore from backup

While restructuring a Mantis system, to reduce the number of sub-sub-projects, I made a newbie error - I had a filter (hide closed) so unfortunately, I didn't move all issues before I deleted the sub-project... and hence all those closed issues are lost.

The good news is that I have a full database backup... and I can restore the whole database, which I have done on a separate installation (I can view all issues etc)

But, obviously, my live database has moved on - I don't want to restore the whole database, but just the selected issues that I've deleted. CSV export/import only deals with the issue itself, without any of the notes or suchlike.

Any suggestions?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source