#!/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/ujian"
 
for TABLE in mata_pelajaran ujian_header ujian_header_kelas ujian_kelas ujian_kunci_jawaban ujian_pengajar ujian_pilihan_jawaban ujian_soal 
do
# echo $TABLE
 FILE=$BAK/$TABLE.sql
 echo $FILE
 $MYSQLDUMP -u $MUSER -h $MHOST -p$MPASS ppgb_ujian $TABLE > $FILE
 $MYSQL -h 202.62.9.142 -u root -psatriopiningit1924 ppgb_ujian < $FILE
done