Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

after the last update, we lost our data. we have backup files and re install confluence and replace

Hello there,

We use confluence as a documentation and knowledge center for a small NGO. After the last update of our product, unfortunately, we got a problem and lost our data. The specifics of our system is:

  • Windows server 
  • last version of Confluence: 6.15.6
  • the new version of Confluence: 7.4.6

We have all of our data as a backup and data with it (it is a file and that file size is about 3GB). But we couldn't restore our data by installing the new version of the confluence. We try many times to re-install that new version and replace the backup file in the confluence data file. But every time we face a problem. We also try to install confluence on the Linux server but we face problems too. Could you mind helping us how can restore data? how to use 2 zip files (backup file and confluence installing file)?

It's good to know we use confluence for the public benefit and after these errors, we had a lot of problems.

thank you.

1 answer

0 votes

What type of backup have you got?  Is it the XML exports, or the recommended database dump + copy of attachments?

I would never recommend restoring a backup to a different version.  Install a clean version of the old one, get it working with the backup and then upgrade it.

I'm not sure about recommended database dump. But we have a copy of the attachments. We don't have XML exports.

We have a database dump, but we don't know is it recommended database dump or sth else dump! :)

If your database dump is a simple dump as suggested by the docs for your database, then it is the recommended one.

The process when you have that (plus a copy of the attachments), but no backup of your installation is:

  • Create a new empty database to use for this process
  • Install a new Confluence, same version as you had before, but completely clean, do not worry about your old data.  Tell it to use the new empty database, and for "confluence home" give it a new empty directory 
  • Fire it up and get to a point where the single new admin user can wander around it.  One demo space, admin can log in and read/write, looks completely like a totally new installation
  • Stop Confluence server
  • Restore your database dump over the top of the new db
  • Restore the copy of the attachments into <new confluence home>/attachments
  • Start the new install
  • Log in as the admin (use the credentials from the one that failed), and go to admin -> indexing -> full reindex

You now have a restored Confluence ready to try to upgrade again.

thank you.

I did as you said step by step.

  • I created a new empty database
  • Installed a new Confluence, the same version as I had before, and completely clean. Told it to use the new empty database, and for "confluence home" gave it a new empty directory 
  • Fired it up and got to a point where the single new admin user can wander around it.  One demo space, admin can log in and read/write, looks completely like a totally new installation.
  • I stop the Confluence server

But then I couldn't restore my database dump over the top of the new DB. Because I didn't have a dump file. I just had 2 files their name is: "h2db.mv.db" and "h2db.trace.db".

photo_2021-02-23_15-33-17.jpg

I continued your steps without "restore database dump". and finally  I encountered this error:

photo_2021-02-21_22-55-55.jpg

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Confluence Mythbusters: Does Atlassian even use Confluence?

Hi, Confluence collaborators! As part of #Confluence-Collaboratory month, we’ve created a very special Mythsbusters segment, where we're dive into an interesting myth and uncover the truth behind i...

1,705 views 7 32
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you