Moodle sort courses by name did not work

When you try to sort courses in Moodle and the order is not really working, it means that your sortorder has reach the max number.

To fix it, simply go to the mysql and apply this command to the database
mysql> UPDATE mdl_course SET sortorder = 1000;

This will reset all courses sortorder and simply run it again to resort your courses.

Moodle backup error with fatal memory issue

To avoid this memory issue, increase the memory site on the config.php
Add this line
$CFG->extramemorylimit = '4096M';

Log out from the moodle and close the browser. Then open the page again and log in.
If you still run into the issue, increase the memory limit to bigger value. Once you are done, be sure to remove the line.

Import csv into mysql direct

load data local infile 'uniq.csv' into table tblUniq
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
(uniqName, uniqCity, uniqComments)

How to use screen in cli

To start a new screen session, simply type the word "screen" and hit enter. It is preferred that you name your screen session, by instead using "screen -t name".

To "detach" from a screen session, type "Control+A", then "D".

To terminate a screen session, type "exit" and hit enter.

To list currently running screen sessions, type "screen -ls" and hit enter.

To "reattach" a screen session, type "screen -r [name of socket]" and hit enter.
"[name of socket]" is one of the sockets listed from the "screen -ls" command.

To scroll back through console output within a screen session: ctrl-a (release) then type [ Use the up and down arrows. To escape this mode (copy mode) hit esc

Showing tables only in mysql

To show only tables and dump to a txt, use the command
# mysqlshow database_name > export.txt

Quick shortcut for moodle in config.php

$CFG->enablestats = false; to disable statistics

Quick shortcut for moodle in config.php

$CFG->enablestats = false;   //to disable statistics
$CFG->themedir = $CFG->dataroot.'/theme';  //for adding theme dir

Installing Office2007 with protected windows files error

If you run into error while installing Office2007 with description protected windows files problem, then here is the fix.

Copy fpault.dll file on the original xp cd,
hiding in I386\FP40EXT.CAB

to c:\program files\common files\microsoft shared\web server extensions\40\bin

ls command

Options:

-l list files one line at a time
-A lists all the contents of a directory except for current directory and parent directory
-B ignore backups
-c sort by change time
-d lists file and directory names without contents
-e lists all times in full
-f list without sorting
-k list file size in kilobytes
-l list files in long format
-L list files by symbolic link
-m list files horizontally separate by commas
-r sort files in reverse order
-R list files recursively
-S list files by size, biggest first
-u sort files by the last time they were accessed
-x print in columns, sorted horizontally
-X sort files alphabetically by file extension

Sort directory in linux

To sort directory based on size, here is the command

du -hs * | sort +0n

To view only the Gb,

du -hs * | sort +0n | grep Gb

Truncate all tables in SQL

Here is how to truncate all tables

EXEC [sp_MSforeachtable] @command1="TRUNCATE TABLE ?"

How to find files and move the files to folder in Linux

locate *.zip | grep backup | grep accountname | xargs -t -i mv {} /home/accountname/dump/

This will find all the zip files with the name consist of backup and accountname and then move them to a dump folder.