Take backup without bulky data for staging upgrade process

[Jagdish Ahir]

HI.

I am creating staging server from production, It will be used to upgrade jira version also we will use it for QA test of jira functionalities.
I like to take minimum backup which can be used for jira functionality testing . 

How can i take such minimum backup of database and jira-data excluding bulky stuff from it ? 

from jira-data backup attachments and other bulky stuff can be excluded

from db-backup jira issues, work logs other bulky stuff can be excluded

[Nic Brough -Adaptavist-]

Attachments are not stored in the database, and there is nothing you can do to reduce the size of a database without very very careful deletion of data before you take the dump.  Put one thing out of place and you could render the database unusable and unrecoverable.  So I strongly recommend forgetting that idea.

On the file system, yes, drop the log files and you can ignore the attachments directory in the home directory - Jira will work fine without it, except that you won't be able to test downloading or previewing existing attachments, and some images (including people's profiles) will come through as broken image indicators.

[Jagdish Ahir]

Thank you for answer