Deleted Issue Recovery

Added by mujhahid karim about 5 years ago

I have one issue that desappear from my database, I need to know who deleted this issue, can I know using some querys on the database?

Or can I recovery one issue from the last backup that I have? and import on the production database.

Replies (1)

RE: Deleted Issue Recovery - Added by h k about 1 year ago

Recovery of issue is possible simply by using the INSERT command from a backup.
I did:

mysql -u redmine -p
use redmine; (my database)
INSERT INTO `issues` VALUES (19,1,8,'...,NULL); (copied from backup);

Worked flawlessly.