#!/bin/bash


if [ -z "${1}" ] ; then
        echo "${0} /var/lib/mysql/mysql-bin.002036";
        echo "less /var/lib/mysql/mysql-bin.002036.txt";
        echo
        echo "${0} /var/lib/mysql/mysql-bin.002036 107";
        echo "less /var/lib/mysql/mysql-bin.002036_107.txt";
        exit 1;
else
        if [ -r "${1}" ] ; then
                MASTER_LOG_FILE="${1}"
                BIN_LOG_OUT="${1}"

                if [ -n "${2}" ] ; then
                        READ_MASTER_LOG_POS="${2}"
                        MASTER_LOG_POSITION="-j ${READ_MASTER_LOG_POS}"
                        BIN_LOG_OUT="${1}_${2}"
                fi
        else
                echo "Die BIN-LOG-Datei konnte nicht gelesen bzw. gefunden werden.";
                exit 1;
        fi
fi

# mysqlbinlog --base64-output=DECODE-ROWS -v -j 1013 /var/lib/mysql/mysql-bin.002035 > /tmp/mysql-bin.txt
mysqlbinlog --base64-output=DECODE-ROWS -v ${MASTER_LOG_POSITION} ${MASTER_LOG_FILE} > ${BIN_LOG_OUT}.txt
ls -l ${BIN_LOG_OUT}.txt