Page History
...
The Operation Script can be executed from a JS7 job to create database backups backup or to export the JOC Cockpit database at a regular basis.
Download
...
| Code Block | ||||||
|---|---|---|---|---|---|---|
| ||||||
# export database to .zip archive file that holds the script.sql file
./operate-h2.sh export --url="/var/sos-berlin.com/js7/joc/resources/joc/h2/joc" --user=joc --file=/tmp/database-export.zip --zip
# export database to .sql text file with up to 3 versions
./operate-h2.sh export --url="/var/sos-berlin.com/js7/joc/resources/joc/h2/joc" --user=joc --file=/tmp/database-export.sql --file-versions=3
# export database from a docker container to a .zip archive stored on a volume
docker exec -ti js7-saas-2-7-2 /bin/bash \
/opt/sos-berlin.com/js7/script/operate-h2.sh export \
--classpath=/var/sos-berlin.com/js7/joc/lib/ext/joc/h2-2.3.232.jar \
--url="/var/sos-berlin.com/js7/joc/resources/joc/h2/joc;AUTO_SERVER=TRUE" \
--user=joc \
--file=/var/sos-berlin.com/js7/joc/resources/joc/database-export.zip \
--file-versions=3 --zip |
...
Overview
Content Tools