• Replace <Jira_home> on the samples below with the full path to your Jira home location;
• Move the content of <Jira_home>/data/attachments to the new location, for instance, under /Users/imurakami/newloc/

cd <JIRA_HOME>/data/attachments
mv * /Users/imurakami/newloc/

• Run the below command on the system's command line.

ln -s /path/to/file /path/to/symlink

On our sample:
sudo ln -s ~/newloc/ <Jira_home>/data/attachments

• Now, inside <JIRA_HOME>/data folder, instead of seeing the folder attachments, you will only see the symbolic link to the new location. There should not have an attachments folder under <jira_home>/data otherwise system will find the existing attachments directory first and not the attachments symlink. 

• Adjust the owner, group, and required permissions to allow the user used to start Jira to access the location.

cd <Jira_home>/data
chmod -R 755 newloc
sudo chown -R jira *
sudo chgrp -R jira *

cd /Users/imurakami
chmod -R 755 newloc
sudo chown -R jira newloc
sudo chgrp -R jira newloc

Run the below command on the system's command line.

mklink /J C:\path\to\symlink E:\path\to\file

1. Shutdown JIRA.

2. Run the following SQL queries to change the directory:

   UPDATE propertystring
   SET propertyvalue='/path/to/attachments' 
   WHERE id IN (
       SELECT id FROM propertyentry WHERE property_key = 'jira.path.attachments'
   );
   

   Replace /path/to/attachments with the actual path where you want to have attachments saved. Make sure the user that runs JIRA has read and write permissions on the chosen folder.

   UPDATE propertynumber
   SET propertyvalue = 0
   WHERE id IN (
       SELECT id FROM propertyentry WHERE property_key = 'jira.path.attachments.use.default.directory'
   );

   UPDATE propertynumber
   SET propertyvalue = 1
   WHERE id IN (
       SELECT id FROM propertyentry WHERE property_key = 'jira.option.allowattachments'
   );

   The above queries have been composed and validated on a PostgreSQL database and may need changes to its syntax for other DBMS.

3. Start JIRA;