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

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:

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 – Backup and restore DB Orders

Export DB DUMP with ignore table mdl_logstore_standard_log

mysqldump moodle --ignore-table=mdl_logstore_standard_log | gzip > /backup/moodledb-date +\%Y-\%m-\%d-\%H-\%M-\%S.sql.gz 

Import DB DUMP

gunzip < moodledb_dump.sql.gz | mysql -u moodle -p moodle

import DB dump without log table

gzip -cd "./mydb.sql.gz" | sed -r '/INSERT INTO `(log_table_1|log_table_2|log_table_3|log_table_4)`/d' | gzip > "./mydb2.sql.gz"

Kiril

Moodle – Filter Team Work tutorial

This tutorial will describe how to use Team Work filter plugin in Moodle environment. Please, follow the instructions: 

Download plugin with link: https://github.com/PeTeL-Weizmann/moodle-filter_teamwork

Kiril

Moodle -Query to change all users details

UPDATE mdl_user 
SET
username=CONCAT('username',mdl_user.id),
phone1=CONCAT('11111',mdl_user.id),
phone2=CONCAT('11111',mdl_user.id),
firstname=CONCAT('Name',mdl_user.id),
lastname=CONCAT('Last',mdl_user.id),
email=CONCAT('email',mdl_user.id,'@test.com'),
idnumber= CONCAT('1000',mdl_user.id,'2000')
WHERE id>=7