Ekspor Impor mysql data dalam rentang hari

 Jalankan

./make_mysqldump_range.sh "2025-07-24" "2025-07-31" "Asia/Makassar"

# Untuk rentang 2025-07-24 s/d 2025-07-31 (zona Asia/Makassar)

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

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

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