Ilya D

Backup DB + data

#!/usr/bin/env bash

# Backup Database Moodle (Morning, After noon into files and MidDay to a backup DB inside MySQL)
01 05 * * *  root mysqldump  -udb_user -pdb_user_password -hlocalhost db_name | gzip  > /backup/db_name-`date +\%Y-\%m-\%d-\%H`.sql.gz

# Keep 10 SQL database backups of economy (last 5 backups of economy)
2 2 * * * root find /backup/* -mtime +5 -exec rm {} \;
# Backup files  (Morning, After noon into files and MidDay to a backup DB inside MySQL)

30 5 * * * root  zip -r /backup/files/moodledata`date +\%Y-\%m-\%d-\%H-\%M-\%S`.zip /var/www/moodledata

# Keep 5 instanse backups of moodledata (last 5 backups of davidson-net)
10 2 * * * root find /backup/wpfiles/* -mtime +5 -exec rm {} \;

Kiril

Moodle – Quiz and Questions Attempts Architecture

Moodle - Quiz and Questions Attempts Architecture

Sources:

https://dbdiagram.io/d/5e16edf26ef5ab67de30dee1

https://docs.moodle.org/dev/Quiz_database_structure

https://docs.moodle.org/dev/Question_Engine_2

https://docs.moodle.org/dev/Question_Engine_2:Design

https://docs.moodle.org/dev/Overview_of_the_Moodle_question_engine#Database_tables

Kiril

Moodle – Upgrade version with Git from 3.3-3.*

First Step: 

 git remote add upstream https://github.com/moodle/moodle.git

Second Step: 

vim update.sh 
#!/bin/bash
git fetch upstream
for BRANCH in MOODLE_{31..37}_STABLE master;
do
git push origin refs/remotes/upstream/$BRANCH:refs/heads/$BRANCH
done

Source: https://docs.moodle.org/dev/Git_for_developers

Kiril

Moodle – Quiz report teacheroverview

Quiz dashboard (report) displaying charts of student’s progress and grades that enable filtering of student’s progress table for actions like messaging and grouping.