March 13, 2010

Rendering MySQL query results in vertical format

Database,

Easily reviewing SELECT query results in a shell window can be particularly difficult when a table consists of numerous columns. Remedying this inconvenience is easily done by appending the \G...

Read more
March 13, 2010

Disable the Error Beep in MySQL

Linux General,

To temporarily disable the beep, pass --no-beep along when logging into the server: %>mysql -u root -p --no-beep To permanently disable this annoyance, add no-beep to the [client] section of...

Read more
March 13, 2010

How FreeBSD identifies hard disks and drives

Linux General,

FreeBSD identifies various types of hard disks and drives with following naming convention ad ATAPI (IDE) disk da SCSI direct access disk acd ATAPI (IDE) CDROM cd SCSI CDROM fd...

Read more
March 13, 2010

Create strong passwords in Unix

Linux/Windows Support,

openssl command helps in creating strong passwords for user accounts, email addresses, web forms etc. openssl rand 12 -base64 The above command will create a random base 64 encoding string...

Read more
March 13, 2010

Attach words horizontally using shell scripting

Linux General,

To paste contents of two files horizontally, paste command can be used. Create a file called cmd with the following content: # cat cmd /usr/sbin/useradd /usr/sbin/useradd /usr/sbin/useradd Create another file...

Read more
March 13, 2010

Find empty files in Linux

Linux General,

find command provides two options to detect empty files $ find . -size 0c or $ find . -empty To find and delete all the empty files under the current...

Read more
March 13, 2010

Capture top command output in a file

Linux General,

Capture top command output in a file The output of top command can be captured as follows top -b -n1 > /tmp/top1.txt This will run top command once and write...

Read more
January 29, 2010

Display Info about FreeBSD system

Linux/Windows Support,

Display Info about FreeBSD system 1) Determining the Hardware Type/platform: # uname -m 2) Determining machine processor architecture: # uname -p 3) Determining FreeBSD release level: # uname -r 4)...

Read more
January 29, 2010

Difference between grep and egrep

Linux General,

Difference between grep and egrep egrep is extended grep which includes additional regular expression metacharacters like ?, +, () and | Eg: egrep "(People|sense)" values.txt This command searches for patterns...

Read more
January 23, 2010

Can’t connect to Plesk SQL Server (after updating Plesk admin password)

Linux/Windows Support,

Can't connect to Plesk SQL Server (after updating Plesk admin password) Jet engine is configured as Plesk Database Provider by default and Plesk SQL (MySql) service is set to disabled....

Read more