michael-milette

# Script: update-moodle.sh
# From: https://gist.github.com/
# This script will update Moodle within the same major version (example: 3.6.1 to 3.6.3).
# The nice thing about this simple approach is that it won't affect your plugins.
# Assumes you used "git clone" to create and install your instance of Moodle. If you did not, don't use this script!
#
# Copyright TNG Consulting Inc.
# Author: Michael Milette - <www.tngconsulting.ca>
# Release: 1.0 Alpha - 2019-04-16
#

michael-milette

Cheatsheet: Tips and Tricks for using Git

Table of Contents

• Lots of Git Tips
• Repositories
• Stash
• Commits
• Tags
• Branches

michael-milette

Cheatsheet: MySQL vs PostgreSQL commands

Description	MySQL	PostgreSQL
Connect to database server	mysql -u username -p	psql -U username
Import a database	mysql -u username -p databaseName < data.sql	psql -U username databaseName < data.sql
List databases	SHOW databases;	\l
Use/Connect to datbase with name	USE databaseName;	\c databaseName
List tables	SHOW tables;	\dt
List users	SELECT user, host FROM mysql.user;	\du

michael-milette

Git

• See git cheatsheet.

Copy/Sync Files and Directories

• rsync -a --delete --compress --omit-dir-times --omit-link-times --no-g --no-perms [user@server:]source [user@server:]target
• scp -Crqp [user@server:]source [user@server:]target

Terminal

• ssh username@server
• tmux (Ctrl+b ":set -g status off" to disable status bar with clock)

michael-milette

OS="$(uname -s)"
case "${OS}" in
    Linux*)  OS=Linux;;
    Darwin*) OS=Mac;;
    CYGWIN*) OS=Cygwin;;
    MINGW*)  OS=MinGw;;
    *)  if [[ -n "$IS_WSL" || -n "$WSL_DISTRO_NAME" ]]; then
            OS="UNKNOWN:${OS}"
        else
            # WSL2