Project

General

Profile

Deleted Issue Recovery

Added by mujhahid karim over 7 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 over 3 years 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);
quit;

Worked flawlessly.

    (1-1/1)