Location of images in confluence articles

Question

I need to find out where to find in our Confluence server the location where the images we uploaded in our articles located.

Also, is there a way to change linked images? seems like our images are broken. These are images that came from our previous ticketing/solution system that we already decommissioned, I have the entire folder with all its original images. Its just a matter of changing the pointers to this folder.

Shannon S · Answer

Hello Mark,

Thank you for confirming. The Confluence Drag and Drop plugin referred to in that article is an system add-on, so it should be enabled on your site by default. In the event that it gets disabled, you can run into issues with the attachment not being added properly.

Attachments in Confluence are stored in the attachments directory in the configured home folder in the file system, by default. You can find information about that below.

* Attachment Storage Configuration

Edit: In my previous message, I mentioned how if you were to manually perform the migration, it would require you to modify both the filesystem and the database. By this, I mean the references in the database to the attachments which are then stored in the file system.

It was formerly possible to completely store attachments in the database prior to 5.4, but this has since been deprecated.

The best way to solve this would be to complete the migration again using the method I mentioned. See Migrating Confluence Between Servers for more details.

I hope this helps, but do let me know if you have any further questions or concerns.

Take care,

Shannon

Mark Gesite · Answer

Hi @Shannon S ,

I understand the delay.

The first link you provided is pointing to a non-existing Confluence Drag and Drop plugin, which I don't think we will need as we are already aware of our previous mistake with the copy/paste method.

Regardless of the method, I think it will still take a considerable amount of time to solve this issue, so we are looking for the most efficient way to make it work.

The source editor plug-in tool you suggested shows the codes but doesn't tell us the location of the images in the database:

I've been searching within our Confluence server to find the image database, but I can't find them. If you can help us with that? that will be wonderful.

To answer your question. Yes, we have a backup of our previous "Solutions Center" and its Manage Engine Service Desk Plus MSP by the way. I have looked it up before but you only handle CSV migration which is text-based only.

Regards.

Shannon S · Answer

Hi Mark,

I'm so sorry for the delay, as I've been on holiday for the last few weeks.

Your situation is clear now, thank you for clarifying that. It does sound similar to the following issue:

* When pasting an image into the editor, the image is not attached correctly

Even if you have the original images, Confluence needs to attach them to the page properly and in the database. There's not really a way to do that, short of scripting this and writing to the database yourself, which would take a considerable amount of time.

To answer your question about changing the image pointers, you would need to do a find and replace in the database, similar to the procedure here: How to replace all hard coded links after a base URL change.

The best fix in both cases would be to perform the migration over again, by migrating the space from the decommissioned server to the new one. You would need to be able to bring the decommissioned server back online, which may require a site restoration.

If you do happen to have already created backups of the necessary spaces, then we can restore from those.

Do you have any backups of the old system?

Regards,

Shannon