Revert Database

[aram.dermenjian]

Backend: So say I archived my database yesterday and I made quite a few edits/errors today and I want to revert back to the old data that was stored.

Assumptions: We can pretend that the only things I changed were moving issues to other projects, transitioned a few statuses, and updated a few fields (fairly 'basic' stuff). Also we can assume that the versions haven't changed.

Products: Crowd, JIRA, and Confluence

Question: Short of just mysql dumping the archive into the database, are there any settings I need to change/alter in order to be able to fully revert? (Naturally I'd back up the DB first, so everything will be safe =P)

I assume it's just a quick db dump, but I want to double check/make sure before I actually go through with it. Thank you very much in advance =D

[Nic Brough [Adaptavist] · Accepted solution]

No, you have nothing to worry about here - just restore the backup (while the applications are down of course)

[aram.dermenjian]

Thanks =) It worked like a charm =D JIRA had a minor plugin hickup, but after stopping jira and restarting it for a second time, it worked wonders. Thanks again for verifying =)