I run TestRail on a local server. We presently support 29 projects. Not long ago, a user mistakenly deleted a test suite. Although the database is backed up nightly, it was nevertheless cumbersome to recover the test suite; I restored the database to the test server, exported the target test suite to XML, re-imported the XML, and manually re-linked the attachments to the test suite.
While the test suite was recovered, the test runs were not, as there does not appear to be a way of importing test RUN XML data. How can this data be restored to the production server?
Is there a backup/restore strategy that targets both the test suites and test runs for a single project? This is preferable to a full database backup, as it does not interfere with data from other projects.