Devlion – Devlion

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

LINUX – Mount disk with SFTP to Windows

#yum install sshfs or apt intstall sshfs

#mount
mkdir /disk
sshfs user@IP:/path /disk

#unmount
fusermount -u /disk

#mount with password
sshfs -o password_stdin  user@IP:/ /disk <<< 'your password'

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

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

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:

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

Moodle – How to enable VPL with Java Unit test

This video will explain how to enable VPL with JAVA libraries on Moodle 3.6 (in Hebrew)

Moodle – Course Format Picture Link

Course format plugin Picture Link was developed for Davidson Institute to allow to the teachers locate activities on background image.

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"

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

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