Restore backup from unsupported version 6.15.3

[Claude Laflamme]

We recently had an issue with our confluence server and had to reinstall it and restore its content from backups. 

While doing this, we found out that our version 6.15.3 was not supported and not available from download archives.

We went ahead and use the next available version 6.15.4 to restore the server before migrating to latest version available version. 

Result was that the restore process failed (always after reaching 90% with a rollback message). We did try various backups and confluence version and the result was always the same.

We were able to recuperate most of our data by installing version 6.15.4 and then changing the configuration file to connect confluence to the old database. 

The problem we now have is we have lost our attachments. I can see those in the backups we have but don't know if there is a way to connect them back to the actual location (pages) in confluence. Any way to achieve this?

[Srinatha T · Accepted solution]

Hi @Claude Laflamme ,

Welcome to Atlassian community. 

There is a process to achieve this . Follow the steps in the below KB article and check if that helps 

• How-to-restore-multiple-attachments-from-a-file-system-backup-in-confluence 

I hope the above info helps. Have a good day!

Thanks,

Srinath T

[Claude Laflamme]

Thanks Srinatha, I had found this article but missed the hierarchical file system article it refers to. Will be able to rebuild my folder with all that info.

[Srinatha T]

@Claude Laflamme  Yes try the steps. It should help. Have a good day!

[Claude Laflamme]

Hi, 

I created an sql query to generate the mkdir and copy commands for those you would be interested.

with attachments as (

select 
   'ver003/' || right(s.spaceid::text,3)::integer % 250 || '/' || left(right(s.spaceid::text,6),3)::integer % 250 || '/' || s.spaceid || '/' || right(p.contentid::text,3)::integer % 250 || '/' || left(right(p.contentid::text,6),3)::integer % 250 || '/' || p.contentid || '/' || a.contentid as dir,
   'ver003/' || right(s.spaceid::text,3)::integer % 250 || '/' || left(right(s.spaceid::text,6),3)::integer % 250 || '/' || s.spaceid || '/' || right(p.contentid::text,3)::integer % 250 || '/' || left(right(p.contentid::text,6),3)::integer % 250 || '/' || p.contentid || '/' || a.contentid || '/' || a.version as destination,
   a.pageid || '/' || a.contentid || '/' || a.version as source,
   s.spaceid,
   a.pageid,
   a.contentid
from 
   spaces s 
   join content p on p.spaceid = s.spaceid and p.contenttype = 'PAGE'
   join content a on a.pageid = p.contentid and a.contenttype = 'ATTACHMENT'
order by s.spaceid, p.contentid, a.contentid

)

select 'mkdir -p ' || a.dir, 'cp ' || a.source || ' ' || a.destination
from attachments a

[Srinatha T]

Nice work. Thanks for sharing