#!/bin/sh
TIME=`date '+%d-%R'`
ISODATE=`date '+%F'`
# Create a Dump o MySQL in Home folder
# Simple Dump
mysqldump -umysqlusername -pmysqlpassword databasename -c > /home/miliarum/backup/databasename.sql
# Dump with Daily File Name
#mysqldump -uospite -preadonly atreeflow -c --skip-lock-tables > /home/miliarum/backup/databasename-$ISODATE.sql
DESTINAZIONE_BACKUP=//192.168.0.211/miliarum
DESTINAZIONE_MOUNT=/media/rete
# Create Mount Folder
if [ ! -d $DESTINAZIONE_MOUNT ] # be sure the directory /mnt exists
then
mkdir $DESTINAZIONE_MOUNT
fi
# Mount With Password
#mount -t smbfs -o username=usermaxtor,password=passwordmaxtor //192.168.0.1/miliarum $DESTINAZIONE_MOUNT
# Mount Without Password
mount -t smbfs $DESTINAZIONE_BACKUP $DESTINAZIONE_MOUNT
if [ "$?" = "0" ] ;
then
echo "Mount succesful"
#tar zcvf /media/rete/atreeflow/files.tar.gz /home/atreeflow/files
echo "Coping Files..."
cp -R /home/miliarum/ $DESTINAZIONE_MOUNT
#mysqldump -ukatiaserver -pkatiaserver katiadb -c > $DESTINAZIONE_MOUNT/atreeflow.sql
#ls -lh $DESTINAZIONE_MOUNT/atreeflow > /home/atreeflow/backup-atreeflow.log
else
echo "Mount unsuccessful ($?)"
fi
umount $DESTINAZIONE_MOUNT
Commenti