#!/bin/bash

db_host='localhost'
db_user='user'
db_password='password'
databases='mstl'
tmp_dir='/home/tmp'
back_dir='/backup/mstl'
work_dir='/home/mstl/public_html'
backup_name='crm-loc'
current_date=$(date +%d-%m-%Y)
marker='/backup/do_not_remove_this_file'

# Check on tmp exist
if ! [ -d ${tmp_dir} ];
    then
        mkdir -p ${tmp_dir}
        # create mysql dump
        mysqldump --host="$db_host" --user="$db_user" --password="$db_password" --databases ${databases[@]} > ${tmp_dir}/${backup_name}_dump-${current_date}.sql
        mysql_dump=${tmp_dir}/${backup_name}_dump-${current_date}.sql
        # create files archive
        tar -cv ${tmp_dir}/${backup_name}_${current_date}_files.tar ${work_dir}
        files_without_sql=${tmp_dir}/${backup_name}_${current_date}_files.tar
        # create of common archive file
        tar -cjf ${tmp_dir}/${backup_name}_${current_date}_full.tar.bz2 ${mysql_dump} ${files_without_sql}
        full_archive=${tmp_dir}/${backup_name}_${current_date}_full.tar.bz2
        mv ${full_archive} ${back_dir} & rm ${files_without_sql} & rm ${full_archive} $ rmdir ${tmp_dir}
    else
        echo 'Tmp exist!'
        # Check on nfs mount.
        if [ -f ${marker} ];
            then
                echo 'marker found and mount point is correct!'
                # create mysql dump
                mysqldump --host="$db_host" --user="$db_user" --password="$db_password" --databases ${databases[@]} > ${tmp_dir}/${backup_name}_dump-${current_date}.sql
                mysql_dump=${tmp_dir}/${backup_name}_dump-${current_date}.sql
                # create files archive
                tar -cv ${tmp_dir}/${backup_name}_${current_date}_files.tar ${work_dir}
                files_without_sql=${tmp_dir}/${backup_name}_${current_date}_files.tar
                # create of common archive file
                tar -cjf ${tmp_dir}/${backup_name}_${current_date}_full.tar.bz2 ${mysql_dump} ${files_without_sql}
                #tar -cjf ${tmp_dir}/${backup_name}_${current_date}_full.tar.bz2 ${tmp_dir}/${backup_name}_dump-${current_date}.sql ${tmp_dir}/${backup_name}_${current_date}_files.tar
                full_archive=${tmp_dir}/${backup_name}_${current_date}_full.tar.bz2
                mv ${full_archive} ${back_dir} & rm ${files_without_sql} & rm ${full_archive} $ rmdir ${tmp_dir}
            else
                echo ${current_date} 'marker do not found and mount point does not correct!' >> backup_error.log
        fi
fi