Does JIRA XML Restore not wipe the database?

Seb Kouba June 3, 2015

Having used the XML restore mechanism after running some tests, the database is still 5GB (result from test) rather than the few MB I expected.

This is the command I'm using in postgres:

SELECT pg_database.datname, pg_size_pretty(pg_database_size(pg_database.datname)) AS size FROM pg_database;

The data isn't accessible via JIRA but apparently it's still in the db. Is that intentional? 

I know that db dumps are recommended for backup and restore but in this case it's only a test system and I was being lazy...

The system runs JIRA 6.4.2

1 answer

0 votes
William Zanchet [Atlassian]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 4, 2015

A restore from a XML backup shouldn't wipe your database, but overwrite your data with the information from the XML itself. In other words, you'll lose what you have there, because the new data will be added there.

Cheers,
WZ

Seb Kouba June 4, 2015

What about this scenario (i.e. mine): - Create 200k issues, users etc (-> 5GB db) - Restore XML from when you had 1k issues Now I still have the 5GB of data in my db but Jira only displays / users / idk the data from the 1k issues What happens to all that data that's now idle? This isn't a huge problem in this case, since I'm messing with a test server but it's definitely not the behaviour I had expected and I thought maybe it's not meant to be this way / it might be interesting for people to know... I guess I could reset the installation (i.e. db) completely and then do a system import of just the XML backup. I had expected the outcome to be the same as with what I have done, import over existing installation...

Suggest an answer

Log in or Sign up to answer