Ekspor Impor data mysql per hari

 jalankan di terminal ubuntu, ubah tanggal

./make_mysqldump_day.sh 2025-07-24 Asia/Makassar

########################
########################

# Untuk tanggal 2025-07-23 (zona Asia/Makassar)

1) suratizinguru
mysqldump -u root -p --no-create-info --skip-add-locks --skip-comments \
--where="waktuinput >= 1753200000 AND waktuinput <= 1753286399" \
moodle2 mdl_local_jurnalmengajar_suratizinguru > /var/backup/suratizinguru_2307.sql

============
2) suratizin
mysqldump -u root -p --no-create-info --skip-add-locks --skip-comments \
--where="timecreated >= 1753200000 AND timecreated <= 1753286399" \
moodle2 mdl_local_jurnalmengajar_suratizin > /var/backup/suratizin_2307.sql

============
3) jurnalmengajar
mysqldump -u root -p --no-create-info --skip-add-locks --skip-comments \
--where="timecreated >= 1753200000 AND timecreated <= 1753286399" \
moodle2 mdl_local_jurnalmengajar > /var/backup/jurnal_2307.sql

######## CEK #########
date -d @1753286399
######################

======================
kirim ke server guru

scp /var/backup/suratizinguru_2307.sql root@36.90.102.233:/var/backup/
scp /var/backup/suratizin_2307.sql root@36.90.102.233:/var/backup/
scp /var/backup/jurnal_2307.sql root@36.90.102.233:/var/backup/

=========================
jalankan di server guru
mysql -u root -p moodle2 < /var/backup/suratizinguru_2307.sql
mysql -u root -p moodle2 < /var/backup/suratizin_2307.sql
mysql -u root -p moodle2 < /var/backup/jurnal_2307.sql