...
First get the Derby distribution, which includes the ij command-line utility.
| Code Block |
|---|
root@usw1-l-jira01:~# wget 'http://archive.apache.org/dist/db/derby/db-derby-10.9.1.0/db-derby-10.9.1.0-bin.tar.gz' root@usw1-l-jira01:~# tar zxvf db-derby-10.9.1.0-bin.tar.gz root@usw1-l-jira01:~# export PATH+=$HOME/db-derby-10.9.1.0-bin/bin root@usw1-l-jira01:~# which ij # /home/redradish/db-derby-10.9.1.0-bin/bin/ij |
...
So first we must make an offline copy of the Structure database;
| Code Block |
|---|
root@usw1-l-jira01:~# cp -ra /var/atlassian/application-data/jira/current/structure ~/structure_offline |
...
ij is as primitive and ugly as you'd expect. There is exactly one way to invoke it: passing in a properties file for connection parameters, and a SQL file to run:
| Code Block |
|---|
ij> root@usw1-l-jira01:~# ij --help
Usage: java org.apache.derby.tools.ij [-p propertyfile] [inputfile] |
...