Ekspor Impor mysql satu hari atau dalam rentang

 $ ./make_mysqldump_auto.sh "2025-07-23" "Asia/Makassar"

 
# Backup 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

$ ./make_mysqldump_auto.sh "2025-07-24" "2025-07-31" "Asia/Makassar"
# Backup 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