Moodle in English

OR, one could add a line to the backup script just before the mysqldump:

mysql -u root -p'' -e "use moodle;truncate mdl_logstore_standard_log;"

turncates the mdl_logstore_standard_log table ... leaving columns/structure/table in the DB - but no data.

'Normal' sqldump:
-rw-r--r-- 1 root root 1161226781 Jun 18 18:34 /home/backup/moodle-20180618183434.sql

Dump with truncated
-rw-r--r-- 1 root root 1039631789 Jun 20 05:57 /home/backup/moodle-trunlog-2018062055648.sql

In the above example from 'medium' sized/used site, sql dump is approx 13M smaller and one doesn't have to restore two files, just one.

'spirit of sharing', Ken