Posts
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: Related Posts: Posts on Java Batch Insert/Update For Mysql In Java Recent Searches Invisible On Gmail Chat Xmpppy Python Presence Gtalk Problem Offline Can Still Receive Message Mysql Select Row By Row [...]
Installing Django on Dreamhost
Installing Django in Dreamhost and getting it to run wasn’t straight forward at-least to me. There was lot of issues such as python bin directory not accessible as its shared and so. Related Posts: Posts on Python Cron A Django Program Recent Searches Repodata Yum Repository Point Yum To Dvd Repo Adiun Script To See [...]
Get the nth Word from a text field in mysql
I had a requirement to get the nth word out of a string and sort or order by the same. This is used when the text is stored in a purticular format and you would want to order it according to that or group it or so on. Related Posts: Posts on Java Batch Insert/Update [...]
Display row number in Mysql Select Query
How many times did want to have the row number or the position of the row in the selected query? I had many cases where I needed this feature. I needed the feature for printing the rank of a person where each row is the mark of the person. So lets see how to implement [...]
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 $HISTFILESIZE variable using the following command Related [...]
How to Save file in vi not opened with sudo
It has happened to me a lot of times that i edit a file in vi. I insert and edit a lot and finally when I try to save it I find that I dont have permission for it. If only I had opened it with sudo. I found a solution for this issue. It [...]
Auto Away Notifier for Pidgin in Perl
Whenever I am away from laptop my chat buddies leave me lots message and finally lots of “You there???”. So I thought of making a script that would inform my buddies that I am away when someone sends me a message. This method works with Pigin API. I have used /proc/acpi/button/lid/C267/state file to find if [...]
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 8am. Although the I thought the idea [...]
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 Related Posts: Posts on Interview More Than 100% [...]
Display Reminders In Gnome Panel
It was a long standing requirement of mine to create a reminder software or something which can keep me reminding of things as I always keep forgetting things. So I made a reminder that displays my reminders on the Gnome Panel. It looks something like this: Related Posts: Posts on Interview More Than 100% CPU [...]