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.
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.