Howto restore a deleted issue from database backup
Added by Terence Mill almost 12 years ago
Someone accidently deleted and iusse and now i want to restore only that issue (with relations to other issues, documents, project, comments ..if possible) from my datbase backup.
I found the insert entry for the mysql issues table but i am not sure about the following questions.
- Is ist possible that the unique id already is reused? Is the column 'id' unique and will it be checked therefore i i try to insert same id . Just in case the id is reused already and then the insert shall fail. Does it?
- Are there other tables i have to create entries and relations for an issue?
- Any help which sql i have to use ?
You can assume that the tracker, the project, assigne, watcher,categories and version entities still exists in db.
Please help!!