Recover site from database

Question

Recently I lost my Confluence VM, it was accidentally rolled back to an earlier snapshot where Confluence had yet to be installed.

The database however, PostgreSQL in my case, was--is running on a different server and is basically unscathed.

I have done this only once a long time ago but I remember that when I selected a database previously used, even if there was no actual content on it, the setup assistant would clear out the database: I needed an actual backup in addition to the database.

Is there some way that the database can be imported into a new instance at least? Or, do the newer versions have support for this? The version I was using wasn't very old. It was most likely 6.12--if the installer in the central downloads network share was used.

Thanks!

vitanetworks · Answer

Thanks for answering! It's a nice ending to my day.

I finished setting the server up earlier today though, complete with automated backups, certs and reverse proxies, DNS, this time on another OS.

Luckily enough, that is if you can pass laziness as luckiness, even though the license has been already renewed for the first year and it's halfway to the second year; it was still on staging period (that's code for almost empty) and it wasn't that big of a loss specially because after having finished setting it all up, I took an iPad I rarely use to read some docu on Atlassian Crowd and I saw the Confluence app, opened it just to sign it in quickly to the new server and to my surprise the app still had the session from the trashed server going on.

I put it into airplane mode before it tried connecting bc the domain name and the directory are the same and the new Confluence could accept the login and sync back emptiness to it. I then manually copied whatever pages were available and paste them in another app, export is not an option in Confluence. #FeatureRequest

Got some of the lengthiest pages back! 😁I probably have all the assets too, I designed them myself: I'm not a graphic designer...or a webmaster for that matter, so those two hours spent per image, designing/learning/obsessing… I made sure to be backup up AF ! 😄

Thanks again!

Andrew_g4chs4 · Answer

Hi @vitanetworks ,

Look here https://confluence.atlassian.com/doc/migrating-confluence-between-servers-184150.html

But I suppose without folders it may lost attachment files.

B.R.