How do I attach attachments to Jira with a new sql?

Question

Hi everyone

I'm going to make a switch between SQL on jira

I want to do it in several parts and I would be happy for your help
1. Creating a Backup from Jira
2. Create a snapshot on a Jira server
3. External backup to the Home directory
4. Connect Jira to the new SQL using dbconfig
5. Perform Restore on Jira (import data)

The problem when doing Backup & Restore is not attaching the attachments

How do I attach attachments to Jira with a new sql?

*** We do not have a DBA man we want to attach the attachments from Jira

Nic Brough -Adaptavist- · Answer

Attachments are not kept in the database! They're simple copies of the files that were uploaded, renamed so Jira can version them, but just plain copies. They live on the file system of the server, under /attachments, or /shared/attachments depending on how your server was originally set up. A backup is a simple recursive copy of that attachments directory - the copy I take of my little home Jira is simply "cp -R /data/jira-home/shared/attachments /data/backup/attachments" (different disks are mounted there)