Archive for the 'Command Line' Category

Database Data to Download Variables

Gets data from a MySql database, splits the data into separate columns, then uses one column in a URL to download something – and uses other column to name the file thats downloaded

for i in $(mysql -u root Project_Madapp -sNe 'SELECT CONCAT(id,",",name) AS yo FROM City WHERE type="actual"'); do parts=(${i//,/ }); wget -O "${parts[1]}.csv" "http://localhost/student_allocation_csv.php?format=csv&city_id=${parts[0]}"; done

Search Wikipedia from Command Line

Get the intro paragraph of any wikipedia article using this trick…

dig +short txt "<keyword>".wp.dg.cx

Encrypt/Decrypt files using GPG

Encrypt/Decript files in linux


#Encypt...
gpg -c <Source File>

#Decrypt...
gpg <Encrypted File>

Compress the Big Files

Compress the big image files


for i in $(find . -size +1M); do convert -resize 40% -quality 80 $i $i; done

Iterate a Text File in Bash

This is how you iterate thru a text file outputting a line at a time in Bash shell scripting.


IFS=$'\n'; for i in $(cat FILE.TXT); do echo "$i"; done

Convert RAW files to JPEG

Convert RAW files to JPEG in batch. Convert all files in a folder using a command. For this to work, first you must have ‘ufraw’ package installed. sudo apt-get install ufraw or sudo yum install ufraw depending on your OS.


find . -type f -name "*.CR2" -exec ufraw-batch --out-type=jpeg '{}' \;

Send One Line From a Text File as as SMS Every 10 Mins

This command will send a line from a given text file one every 10 mins as an SMS to a given number.


i=1; while [ 1 ]; do sms INSERT_PHONE_NUMBER "$(cat "/home/binnyva/sms.txt"|head -n$i|tail -n1)"; sleep 10m; i=$(expr $i + 1); done

Script calls the command ‘sms’ – you can define that command however you want. In my case, its a variation of this script.

Send Text Once Every 15 Mins

Command to send a text to any phone once every 15 mins.


while [ 1 ]; do sms NUMBER_GOES_HERE "$(date '+%I:%M %p') Hey Anju. Still awake?"; sleep 15m; done

Script calls the command ‘sms’ – you can define that command however you want. In my case, its a variation of this script.

Generate Password

Command to generate a random password…


openssl rand -base64 6

Watch for Ubuntu 9.10 Launch

This script will run check for ubuntu launch once every 5 mins and let you know if there is an launch.


while [ 1 ]; do if [ -z "`curl -I "http://cdimage.ubuntu.com/releases/9.10/release/"|grep "404"`" ]; then kdialog --msgbox "9.10 Released"; exit; fi; sleep 300;  done