#!/bin/bash
PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin

FILESERVER_IP="192.168.x.x"
FILESERVER_USER="user"
FILESERVER_PASS="pass"
FILESERVER_FOLDER="share"
MOUNTPOINT=/mnt
MYSQL_PASS='root'
NOW=`date +"%Y-%m-%d_%H%M"`
DIR=$MOUNTPOINT/$NOW

umount $MOUNTPOINT >/dev/null 2>&1
mount //$FILESERVER_IP/$FILESERVER_FOLDER -t cifs -o username="$FILESERVER_USER",password="$FILESERVER_PASS" $MOUNTPOINT &&
mkdir $DIR


mysqldump webfa -u root -p$MYSQL_PASS --add-drop-table --add-drop-trigger --disable-keys | gzip -c9 > $DIR/webfa_$NOW.sql.gz
mysqldump weben -u root -p$MYSQL_PASS --add-drop-table --add-drop-trigger --disable-keys | gzip -c9 > $DIR/weben_$NOW.sql.gz
mysqldump mazagent -u root -p$MYSQL_PASS --add-drop-table --add-drop-trigger --disable-keys --routines --triggers --events | gzip -c9 > $DIR/mazagent_$NOW.sql.gz
mysqldump mazweb -u root -p$MYSQL_PASS --add-drop-table --add-drop-trigger --disable-keys | gzip -c9 > $DIR/mazweb_$NOW.sql.gz
mysqldump --all-databases -u root -p$MYSQL_PASS --add-drop-table --add-drop-trigger --disable-keys --routines --triggers --events | gzip -c9 > $DIR/all_$NOW.sql.gz

umount $MOUNTPOINT