Posts

Sort according to the nth Column in Shell Script

You have a file that has multiple columns separated by a specific delimiter and you need to sort it according to a specific column which need not be the 1st column. If its not the 1st column then ordinary sort wont work. So we need to use the parameters of …

Birthday Reminder For Gnome Panel

This program checks the file /home/rsrijith/shell/birthday_reminder.txt to find the upcoming birthdays in 20 days and writes into the file /home/rsrijith/shell/birthdays. There is a file called /home/rsrijith/shell/birthdays1, the difference between it and …

Customizing Mysql Prompt For multiple Servers

If you are using mysql regularly on multiple servers its really useful to have the promt in mysql to show something more than mysql>. It would be useful if it showed the username,hostname, current database and things like that. So how to do this. One m …

Important MySQL DBA Interview Questions

Here are a few sets of interview questions expected for MySQL DBA position.These are compilation of the usual questions from various DBA texts: What is Log Switch? – The point at which ORACLE ends writing to one online redo log file and begins writing to …

Find Invisible Users In Gmail

Finding who is invisible is something that I always wanted to do.It’s always fun to ping a person who feels none can see him/her online. While studying XMPP protocol I found out that even when the person is offline the chat client knows that person is onli …

Automatic Command Archive

The default command storing size of ubuntu is 500 commands. It stores the commands in home folder in the file “.bash_history” . The problem is 500 commands is too short of a size. One method is to increase the command size to a large value by changing the  …

Tab Feature in Vim

Vim is one of the simplest looking but most powerful editor I have seen. So thought of listing a few interesting one that I came across. Tab Opening of Files. There are two methods of starting files in tabs. By opening vi the files you want to open: Thi …

Enable Multiple Login in Same Account in Gmail

Gmail recently started merging its App accounts to Gmail. Hence you wont be able to login into both the accounts in the same browser now. Here is a way on which you can still do it. This can be done for people who have multiple gmail accounts and want to b …

Script for Auto Copying of Cds/Dvds

Here is a script that i created for automatically copying all the files in cd to a folder and ejecting and waiting for the next cd. So here is how it works. You need to change the folder names and paths accordingly. And the shell script as




./cdcop …

Auto Backup using Dropbox in Linux/Mac

I had some folders on my disk which I wanted to keep a copy online as a backup and for viewing from other places. Its not always possible to save all the essentials in the drop box folder itself to be auto backed up. Thus I wrote a very small script which  …