In MySQL, the tmpdir path is mainly used for disk-based sorts (if the sort_buffer_size is not enough) and disk-based temp tables.

You can configure a slave with tmpdir=/dev/shm

$ # As of March 2009, the latest version was 3.6.11.
$ wget www.sqlite.org
$ tar xzf sqlite-amalgamation-3.6.11.tar.gz
$ cd sqlite-3.6.11
$ ./configure && make
$ sudo make install

It is very interesting to know about how to extract statements from binlogs.

mysqlbinlog --start-datetime="`date +%Y-%m-%d' '%H:00:00 -d\"1 hour ago\"`" --stop-datetime="`date +%Y-%m-%d'
'%H:00:00`" mysql-bin.* | awk '/tbl_company/,/;/' | replace tbl_company mydb.tbl_company | mysql -h 172.29.0.0 -uroot -pPasswd mydb

I have not tested it, but guess it should work as expected.

$ cat salaries
Yvette van der Hoff 100000
Sarack Abama 400000
Bernie Madoff 0
John Q. Public 20000

$ awk '{print $NF, $0}' salaries | sort -nr -k1,1 | cut -d" " -f2-
Sarack Abama 400000
Yvette van der Hoff 100000
John Q. Public 20000
Bernie Madoff 0

$ awk -F '\t' -v 'OFS=\t' '{print $4, $3, $5, $2, $1}' data.txt
POP. COUNTY GOVT. CITY STATE
123 Gila Mayor Ely AZ
345 Lolo Sheriff Alma CA
22 El Paso Bubba Leroy TX

When there is maintenance work to be carried on the database server, you can simply skip networking so that no connection from any other server from the network will be accepted.
Simply enter the following in /etc/my.cnf:

[mysqld]
# Prevent network access to MySQL.
skip-networking

sqlite> .mode list
sqlite> .separator |
sqlite> .output test_file_1.txt
sqlite> select * from tbl1;
sqlite> .exit
$ cat test_file_1.txt
hello|10
goodbye|20
$

Sick of your computer speaker beeping like a demented Morse code machine whenever you type something wrongly? Teach it the sound of silence: run the command
setterm -blength 0
to mute the alarm bell no matter what kind of terminal you're typing into.
If you want it to happen every time you start a terminal, just add the command to your .bash_profile file.

validdate.sh script will look like this...

#!/bin/sh
userdate=$1
date -d $userdate &> /dev/null
if [ $? -ne 0 ] ; then
echo You entered an invalid date, $userdate
else
echo The date $userdate is valid
fi

# sh validdate.sh 2009-33-44
You entered an invalid date, 2009-33-44

generate a list of IP address along with the number of times each was encountered and sort

cat access_log | awk '{print $1}' | sort | uniq -c | sort -nr

#!/bin/sh
tar czvf $1.$(date +%Y%m%d-%H%M%S).tgz $1
exit $?

The arc script accepts a single file or directory name as a parameter and creates a compressed archive file with the current date embedded into the resulting archive file's name.