Re: Moodle SqlDump is 2GB, but MySQL database is only a few Mb... ??
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