#!/bin/bash
### MySQL Server Login Info ###
MUSER="root"
MPASS="satriopiningit1924"
MHOST="localhost"
MYSQL="$(which mysql)"
MYSQLDUMP="$(which mysqldump)"
GZIP="$(which gzip)"
### FTP SERVER Login info ###
FTPU="FTP-SERVER-USER-NAME"
FTPP="FTP-SERVER-PASSWORD"
FTPS="FTP-SERVER-IP-ADDRESS"
NOW=$(date +"%Y%m%d")
BAK="/var/www/backups_29/ppgb"
 
 TABLE="ppgb_daftar_pelamar"
 FILE=$BAK/$TABLE.sql
 $MYSQLDUMP -h 192.168.222.11 -u root -ps3j4t11924 hrd_yayasan $TABLE > $FILE
 $MYSQL -u $MUSER -h $MHOST -p$MPASS hrd_yayasan < $FILE

 TABLE="tb_doc"
 FILE=$BAK/$TABLE.sql
 $MYSQLDUMP -h 192.168.222.11 -u root -ps3j4t11924 yayasan_ppgb $TABLE > $FILE
 $MYSQL -u $MUSER -h $MHOST -p$MPASS yayasan_ppgb < $FILE