#! /bin/bash
tgl=`date "+%d%m%Y"`;
#mkdir /home/dms/backup/program/$tgl
mkdir /data/backup/sqldata/$tgl
sqldir=/data/backup/sqldata/$tgl;
#directory="aplikasi-dispenda aplikasi-faktur"
MYSQL=/usr/bin/mysql
MYSQL_USER="root"
MYSQL_PASSWORD="okedeh"
MYSQLDUMP=/usr/bin/mysqldump
databases=`$MYSQL -u$MYSQL_USER -p$MYSQL_PASSWORD -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema|dbrestobl|mysql|performance_schema)"` 

#mysql -u root -pprbn10 dbHotelBjPerdana -e "truncate table db_kamar_hotel";
#mysql -u root -pprbn10 dbHotelBjPerdana < /home/dms/script/MasterKamar.sql


#for folder in $directory;
#do
#v_name=$folder"_"$tgl;
#tar -zcPf /home/backup/program/$tgl/$v_name.tar /home/$folder/
#done

for db in $databases;
do 
$MYSQLDUMP --force --opt --single-transaction --user=$MYSQL_USER -p$MYSQL_PASSWORD --databases $db | gzip > "$sqldir/$db.gz"
done

cd /data/backup/sqldata/
scp -P23 -r $tgl  dms@www.ikc.co.id:/home/backup/sqldata_from_lamongan