Ilya D

Import DB with progress bar

pv sqlfile.sql | mysql -uxxx -pxxxx dbname
pv sqlfile.sql.gz | gunzip | sudo mysql dnname
mysqldump -hxxx -uxxx -p dbname | pv -W > dump.sqlmysqldump -hxxx -uxxx -p dbname | pv -W > dump.sql
cat dbdump.gz | gzip -d | mysql --password=root -v | time dd of=/dev/null status=progress

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

Virtual Box – Shared directory on global network (windows, mac, ubuntu)

  1. How to run ubuntu server on virtual box (Windows, Mac, Ubuntu)
  2. How to add local network with Ubuntu Virtual Box Instance.
  3. How to share directory with Ubuntu Virtual Box Instance.
Kiril

Moodle – Mind Map Plugin RTL Support

 This Moodle plugin will allow to use Mind map service.

Test token to the service: eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJkYXRhIjp7ImVtYWlsIjoiZGV2bGlvbkBnbWFpbC5jb20iLCJmaXJzdF9uYW1lIjoiZGV2bGlvbiIsImxhc3RfbmFtZSI6InRlc3QifSwiaWF0IjoxNTY1MjE3MDY5LCJleHAiOjE5MjUyMTcwNjl9.hFzXOMRVVhVtOTdpX1I7UZRwaoQljQSlnVCFSfkDiU8

Test Url: https://dev.mindmaap.com/

Set Mind Map token at plugin settings interface: