Zabbix

#!/bin/bash

​

if [ -z "$1" ] || [ -z "$2" ] || [ -z "$3" ] || [ -z "$4" ] || [ -z "$5" ] || [ -z "$6" ]; then

    echo "Usage:

    ./export_data.sh -hhost -Pport -uroot -p<password> <DB name> ZBX_DATA > ../src/data.tmpl

    ./export_data.sh -hhost -Pport -uroot -p<password> <DB name> ZBX_TEMPLATE > ../src/templates.tmpl

    ./export_data.sh -hhost -Pport -uroot -p<password> <DB name> ZBX_DASHBOARD > ../src/dashboards.tmpl

    The script generates data file out of existing MySQL database." && exit 1

fi

mysql_cmd="mysql $1 $2 $3 $4 $5"

dbflag=$6

basedir=`dirname "$0"`

schema=$basedir/../src/schema.tmpl

​

echo "--

-- Copyright (C) 2001-2025 Zabbix SIA

--

-- This program is free software: you can redistribute it and/or modify it under the terms of

-- the GNU Affero General Public License as published by the Free Software Foundation, version 3.

--

-- This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;

-- without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

-- See the GNU Affero General Public License for more details.

--

-- You should have received a copy of the GNU Affero General Public License along with this program.

-- If not, see <https://www.gnu.org/licenses/>.

--

"

​

IFS=$'\n'

for tbl_line in `grep "^TABLE.*${dbflag}" "${schema}"`; do

    tbl_line=${tbl_line#*|}

    table=${tbl_line%%|*}

    tbl_line=${tbl_line#*|}

    primary_key=${tbl_line%%|*}

​

    total_count=`echo "select count(*) from ${table}" | eval ${mysql_cmd} | tail -1`

​

    fields=''

    delim=''

​

    refs=()

    depth=()

​

    for fld_line in `sed -n "/^TABLE|${table}|/,/^$/ p" "${schema}" | grep "^FIELD" | sed 's/[ \t]//g'`; do

        fld_line=${fld_line#*|}     # FIELD

        field=${fld_line%%|*}

        fld_line=${fld_line#*|}     # <field_name>

        field_type=${fld_line%%|*}

        fld_line=${fld_line#*|}     # <field_type>

        default_val=${fld_line%%|*}

        fld_line=${fld_line#*|}     # <default>

        fld_line=${fld_line#*|}     # <not_null>

        flags=${fld_line%%|*}

        fld_line=${fld_line#*|}     # <flags>

        fld_line=${fld_line#*|}     # <index #>

        ref_table=${fld_line%%|*}

        fld_line=${fld_line#*|}     # <ref_table>

        ref_field=${fld_line%%|*}

​

        if [[ "$flags" =~ ZBX_NODATA ]]; then

            if [[ "$field_type" =~ ^t_(shorttext|text|longtext)$ ]]; then

                [[ -n "$default_val" ]] || default_val="''"