summaryrefslogtreecommitdiffstats
path: root/test/docker/docker-entrypoint-initdb.d/icinga/dump.sh
blob: 54f91a9741b2016b1ecb41f2bd4f4104f7223fd7 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
#!/bin/bash

set -e

CONFIG="$(docker-compose config)"
MYSQL_ROOT_PASSWORD="$(echo "$CONFIG" | grep MYSQL_ROOT_PASSWORD | cut -d: -f2 | sed -e 's/^[[:space:]]*//' -e 's/[[:space:]]*$//')"

set -x

docker exec -i \
    "$(docker-compose ps -q db)" \
    mysqldump -p"${MYSQL_ROOT_PASSWORD}" --no-create-info icinga \
    icinga_instances icinga_programstatus icinga_objects \
    icinga_hosts icinga_hoststatus \
    icinga_services icinga_servicestatus \
    icinga_hostgroups icinga_hostgroup_members \
    > ido-data.sql

docker exec -i \
    "$(docker-compose ps -q db)" \
    mysqldump -p"${MYSQL_ROOT_PASSWORD}" icinga \
    > full.sql