Hi team.
Hope everybody is doing great.
I'm not sure if I am missing anything regarding backing up a Connections deployment.
We have a Full Blown Connections V7 deployment (7 severs), including DB2 server, Docs, Converter, and so on.
Files that are stored by users either directly on Files app or through Community are not directly stored at OS level.
This deployment is on Virtual Machines, all running on RHEL 7.9.
In case of accidental File / Folder deletion, the only way of recovering such files/folders is restoring the whole infrastructure.
Is there any suggestion, best practice, setting, backup solution, plugin available in order to granularly backup Connections, in particular Files, so we could have granular File-level restore capability?
The goal is to be able to retrieve a single (or a group of files or folders) instead of the whole server infrastructure.
I'll go further asking also about the same approach for a containerized deployment.
Thank you very much in advance for your help on this matter.
Regards,
Elvis.
Community or file owners should be able to find deleted files in Trash folders (community or personal). If this is not sufficient, you can locate all files in your backup of the files/uploads directory on WAS but you have to get their UUIDs first - for example via FILES database
Hi.
Thank you very much for your prompt response.
Just to double check:
Are files stored in uploads directory without any transformation/encryption/change other than a simple rename and that new name is the UUID in the database?
Could you please point me out on how to retrieve those names from the database?
Regards,
Elvis
Hi Elvis,
We can help with specifics via a support case. Please log and we will provide additional details.
Thank you,
Michael Montani
HCL Support
Hi
If you know the id you could use https://help.hcltechsw.com/connections/v7/admin/admin/t_admin_files_find_file_location.html to get the location.
The files.media table contains the list of files, files.collection the list of folders and files.collection_to_media, which files belongs in which folder.
You could export this scheduled as csv..