#!/bin/bash
### MySQL Server Login Info ###
MUSER="root"
MPASS="satriopiningit1924"
MHOST="202.62.9.142"
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 ujian_data_jawaban_siswa 
do
 echo $TABLE
 FILE=$BAK/$TABLE.sql
 $MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS ppgb_ujian $TABLE > $FILE
 $MYSQL -h localhost -u root -psatriopiningit1924 ppgb_ujian < $FILE
done