Posts

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 …

BSNL Dataone Auto Downloader

Bsnl(India) provides an account that has 2am to 8am unlimited download. It was not easy to wake up at 2am and switch on the computer and sleep again. So I tried to find a method to switch on the computer automatically at 2am and download and shutdown at 8a …

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 …

Change Timezone in Linux from command line

Changing the timezone in linux is done in a weird method. There is no configuration file where you can edit and change timezone. The method is simple and very easy. You need to link to the timezone you need. Find the timezone file you need in /usr/share/zo …

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  …

Reminder for Gnome Panel

This is the program that lets us to enter the text and time at which it should be reminded me. The command has the following options -d: date eg:  17/3/2009 -t : time [ It’s should be entered as 24hr clock] eg:   20:00:00 -r : reminder text [ It sho …

Group by Date when Stored in Mysql DataBase as Date Time

I have a table called date_count with 2 columns one is a value and another is a date time, say called date_time in mysql. Date Time in mysql is stored as dd-mm-yy hh:mm:ss. The issue comes when I need to get the number of rows per day. As its stored as dat …

Automatic Desktop Wallpaper Changer for Linux

I have a lot of wallpaper that I wanted to switch automatically. After a lot of search i found that there a command way to control all the gnome settings. So I the command I used is “gconftool-2″. So code is like:




#!/bin/bash
folder="/home/rsr …

Microsoft Servers in Linux

Well this is funny Microsoft has it’s ” download.microsoft.com” servers running in linux. Good going guys. You people know what’s the best suited ones. But do you know a product of yours called Windows Server edition?




$sudo nmap -O download.micros …

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 …