#!/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"
 
for TABLE in master_pendidikan master_jenis_kelamin master_status_kawin master_bidang master_unit pegawai_master adm_system tempat_lahir ppgb_daftar_lowongan
do
 echo $TABLE
 FILE=$BAK/$TABLE.sql
 $MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS hrd_yayasan $TABLE > $FILE
 $MYSQL -h 202.62.9.142 -u root -psatriopiningit1924 hrd_yayasan < $FILE
done