Find out the domain's cname name

Use dig -t all domain_name

How to compress folder/file and split into certain sizes

To compress folder/file and then split it automatically with certain sizes, the command is
tar -cvpj 'directory/name'/ | split -d -b 2000m - /name/of/archive.tar.bz2.

To combine them again, just use
cat *.bz2* | (cd path-to-destination; tar jxv)

Linux moving or deleting large files getting Argument List Too Long

When you try to move or delete a lot of files in linux cli and getting Argument List Too Long, you can try to filter it by
find . -type f -name "*.xml" | xargs -i mv {}

Mysql Export and Import from select statement

To export into a csv file from a select statement in mysql, the command is

SELECT * INTO OUTFILE 'data.txt'
FIELDS TERMINATED BY ','
FROM table2;

To read the comma-delimited file back in, the correct statement would be:

LOAD DATA INFILE 'data.txt' INTO TABLE table2
FIELDS TERMINATED BY ',';

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)