Archive for the 'Linux' 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

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.

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

Command to Find Current Ubuntu Version

Run this command to find the installed version of Ubuntu…


cat /etc/lsb-release

top in Batch Mode

Run top in batch mode


top -b -d 10 -n 3